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 #VALUE! 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. "File error: data may have been lost."
It happens just on or over the 8000 row mark.