Export to excel is taking a lot of time

hi

i have a code snippet like below

webix.toExcel($$(“rawMvTable”), {
rawValues:true,
filename: “raw.” + window.movieInputVals,
columns:[
{id:“test1”, header:“Report date”, exportType:“string”},
{id:“test2”,header:“Movie name”,exportType:“string”},
{id:“test3”,header:“Movie place”,exportType:“string”},
]
});

If the data is low it is getting exported in a very lesstime , But if the data is huge it takes minimum of 20 mins to open the save location window .And also the file size is very huge i.e 84 mb.

But if i open the file and save again the file size compress to 8 mb

How can i solve this problem?

Can you please help…?

Hello @prasadraju, unfortunately, there is no way to optimize this process in any significant way from our side. Exporting is being handled by a 3-rd party library - SheetJS. As seen in this issue thread:

For performance and compatibility reasons, the default options sacrifice file size

Which means that decreasing the file size further would affect the performance, and the export would take even longer.

But if the data is huge it takes minimum of 20 mins to open the save location window

That being said, even in the case of huge data, the export shouldn’t take this long. Please try running this snippet locally and tell me how long it takes to export the datatable - https://snippet.webix.com/as2ygax2. It took me approximately 10 seconds to export 200k rows, with a file size of 35MB.