Error export to Xls using TAdvGridExcelIO

When exporting a few thousand of rows from a TAdvStringGrid using TAdvGridExcelIO there is no problem.


When exporting a few hundred thousand rows it stops with and error.
"EListError, list index out of bounds(65536)"

Is this a limitation of Excel?

It is an Excel limitation. The .XLS file format supports 65535 rows only.
For more rows, use the .XLSX format that you can export to via TMS VCL Grid Excel bridge:

This topic was automatically closed 60 minutes after the last reply. New replies are no longer allowed.