Grid Export Large Too Slow

[yougotnetParticipant]

I have a grid that will contain anywhere from 7000 to 10000 rows and when exporting to Excel, it has to send that back to the server (save-file.php) and it is very slow to send 20 megs back to the server.

Is there not a faster way of doing this?
If the data is already downloaded in the browser, why do we have to go back to the server to download it again?

[DimitarParticipant]

Hello yougotnet,

The data may be downloaded in the browser, but it is the server-side code which creates the xls file. That is why the data has to be passed to the server first and then the file downloaded from there.

Best Regards,
Dimitar

jQWidgets team
http://www.jqwidgets.com/

[yougotnetParticipant]

Is it possible to compress the data before sending it?

[DimitarParticipant]

Hi yougotnet,

If you wish, you can export the grid to a variable, e.g.:

var data = $("#jqxgrid").jqxGrid('exportdata', 'xls');

and process it however you like client- or server-side. There is no built-in compression functionality, however.

Best Regards,
Dimitar

jQWidgets team
http://www.jqwidgets.com/

[Author]

Posts