Spread 6 with VB6 , Excel 65536

Posted by: kithsiri on 20 December 2019, 2:01 am EST

    • Post Options:
    • Link

    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

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels