PDA

View Full Version : Extjs4 Excel export from grid



sonusamal
2 Aug 2012, 4:23 AM
can any one suggest how to export a grid data into Excel using Extjs 4 ? I have search and got solution which working in Extjs 3.0 . link.
http://loianegroner.com/2010/02/extjs-how-to-export-datagrid-to-excel/

fschaeffer
6 Aug 2012, 3:00 AM
There are some solutions available as plugins (search the forum) but in most cases they all have some drawbacks (like missing rows when using paging grid or printing hiddencolumns or not using the filters and so on).

I usually generate the excel file on the server side by creating an iframe with a url providing all necessary information which then sends back the excel file by using the appropriate header.

This is also the answer most devs will give you in this forum.

billtricarico
6 Aug 2012, 8:57 AM
It should be simple enough (?) to create a CSV on the client side from the grid store, so long as all the data is loaded. If the data is only partially loaded (i.e. paged), then generating it on the server is the best way. So long as Excel is installed on the client, the generated CSV will open in Excel.

dawesi
25 Nov 2012, 8:01 PM
https://github.com/VinylFox/ExtJS.ux.DataDrag

zyt
10 Apr 2014, 5:19 PM
can't find the ptype:'xmlexport' .
it's missing some files?