GridPanel directly to Excel.

[radtad]

This problem is definitely in your ExportToExcel.js
Try to replace your file with mine - my file works good for me except in certain grids which I do not code completely.

Well I tried your js file with the example array grid. While I receive no errors now in gnumeric on the Linux side, it shows up with XML tags in the columns (see below).

When I open this up in Excel 2000, it shows no data at all. If I open it up in notepad, I see all the tags which is good and the data, so I know the data is there. I attached a copy of this below.

[cocinerox]

Hi, I think you need Excel 2007 to read XML:
http://en.wikipedia.org/wiki/Microso...l#File_formats

[radtad]

Hi, I think you need Excel 2007 to read XML:
http://en.wikipedia.org/wiki/Microso...l#File_formats

Well that would explain it. I should have Wiki'd the format for Excel. Thanks for the response which looks to be the reason.

[DamienValentine]

It's OK. I saw your notepad.txt. It's looking good. I attached screenshot to this letter. It's your report but with my remark in first row - you should remove appropriate line in ExportToExcel.js. Please use search with "SEBN UA" parameter.

[Jul]

If you have Office 2000, Office XP or Office 2003, you can install the Compatibility Pack which will enable you to read and write the new Office 2007 XML based formats.

Download link is here: Compatibility Pack

[DamienValentine]

If you have Office 2000, Office XP or Office 2003, you can install the Compatibility Pack which will enable you to read and write the new Office 2007 XML based formats.

Download link is here: Compatibility Pack

File exported with Animal concept will open in Office 2003, I guess. It's working for me without Compatibility Packs. Or someone installed that software and I don't know about that

[andreyz]

When unloading datetime fields detected a problem. No time to file excel. To address this problem need to change a few lines:

                '<ss:Style ss:Parent="odd" ss:ID="odddate">' +
                    '<ss:NumberFormat ss:Format="dd/mm/yy\ h:mm;@" />' +
                '</ss:Style>' +

               '<ss:Style ss:Parent="even" ss:ID="evenint">' +
                    '<ss:NumberFormat ss:Format="0" />' +
                '</ss:Style>' +

 if (cellType[k] == 'DateTime') {
	                            t += v.format('Y-m-d\\TH:i: s.000'); // no space betwen  i: s
	                        } else {
	                            t += v;
	                        }

[krzak]

One more thing : why don't you use a basic toolbar button for exporting, which will automatically refresh the data url like this :

bbar: new Ext.Toolbar({
            buttons: [{
                id: 'grid-excel-button',
                text: 'Excel',
            handler: function(){
                document.location='data:application/vnd.ms-excel;base64,' +Base64.encode(grid.getExcelXml());
            }
            }]
    })

I don't know why but seems this hung my IE7. The same code works fine with FF2.

[calvouze]

Same here, hung up on IE7, perfect in FF.

Anyone knows why ?

Thanks in advance.


Edit: not possible :

This needs a browser that supports data URLs. FF, Opera and IE8 will support this.

Tested on FF2 and Opera 9.

[mask_hot]

Hi Animal,

in my grid's ColumnModel I have a CheckBoxSelectionModel with no DataIndex.

How do I ignore this column in the export?

thx