Export store to Excel

[rdominelli]

Actually I do not think this is an excel 2010 thing. Prior to upgrading to 4.1 excel would give a warning but would open the file.

Since upgrading to 4.1, the xml produced by the formatter is no longer valid xml. For example

<ss:Alignment ss:Vertical="Top" ss:WrapText="1"/> 0"><ss:Alignment ss:Vertical="Top" ss:WrapText="1"/>

Cleaning up the dupes and removing the extra 0"> fixes the xml so excel is able to open the file again.
Trying to pin down in the Style.js file where the issue is.
Rch

[Aranair]

Mmm, that is possible too I guess.

For me, I modified the code to remove ALOT of tags that were being generated and it does open in Excel 2010 thankfully. It no longer has any formatting though lol.

Also, I'm on 4.1 mm

[rdominelli]

The attached replacement for Style.js seems to do the trick. Place this (after backing up the original) in exporter\excelFormatter

I still get a warning opening the file in excel, but it will open it correctly now.

Rich

[Aranair]

Anyone know if its possible to create a REAL excel spreadsheet that doesn't consist of XML?:P

[shawon]

thanks rdominelli, your file did the trick now its showing the excel file, but shows an warning in the beginning.

Can anyone have any solution for this?

[krishnarn1]

Where can i download the latest code for export excel

[Mental]

I had successfully add button on my panel, but when i am clicking nothing happened, and i don't get any errors.
What can i do with that ?

code:

        {
               xtype: 'exporterbutton',
               store: this.store,
               formatter: 'excel',
               downloadName: 'Trial licenses (new)',
               swfPath: '/extjs/ux/exporter/downloadify.swf',
               downloadImage: '/extjs/ux/exporter/download.png'
        }

I don't using grid, I have panel with buttons and store with data.

Plz help.

[shawon]

I also went through this kind of issues, its definitely failing on some where in the formatter, but that doesn't throws an error. Best is you have debug through the formatter, dig it down and see from which point it failing. I resolved that way.

[Mental]

It seems that this error is in Swf file, I have used flash with debuging and firefox gave this error.

error.jpg

[Mental]

I found why I have this problem, it happens because I didn't set fields for the store and Exporter was not able to send fields to swf.