• Home
  • About
  • Resume

Posts tagged: grid

UltraWebGridExcelExporter: Export more than 65536 rows

By , 05/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
xMyExporter.Export(xMyGrid)

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