Hi,

was this enhanced somehow in last 5 years? I'm using version 2013.2 and it seems like even hiding column in the resulting worksheet doesn't work.

Any comments? Thanks.

Hi,

We are using 2009.2. and would like to know if customizing Excel Export to "exclude" columns is available in this or any future version. Meaning, out of 5 columns displayed in the grid we would like to export only 3 columns.

Or is it possible to put in a feature request to facilitate the same.

Thanks in advance.

Muthu

Thanks Petar. This way the label and the column data doesn't get exported but I still have the problem that there is an empty column in the exported Excel. Saving the file to csv for eg will add a redundant comma to the csv for the empty column.

For now I've worked around by:

*  removing the concrened columns fromthe layout (setting field.Visibility = Visibility.Collapsed)

* Exporting

* setting visibility back to Visible

Would it be possible for you to raise this as a request for a future release? Similar to how you have SkipRecord

Thanks,

Joe

Hi Joe,

In that case you can register for the HeaderLabelExporting and CellExporting events and use something like this to prevent the exporting:

            if (e.CurrentColumnIndex == 1)

            {

                e.Cancel = true;

            }

Regards Petar.