Posts tagged: grid

UltraWebGridExcelExporter: Export more than 65536 rows

By , May 14, 2012 12:37 pm

When exporting data from Infragistics UltraWebGrid into Excel using UltraWebGridExcelExporter ordinary a very basic code similar to this is used:

' define Exporter "xMyExporter"
' define UltraWebGrid "xMyGrid" and load grid with data, then:
xMyExporter.ExportMode = UltraWebGrid.ExcelExport.ExportMode.Download

That’s it. But, if your data exceed 65536 rows you will get an error:

System.InvalidOperationException: The maximum number of rows in an excel worksheet with the current format is: 65536

This is not Excel Exporter limitation. Continue reading 'UltraWebGridExcelExporter: Export more than 65536 rows'»

Panorama Theme by Themocracy