export csv - table size limitation?

tomish

Hi, we have a rather large datatable (60k+ rows with 10 columns); we have enabled the export buttons according to the documentation and they work well for smaller tables; now, they seem to lock up when we try to export data from the larger tables. Any help is much appreciated! Thanks.

colin

Hi @tomish ,

Yep. I'm seeing it seize up in this simplified example here around that 50k mark, I'll see if we can find any optimisations.

Cheers,

Colin

allan

Yes, at the moment what happens is that the XML for the XLSX file is all created in a single "thread" (for lack of a better term - Javascript is single threaded!). The result is that there are a lot of operations to perform and that can take a long time for the browser to process.

There have been some improvements in later versions, so if you are using an out of date version of the software, make sure that you update.

Beyond that, there are two options:

1. We put the XLSX generation into the background using a web worker.
2. Server-side generation of the XLSX file.

2 offers the most flexibility, but also the harder development path, making 1 perhaps more attractive in the short term.

Allan