Export all server data in virtual mode.

[williamtourinhoParticipant]

Hi, I’ am using a grid in virtual mode (virtual scrolling).
I need to export all data to excel, but the grid only show’s 20 records each time.
Can you tell me the best way to export all the data (in the server) in virtual mode?

Do I have one grid with virtual mode and another one with all the data and export the data of this hidden grid?
Are is possible to bind all the server data to an javascript variable and then do the export to excel using this variable?

Thank you!

[DimitarParticipant]

Hello williamtourinho,

Unfortunately, the answer to both your questions is negative. In virtual mode the data is loaded on demand and cannot be exported as a whole. The exportdata method cannot be used without a grid.

Best Regards,
Dimitar

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

[NareshParticipant]

Hi,

I’m also having the same issue,
Can i know if there is any solution for this in new versions of Jqwidgets.

Regards,
Naresh

[DimitarParticipant]

Hello Naresh,

You cannot export all rows, because, in virtual mode, the grid data is virtual and is not stored in the grid itself, save for the displayed rows. However, there is a parameter in the exportdata method (the fourth one), which allows you to export a custom array of rows. These can be taken directly from the database and the method would thus export all data. You can learn more about the parameters of exportdata in the jqxGrid API Documentation.

Best Regards,
Dimitar

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

[Author]

Posts