ExportToExcel Maximum Rows

Posted by: jodygreening on 8 September 2017, 1:41 pm EST

  • Posted 8 September 2017, 1:41 pm EST

    What is the maximum rows that can be exported with the ExportToExcel function?

    We use the FarPoint Spread 6 component (FarPoint Spread 6.0 (OLEDB) - fpspr6.ocx)

    Once we start getting more then 8000+ rows, we start getting <U>#VALUE!</U> in the columns. And these are not even calculated columns, some of them are simply number/text columns.

    We also get an error upon opening of the file. "<U>File error: data may have been lost</U>."

    It happens just on or over the 8000 row mark.

    Any ideas?

  • Replied 8 September 2017, 1:41 pm EST

    Make sure you have the latest maintenance release for Spread6.  There is no limit to the number of rows that can be exported, except as limited by excel.
Need extra support?

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

Learn More

Forum Channels