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'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.
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.