Excel format not correct / possibility to save in other?

[riemers]

When i export the xls, i need to upload this to another website which processes these excel files (which is out of my hands) but it fails on the format. If i open it in excel and save the file in excel 95 or 2007 format and then upload it, it works.

Is there a way to save it differently? So say excel 5? Maybe that helps in my situation. Or is this is a PHPExcel issue itself? (after saving btw, the original file is 7kb, the saved one in excel is then 23kb)

[MaatwebsiteSupport]

Hey

Could you try running PHPExcel yourself (outside of laravel) and exporting a xls-file.
Let me know if that works - if not, it's a PHPExcel issue.

[hicode]

I think this problem is not a PHPExcel issue.

Because of Excel5 in PHPEXCEL to export files using BIFF8 and backward compatible with BIFF5

[riemers]

Its a PHPExcel issue, if i use excel2007 i get the same issue. I also tried using a valid excel document, opening it up in PHPExcel and then altering and saving it again and i still have the same issue. Files saved by Excel are about 22kb, while saving new or saving the edited 22kb still result in a 6kb file. So it does do a lot. Somewhere it changes to the wrong format in my case. (i used phpexcel outside laravel too)

[MaatwebsiteSupport]

Could you try to export it to xlsx again, I did some changes to Excel2007 export yesterday.
If it still doesn't work, you will need to send in this issue at https://github.com/PHPOffice/PHPExcel/

[riemers]

I'll give it a shot on monday, from what i can see you added the export Excel2007, but i took a phpexcel copy outside of laravel and tried that. So this will not make a difference? But i will give it a shot though ;)

[MaatwebsiteSupport]

Did it make a difference?

[riemers]

it did not (had some busy days)

[MaatwebsiteSupport]

Try sending in your issue to https://github.com/PHPOffice/PHPExcel/

[riemers]

In the end the client accepted that he opens it, saves it, then it goes ok. Since he always opens it anyways as a verification to check everything is in order anyways.