Hello,

I have been looking into your question and to enable the export of hidden columns, what you need to do is to handle the exportStarted event of the igx-grid-toolbar-exporter component, and in the given function you will set the ignoreColumnsVisibility option to true when exporting to export the hidden as well.

<igx-grid-toolbar-exporter
          [exportCSV]="false"
          [exportExcel]="true"
          (exportStarted)="exportStarted($event)"
        >
</igx-grid-toolbar-exporter>

public exportStarted(args: IgxExporterEvent) {
        args.options.ignoreColumnsVisibility = true;
}

The described scenario could be observed here:

In addition, I have prepared small sample illustrating this behavior which could be found here. Please test it on your side and let me know how it behaves.

If you require any further assistance on the matter, please let me know.

Regards,

Georgi Anastasov

Entry Level Software Developer

Infragistics