Question

increase number of rows in Datagrid excel export

0

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 :-)

asked 2019-09-16

hamroush sadiq

1 answers

Roy Veenvliet · Answer 1 · 2019-09-16

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.

https://appstore.home.mendix.com/link/app/726/