GridPanel directly to Excel.

[Foggy]

Really nice extension, thanks for that animal.
Maybe a better solution would be to send the Excel xml to a backend and create a file? In this case you are not rely on any browser stuff...

[Animal]

Well, if there's going to be a backend involved, it's better that that should just produce the XML itself. It has all the data, so it should just be able to process it into a valid XML spreadsheet. In our app, we have an Excel export button, but it just requests a document to be generated from the server, it does not send any info up.

[Foggy]

it's better that that should just produce the XML itself. It has all the data, so it should just be able to process it into a valid XML spreadsheet.

Of course, you are right

[galdaka]

Works fine!!

Good work!!

[ghyster]

I found some bug with a grid containing hidden columns, there is a mismatch between excel cells type and values when you have different types of data

when retrieving the cell types I added a specific var for incrementation:

var k=0;
for (var j = 0; j < cm.getColumnCount(); j++) {
	if (includeHidden || !cm.isHidden(j)) {
		var v = r[cm.getDataIndex(j)];
		t += '<ss:Cell ss:StyleID="' + cellClass + cellTypeClass[k] + '"><ss:Data ss:Type="' + cellType[k] + '">';
		if (cellType[k] == 'DateTime') {
			t += v.format('Y-m-d');
		} else {
			t += v;
		}
		t +='</ss:Data></ss:Cell>';
		k++;
	}
}

It works for me with this update

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());
			}
    		}]
	})

[gelleneu]

And it will only works on ie8+ ? @Galdaka: you tested it on IE6?

[Animal]

I found some bug with a grid containing hidden columns, there is a mismatch between excel cells type and values when you have different types of data

when retrieving the cell types I added a specific var for incrementation:

var k=0;
for (var j = 0; j < cm.getColumnCount(); j++) {
	if (includeHidden || !cm.isHidden(j)) {
		var v = r[cm.getDataIndex(j)];
		t += '<ss:Cell ss:StyleID="' + cellClass + cellTypeClass[k] + '"><ss:Data ss:Type="' + cellType[k] + '">';
		if (cellType[k] == 'DateTime') {
			t += v.format('Y-m-d');
		} else {
			t += v;
		}
		t +='</ss:Data></ss:Cell>';
		k++;
	}
}

It works for me with this update

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());
			}
    		}]
	})

OK, thanks for this info. Can you bump this thread tomorrow, and I'll try ity out with hidden columns and fix it.

Yes, I was thinking of different ways to make the download smoother, if that works in all cases, I'll change the demo to use that.

[anujg]

Great plugin Animal, I have a server side paging in my grid and I want to be able to export to excel , doing it on the server side is fine with me, but how do I bring up a file download dialog box once the data is back from the server? I am quite new to Ext and this simple thing is taking me a long time...

Also, in my toolbar I have a button "export to Excel" , and I want it to export only the data on the current page, not the whole store data, so how do I pass along the current data to the server side to generate a XML? any ideas ?

[Animal]

If you just want the current page, then you can do it on the client.

If you are doing it on the server, that's totally up to you.

[sanjshah]

Hi,

I'm testing this but getting an error message:

unterminated string constant 

Any help? please!