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?
Hello,
There seems to be a fixed issue for that with number 17050 and it had been referenced in the builds for 8.3 , 9.1 and 9.2 volumes so you should be albe to get it in the latest Service Release which you can download from here: https://ko.infragistics.com/Membership/Default.aspx?panel=Downloads#Downloads
Another thing you should have in mind is that we have two Excel engines and only the newer one can work with Excel 2007 files and thus doesn't have this limitation only when it exports to the *.xlsx fromat. In your Visual Studio Toolbox you can see two UltraGridExcelExporter items. You need to reference the one with "3.0" in the icon
or add the Infragistics3.Excel.v... and Infragistics3.Win.UltraWinGrid.ExcelExport.v... *.dll files directly to your project.
Hope this makes things clearer.
Sincerely,
Petar Monov
Developer Support Engineer
Infragistics Bulgaria
www.infragistics.com/support
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 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 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 ?
You need to export to xlsx format. The easiest way to do that is to simply export to a filename that has an "xlsx" extension. The exporter will detect that and export to the correct format.
Hi Kerry,
I'm not sure exactly what version the fix was made in. My recommendation would be to try getting the latest service release for v9.1, which is free.
If that does not help, then the only way to make it work would be to upgrade to the latest version.
So what versions is this actually fixed in? I'm in 9.1.
Hi,
I tried this out again, just to make sure it works, and it still works just fine for me. So my only guess is that you are not using the latest service release and there is a bug in the old version of NetAdvantage you are using.
I am attaching my sample project here so you can try it out. If my sample works for you, then something is wrong in your application. If my sample produces the same error, then it means it must be a problem with the version of NetAdvantage you are using.
Hello Mike
I am getting below error.
"Can't export more rows than MaxExcelRowCount. Use FileLimitBehaviour property if you want to change default behaviour."
I know we can set FileLimitBehaviour Property it has two value.
Truncate data ,Throw Exception
But as per my understanding
So if i will user Truncate data then it will truncate the data after Excel size limit and Thow exception means it will thorw exception to the client .
While Giving file name i am giving .XlSX extension .
Can you help me now what to do ?