As we know the max row number allowed in one excel worksheet is 65535.
I want to use UltraGridExcelExporter to export a grid which is with more than 65535 rows to excel but I find that you can only set the StartRow and StartColumn in the Export method. What I want is that you could also set some parameters such as EndRow so I can splite the grid into multi sheets.
Is there any easy solution to this problem?
i am exporting to XLS and even i am not able to find any overload method while exporting the data we can provide the format of excel like xls or xlsx
Can you help me for this ?
Hi Chintan,
Did you get the latest service release for NetAdvantage 10.3?
How to get the latest service release - Infragistics Community
Also, what format are you exporting to? The 65536 line limit is a limitation of Excel, not the Infragistics Excel engine. This limit was lifted, but only when exporting to Excel 2007 format or higher.
I have netadvantage 2010.3
so please can you tell me in this version that export to excel issue solved if we have more than 65000 records .
Because i am facing the issue while exprting the grid view to excel .
So that i have written custom logic for the create new sheet in the same workbook when we have more than 65000 records .
Exporter.RowExported +=
new RowExportedEventHandler
(RowExportedEH);
RowExportedEH:Method where i am checking for the how many record it has exported if its exceed more then
65536 then i am creaing new sheet in same workbook but now i am facing problem of memory leak
can you please help me for this
Thanks
Chintan Rathod
Hi,
It sounds like this is a bug in the old version and you will need to update to the latest version in order to get this to work.
I tried this out in the latest version (10.3) and it works fine for me.
I'm Still receiving error when trying to export to Excel 2007, even when specifying:
Infragistics.Excel.
WorkbookFormat.Excel2007, and saving the file with a .xlsx extension, when using UltraGridExcelExporter.Export(). Is there another method that should be used?
I have already installed the Service Release, and the .dll version is at 9.1.20091.2094.