GridPanel directly to Excel.

[Surinder singh]

I can't open this site - http://www.developerextensions.com -in IE or Firefox!

sorry i was updating the site, please try it again, if above menu don't work then go to http://www.developerextensions.com/ then select copy/paste grid from left side menu.

if you still cannot get the example working there, mail me at surinder83singh@gmail.com

[alssst]

Hello all!

I have an on-line desktop application, where I mix JAVA (Struts, Spring, Hibernate) and EXTJS.

But one great problem that I always have is export grid's (and selects) to Excel.

I discovery your application and try to use into mine.

But, in any browser (FF2, FF3, IE8, Opera) the button doesn't work.

With FireBug, I Break on Error: Ext is not defined, on the line:

Ext.override(Ext.grid.GridPanel, { 

And, when I click the button, FireBug Break on Error: grid is not defined, at line:

           buttons: [{ 116                id: 'grid-excel-button', 
117                text: 'Export to Excel...', 
118                handler: function(){ 
119                    document.location='data:application/vnd.ms-excel;base64,' + Base64.encode(grid.getExcelXml()); 
120                } 
121            }] 
122       }),

I create a ExportGridToExcel.js in project, create the button and make a handler to him, like all you said, but I'm rookie in EXT and forget something...

Someone can help me?

Thanks a lot!

[darmandovargas@gmail.com]

Hi Animal !!

nice post, but i need to charge the grid data with a JSonSotre, and when i use the button to export, it just export the columns name, but there are no records, i supose tha its because JSonStore takes some time to charge it, but couldn´t fix it, can you helpme please??

[wiznia]

If someone arrives to this page, there's an updated version of ed's exporter that works for extjs 4 here:
http://www.sencha.com/forum/showthre...store-to-Excel

[aggie]

Am using ext4 and i downloaded the scripts on the link you've provided but all am getting is the title "workbook".the Column configurations seem to have some issues.i cant get any data to the worksheets..am using models for the store.Any ideas of what i need to modify??

thanks alot...

[wiznia]

There should be no problem in working with models. Can you put an example of the code? Or maybe debug it and see what is happening...

[bradelsky]

i used this method to export into excel but the downloaded file i get is always corrupted

what could be wrong ? please help

[MuadDib-DK]

hi guys

I have the same problem as aggie. I get some column information, but no data. Also firefox only gives me a .part file...

Any suggestions wiznia?

thanks

[wiznia]

No data? The only thing I can think is to debug it to see what's going on...
The .part thing, I don't know how to get rid of it, but I can open the spreadsheet with excel or openoffice without problem....

[ma1986]

editor thank you for you source
but i find a erro in the file called "gridToExcel" where "getColumnModel" can't work .i know it's work in Ext 3.0 ,Now it's undefined in Ext4.0 .do you have anyway to solute,thank you very much!