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

    Hello,


    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.


    Regards, 

Need extra support?

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

Learn More

Forum Channels