Hi,

I'm using Xamdatagrid (v9.2) and ExcelExporter (v9.2) to export the grid data to excel. I need to export some of the hidden columns in the grid to excel. I've tried the following two approches.

 1. Set the ExportOptions.ExcludeRecordVisibility = true, before calling ExcelExporter.Export.

2. Handle the BeginExport event of the ExcelExporter, and set the visibility of the collapsed columns to Visible explicitly in the event handler.

e.g. e.DataPresenter.FieldLayouts[0].Fields[0].Visibility = Visibility.Visible;

Neither of the above worked, and only visible columns were exported in both cases.

Please advise how I can get hidden columns to be exported?

Thanks,

Tess