GridPanel directly to Excel.

[emredagli]

Hi Mr. Animal,
I plan to use your extension to export grid to excel.
But my grid use GroupingStore and I have group headers.
I also have group summary rows.
Is there a way to show these rows in excel?

I paste your code to GridView3 Grouping example.
But It is not export grouping headers to excel.

Thanks for your advance.

[Animal]

You'll have to add them yourself. Here's a link to the MS documentation:

http://msdn.microsoft.com/en-us/libr...ffice.10).aspx

What I would do is practice handcoding the XML to represent the grouping rows, and then write the code to generate that XML.

It's pretty simple if you look at the generated XML. It's just a glorified <table>

[emredagli]

Mr. Animal you are right. It is not too difficult to modify.
And I am use renderer functions to show field values.

t += cm.getRenderer(j)(v);

And also I have to modify ss:ExpandedRowCount property to add extra rows (group headers rows).

Thanks for your advance.

[Ronhead]

hi animal

i have a problem with your plugin, error is

document.location='data:application/vnd.ms-excel;base64,' +Base64.encode(grid.getExcelXml());

in ff running too fast but in IE fail it

if you know anything please tell me

saludos!
ron.

[Animal]

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

.

[emredagli]

Hii, Mr Animal,
I search all messages in this thread and people asked that "how can we set file name?".
Given solution is:
Content-Disposition:attachment;filename=export_filename.xls

Should I post new html page with header contains this parameters?

thanks.

[Animal]

I don't think you can do this with data: URLs

http://tools.ietf.org/html/rfc2397

[emredagli]

Hii Mr. Animal,
I search the link you post. But I couldn't find the solution...
I try many combinations like:

linkButton.getEl().child('a', true).href = 'data:application/vnd.ms-excel;Content-Disposition:attachment;filename=export_filename.xls;name=hebe.xls;base64,' + Base64.encode(grid.getExcelXml());
...
linkButton.getEl().child('a', true).href = 'data:application/vnd.ms-excel;Content-Disposition:attachment;file=export_filename.xls;name=hebe.xls;base64,' + Base64.encode(grid.getExcelXml());

When I search in google I found a thread and in there they says that there is no way to do this.
http://groups.google.com/group/mozil...dd1b37053742a4

Do I miss something?
you may regret to writing this component... (Because of questions...)

[Animal]

You missed my last post it seems.

[Animal]

Really, I only wrote it to illustrate how XML spreadsheets can be easily built using XML.

People should take whats illustrated here, and write some code in their server-side to generate the XML.