How to export more than 65536 lines to an Excel file ?

Very simple.

Excel used to have a 65536 lines limitation, up until Excel 2007.

Now with .xlsx files, this limit has been pushed to 1 million lines.

In NeoGroupe products, if you have to export a table that is more than 65536 lines, simply give an XLSX extension filename for the export.

So if you hit a right click on a table, select “Export to Excel”, then give a name like “Export-20131212.xlsx” and it will export up until 1 million lines.

Alternatively you can also export to XML, which has no limitations other than a 2Gb filesize.