I use a WebDataGrid to display data. The WebExcelExporter works well with it.

For usability reasons we have built code to allow users to define grid formats that allow show/hide columns, width of the colums and change the visibile index. So all of this is stored in a database.

When users chooses a specific format, the WDG changes accordingly to display the correct columns.

When user attempts to export this customized/formatted grid the excel output contains blank columns for the ones where the wdg had a hidden column.

Hope someone can explain this behaviour and suggest a work around.