I am using 2009.1 and for whatever reason I keep getting that error. There will be 975,170 rows to be exported. I am using the below call and the file saves correctly and is about 60MB, but if I try to open it I get that error and if I say Ok to repair it truncates all the data past the Excel 2003 limit of 65,536 rows. Any ideas?
string sFilename = ("D:\\BUILDS\\ProjectDumps\\overall.xlsx");ultraGridExcelExporter1.Export(ultraGrid1,sFilename,WorkbookFormat.Excel2007);
HI,
I am also experiencing the same issue. I have framework developed in .Net2.0 and Excel 2007. I cant open the file that has > 66,000 rows. In this, you guys discussed that we have two option. Either throwing error message or truncating the data. If i truncate the data and put it in worksheet1 and exporting remaining rows to Worksheet2 is possible? if yes how to do that?
Hello , That’s strange, I didn’t find any reason why you should get a error saying that you are over the Excel 2003 limitation, and you have file format excel 2007 and opened it excel 2007. Can you please give me the exact message you got when you open the file, to get more details about ?One more thing are you using the Infragistics3.Excel engine to generate your file and which version?I hope this helps.Sincerely,DimiDeveloper Support EngineerInfragistics, Inc.
That's the problem, I am opening it in Excel 2007 and getting that error.
Hello , The problem you notice is caused by Excel 2003 rows limitation, he can’t open file with more rows. If you are using excel 2003 file format and you are opening it in 2003 there is limitation by the MS Excel to 65,536 rows. In your case you are trying to export file of Excel 2007 format that has bigger limitation and you are opening it in MS Excel 2003 so you will reach this limitation of the 2003 excel format, and the file will be truncated. If you want to open the exported files in Excel 2007 that is the file format you are using the file will be open correctly. If you want to support only Excel 2003, and you are trying to export bigger amount of data you have two options during the export process: to throw exception if the data is bigger than the supported file format, or just to truncate the data : ultraGridExcelExporter1.FileLimitBehaviour = Infragistics.Win.UltraWinGrid.ExcelExport.FileLimitBehaviour.TruncateData;Let me know if that helps.Sincerely,DimiDeveloper Support EngineerInfragistics, Inc.