Export store to Excel

[chandrima31]

@scaddenp : your stormtek/Ext.us.Exporter in github is not working in chrome or IE. The download as CSV / Excel buttons are not producing any file-download on click. Kindly suggest me what changes I need to make.

[feiji1983]

I looked at the button code, and it is still messed up.
For now if you need this you can do what I'm currently doing.

Replace your button code with a standard Ext.button.Button

Ext.create('Ext.button.Button',{
    text:'Download as .xls',
    handler:function(button){
        var gridPanel=button.up('gridpanel');
        var dataURL='data:application/vnd.ms-excel;base64,'+Ext.ux.exporter.Exporter.exportGrid(gridPanel);
        window.location.href=dataURL;
    }
})

i did this like

	var exButton = Ext.create('Ext.button.Button',{
			 
			    text:'Download as .xls',
			    handler:function(button){
			        var gridPanel=button.up('gridpanel');
			        var dataURL='data:application/vnd.ms-excel;base64,'+ Ext.ux.exporter.Exporter.exportGrid(gridPanel);
			      //  var dataURL='data:application/vnd.ms-excel;base64,'+ exportGrid(gridPanel);
			        window.location.href=dataURL;
			    }
			})

but got the error message : Ext.ux.exporter is undefined

any one can tell me how to fix it? @wiznia

[aladdina]

There are still issues when use it on ExtJS 4.1.1a, I made some fix on CSV formater, and make it work. Here is the modified code on GitHub:
https://github.com/MasonZhang/Ext.ux.Exporter

Please note: there are some issues when excel parse the exported xml format file, I just make csv format work.

[sarz]

Hi ,
I used your code to export into a xls file while opening in excel it shows some style error problem . How can i view that file without styles attached to it . please say how to remove style from that xls file ..

[mpasacrita@escholar.com]

I've spent the last 2 days going through and trying all the posted solutions here and I found the following result:

All solutions posted here are either:
1) Not compatible with ExtJS4.1
2) Depend on a Flash SWF or the JQuery library
3) Have some issues in either firefox or webkit
4) Suggesting we use a server-side solution

Is there anyone who has gotten this working entirely with the ExtJS 4.x library, and no 3rd party dependencies or cross-browser issues? Thank you in advance.

[sarz]

Yes its true i used 4.1 extjs lib so only it was not working . It works 4.0 and less

[psnprasad]

Hi,
I have the same problem. Any plans to provide fix for 4.1

Thanks in Advance.

[9josh]

May I know how to export the store after i reconfigure the grid? When I try to export the store, it only shows the first column of the grid not after reconfigure. Thanks.

[Garry Hawkins]

is this can work in extjs 4.1.1? thanks

[scaddenp]

Sorry, 4.1.1a broke other things so this one isnt at top of the worry list at the moment. Wont be looking at this till have renderers in tree + Geoext sorted out.