Export store to Excel

@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.

Quote:

---

Originally Posted by SMMJ_Dev

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

Code:

---

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

Code:

---

        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

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.

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 ..

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.

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

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

Thanks in Advance.

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.

is this can work in extjs 4.1.1? thanks

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.