Export excel does not work for more than 65k records

Support
#1

Hi,

I m trying to export more than 65k record in Excel format it doesn’t work and application gets hanged with message as server connection lost.

I m trying to export by calling uireport runner.

Any solution to export record more than 65k with lo record limitations in excel format and also in quick time.

#2

Excel, from version 8 to to version 11 (Excel 2003) has 65536 rows and 256 columns limit.
Version 12 and onward can handle 1 048 576 rows and 16384 columns.

So this looks like a legacy limitation in export libraries, code using them, or a setting.
Can you try to export to a newer Excel version/format? How about csv or json?

1 Like
#3

Writing in which Excel version does this depends on system compatible to Excel versions or it is included in plugin to use particular version.
If it depends on plugin how to make this write in newer version of Excel.

I tried with csv it is working fine with no rows limitations.

#4

I don’t know how to, or is it possible to set the output version - I have not worked with this plugin yet.
If it works with csv, newer Excel should read it with no problems.

#6

It is by default working on (Excel 2003) has 65536 rows, can you help me to upgrade the excel version in plugin.

#7

Hi,

I am able to export 75k data in Excel but as compare to csv it takes time to write and download file.

csv file gets download with in 20 sec but excel file take 1 min to 2 min to write and download file.

Any solution for minimising export time excel export .

#8

I’ll make an educated guess and say that the export code is probably writing cell by cell which can take time with large datasets, so one would need would need to rewrite the export code to first store the data in a line or even a 2-dimensional array and then block-write it. That will be not a small effort.

Use another export library? Can the users open the csv file with Excel and then Save As in the desired format? Or maybe some sort of external tool or script or macro to open the csv and convert to excel file…

1 Like
#9

Hello @adnan.khan,

I tried to make a test report that exports 75k records, it is generated without problems. Can you send a test project and an example report that reproduces this problem?

Demo project - jmix-reports-export-data.zip (2.1 MB)

Regards,
Nikita