Error export to Xls using TAdvGridExcelIO

VCL TMS VCL UI Pack
1

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

ExpSaldoExcel.XLSExport(opendialog1.filename+'Xls',t,-1,1);

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?

2

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:

3

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