increase number of rows in Datagrid excel export

Hello Everyone, i saw that we can only export 65535 rows in 1 excel file. Is there any way to increase the maximum number of rows like i want to export about 2 or 3 millions rows in 1 file. whereas i unable to use CSV Export due to some restrictions. Thanks in advance :-) 
1 answers

Hi Hamroush,

this limitation is set by the type of export. Mendix exports XLS, which is compatible with older Office packages.

XLSX (and XLSM) can contain up to 1,048,576 rows, but is only compatible with Office > 2007, 


You could try to use the excel exporter and create a custom export.