Save Excel more than 65536 Rows

Posted by: taehyongi on 8 September 2017, 1:56 pm EST

  • Posted 8 September 2017, 1:56 pm EST

    Hi. I am a Korean. So My English ....zzz 

    I have a problem.

     Grid have 70000 Rows.

     I used "SaveExcel" Method.

     But Last Row Number is 65536

     So I searched this Forums about same issue

    I found "FarPoint.Excel.ExcelSaveFlags"

    I cannot find "UseOOXMLFormat" flag

     How can I solve this problem

  • Replied 8 September 2017, 1:56 pm EST


    Make sure you save the file as .xlsx,using UseOOXMLFormat while exporting to excel.Below is the code snippet  that exports a large file to excel with 70000 Rows.

    FpSpread1.Sheets(0).RowCount = 70000

    Dim f As String

    f = "D:\mptest.xlsx"

    Dim s As New System.IO.FileStream(f, IO.FileMode.Create, IO.FileAccess.ReadWrite)

    FpSpread1.SaveExcel(s, FarPoint.Excel.ExcelSaveFlags.UseOOXMLFormat)


    I Hope it will help you.


Need extra support?

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

Learn More

Forum Channels