Posted 20 December 2019, 2:01 am EST
Does anyone have the solution with Spread 6 . I am using VB6. I am struggling to export to excel over 65536 rows.?
Forums Home / Spread / Spread for WinForms
Posted by: kithsiri on 20 December 2019, 2:01 am EST
Posted 20 December 2019, 2:01 am EST
Does anyone have the solution with Spread 6 . I am using VB6. I am struggling to export to excel over 65536 rows.?
Posted 22 December 2019, 5:35 pm EST
Hello,
Sorry to mention that Spread6 was declared a legacy product now. It is out of maintenance mode now. Hence, we do not provide support for the same or no bug fixing will be done in the same. I would recommend you use the latest version of Spread i.e Spread 13.
Please refer to the following link for more information:
https://www.grapecity.com/spreadnet
https://www.grapecity.com/spreadnet/docs/v13/online-win/overview.html
Also, for Spread 6, you can try to save excel in Xlsx format as Xls format does not support more than 65536 rows. Please use the following line of code:
fpSpread1.SaveExcel("C:\\excelfile.xlsx", FarPoint.Excel.ExcelSaveFlags.UseOOXMLFormat);
Thanks,
Mohit