Export store to Excel

[balajivaikar]

I'm having a datagrid with multi level of headers, and these header-text and row data for these headers are not getting exported to excel. Could anyone help me out ?

[isaac]

I have tried both the example downloads as well as tried to use this in my grid. The sw is working great. But MS Office for Mac 2011 cannot open the xls file (which I rename to xlsx, since xls is binary format) It complains about the format of the file being incorrect. OpenOffice on my linux box will open the downloaded file. But open office and office 2011 on my mac will not. Also, google docs will produce an error when trying to import the xlsx. I think the resulting xlsx file being generated is invalid. But I'm not sure how to proceed.

[wiznia]

Yeah, there are problems with different versions and programs, that's why I ended up using the csv exporter, which is included.
For multi-header grids, I never tried it and it's probably not working right now, pull requests are wellcome in the github project.

[Vasanthoo7]

HI Wiznia, this is a great post. I got everything through with the set up and when I tried to download the file as excel, it downloads it.

When I open the excel file I get the following error.

The file you are trying to open 'download.xls' is in a different format than specified by the extension, Verify that the file is not corrupted. I am using EXTJS4. Can you please help me out with this.

[wiznia]

As I said, there seems to be problems with different versions and programs to open the xls.Try it first with the csv exporter to see if the data gets exported correctly

[Vasanthoo7]

Hi Wiznia, Thanks for the quick reply. the CSV export works well except a few issues:

The first column in the header is taking this character:  

Also the date columns are showing as ####### as the value for start and end date.

===

If you could also point me in the right direction for uploading excel or csv file onto a grid using EXTJS 4. that would be great.

[wiznia]

What is the config for the first column? It should be using the column text or name properties. As for the dates, is the xtype of the column "datecolumn"? Do you have a format specified?
I don't know if it's possible to upload an excel or csv to a grid. You should probably receive the file server side and then serve it to the grid.

[Vasanthoo7]

HI Wiznia, Thank you for replying. I was able to do it successfully with CSV, now the excel, really need to get it working as a excel, It is downloading a excel file, when i open the excel with notepad i see the Grid data in the notepad.

When i open as Excel, it gives me the following error:


The file you are trying to open is in a difffernt format than specified by the extension. Verify that the file is from a trusted source before opening the file. Do you want to open the file now.

When i click on yes, I still am nt able to open the file.

[wiznia]

mmm, you can try the fixes that are in this pull request:
https://github.com/iwiznia/Ext.ux.Exporter/pull/3
If it works I can merge it with the main branch.

[acteon]

I think exporter should not require Button since exporter works without it .