Posted 8 September 2017, 2:39 pm EST
I am using the following code in order to export a spread sheet to an Excel file.
FP.SaveExcel(FilePath, FarPoint.Excel.ExcelSaveFlags.NoFormulas Or FarPoint.Excel.ExcelSaveFlags.SaveCustomColumnHeaders)
But only the first 65.536 are exported due to the Excel limit.
My spread sheet have 150.000 rows loaded from a dataset.
There is a way to place the first 65.536 rows into to the "first sheet" of the excel book, the second 65.536 rows into the "second sheet" of the excel book, etc.?
In other words, there is any way that the function FP.SaveExcel, creates a new worksheet into the Excel Workbook for every 65.536 lines?
Thanks in advance,