[CLOSED] How to export grid data as it is displayed on screen

[susanz]

My project requires to export grid data to excel file. the exported data needs to be same as it is displayed on screen. It includes keep the data order, visibility and grouping + summary. Could you give me some advise what is the best way to achieve these ?
Thanks
-szhang

[anup]

Hi,

The example here could help?
https://examples2.ext.net/#/GridPane...ort_Data_Ajax/

I don't know about keeping grouping summary but order and visibility should apply I think? Or you might be able to use the above as the basis for customization. I've had to do a variation where on the client side I need to get the current visible columns only (with many other columns hidden etc) using something like

grid.getRowsValues(options);

If you look at the Ext.NET source code for the above method, you will see a number of options you can provide to the method, such as visibleOnly, currentPageOnly, etc etc.

Also, I created an example long ago of exporting by submitting to another page:
http://forums.ext.net/showthread.php...o-another-page

That uses store.getRecordsValues() method, but you could use the grid's getRowsValues() method instead depending on your needs. Worth looking at the Ext.NET source code for these methods to understand them better.

Hope that helps!

[susanz]

Thank you for you suggestions. I found another example that does grouping. https://druckit.wordpress.com/2013/1...ext-js-4-grid/ but it does not work for IE. I will check more in details on your examples.

By the way where can I find the ext.net source code ? I cannot find a full API description for grid.getRowsValues(options).

Thanks
-szhang

[Daniil]

Hi @susanz,

By the way where can I find the ext.net source code ?

All the Ext.NET sources is in SVN.
http://svn.ext.net/premium

Please notice that the forums and SVN credentials are different. The SVN credentials should be sent to you when you bought a premium support subscription.

I cannot find a full API description for grid.getRowsValues(options).

Please search for "getRowsValues" in this file. There is a list of possible options with a little bit of explanation.
http://svn.ext.net/premium/trunk/Ext.../grid/Panel.js

Anup, thank you for the help on the forums!!!