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.