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);
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.
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?