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.
Hi,
Can you test the exporting with the latest Service Release?
I realized that the diaplyseqence for the hidden columns had a non zero value and that is what the Exporter was using (not caring about whether the columns was hidden or visible). I made the display sequence "0" for the hidden fields and it almost worked except now I get an exception. I'm attaching the unhadled exception stack...not sure if Im doing something incorrect or the export dll needs fixing.
System.ArgumentOutOfRangeException was unhandled by user code Message=Parameter name: indexActual value was -4. Source=Infragistics4.Web.v10.2 ParamName=index StackTrace: at Infragistics.Excel.WorksheetItemCollection`1.InternalIndexer(Int32 index) at Infragistics.Excel.WorksheetCellCollection.get_Item(Int32 index) at Infragistics.Web.UI.GridControls.WebExcelExporter.ExportGrid(WebDataGrid grid, Worksheet worksheet, Int32& rowIndex, Int32 columnOffset, Int32 outlineLevel) at Infragistics.Web.UI.GridControls.WebExcelExporter.Export(WebDataGrid grid, Worksheet worksheet, Int32 rowOffset, Int32 columnOffset) at Infragistics.Web.UI.GridControls.WebExcelExporter.Export(WebDataGrid grid, Worksheet worksheet) at Infragistics.Web.UI.GridControls.WebExcelExporter.Export(WebDataGrid grid, Workbook workbook) at MarketingPortal.Site.ExportToExcel() in C:\ILFC Development\ILFCWebApplications\MarketingPortal\Site.Master.cs:line 59 at MarketingPortal.Site.tb_MasterPage_ButtonClicked(Object sender, ButtonEvent be) in C:\ILFC Development\ILFCWebApplications\MarketingPortal\Site.Master.cs:line 39 at Infragistics.WebUI.UltraWebToolbar.UltraWebToolbar.OnButtonClicked(TBarButton button, Boolean bDepressed) at Infragistics.WebUI.UltraWebToolbar.UltraWebToolbar.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) InnerException: