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?
If i dont set FileLimitBehavior then i get following message.
Can't export more rows than MaxExcelRowCount. Use FileLimitBehaviour property if you want to change default behaviour.
I have around 93K rows.
File save as .xlsx format.
So you are not getting an exception, the data is getting truncated. Whta happens if you do not set the FileLimitBehavior?
Here is my sample code...
Infragistics.Excel.
Workbook w = new Infragistics.Excel.Workbook();
w.CurrentFormat = Infragistics.Excel.
WorkbookFormat.Excel2007;
this.ultraGridExcelExporter1.FileLimitBehaviour = Infragistics.Win.UltraWinGrid.ExcelExport.FileLimitBehaviour.TruncateData;
this.ultraGridExcelExporter1.Export(this.ultraGrid1, w.Worksheets[this.Text]);
w.Save(.xlsx ) // Save as .xlsx file name.
I have close to 85K rows,so when i open the xlsx file , it has only 65535 rows.
This is not an Infragistics issue, it's a limitation of Excel. However, NetAdvantage v8.3 allows you to export to Excel 2007 format, which no longer has this limitation.
So when you export, check the orderloads on the Export method and there's an option for the export format. Or, if you don't specify a format, the format will be automatically detected based on the file extension. So if you just change the file extension of the file you export to .xlsx instead of .xls, it will work.
I am also having same issue, try to export more then 65K rows.
I thought Infrragistics 8.3 resolve this issue?