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.
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.
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.
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.