I know that, the file got wrong format, but when I save as an excel (without changing anything), It works well. But problem is; my users will upload files like that.

Lets cut the chase and see how can we do it : First of all extract the .zip folder of the library file which we have just downloaded and put it in the setup folder where we need to include. Now, ...

I am using PHPExcel 1.8 to generate spreadsheet files in different formats. Both Excel5 and Excel2007 writers works fine but when exporting using OpenDocument Writer data validations are not set at ...