after xls export: cant open file properly

tonkom 14 Jul, 2016
Hi,
we are exporting Form Data to xls, attaching it to an email.
Unfortunately Excel 2013 says "File Format and Filename extension dont match together" when opening the "export.xls" File.

Open Office opens the file without errors. Our Customer cant open the File at all (Microsoft Excel). Are there any special settings/adjustements to do?

Cant attach the xls-File here unfortunately.

Hope you can help.

Thanks,

Thomas
GreyHead 14 Jul, 2016
Hi Tom,

If you zip the file then you should be able to attach it.

Bob
tonkom 14 Jul, 2016
Hi Bob,

thanks for your quick answer.
Here is the created xls file.

Thomas
tonkom 14 Jul, 2016
Hi Bob,

thanks for your quick answer.
Here is the created xls file.

Thomas
GreyHead 15 Jul, 2016
Hi Thomas,

When I test I get the same message but the file then opens OK in Excel - though there are some character set problems*.

If I change the file suffix to .html, then it will open OK without the message.

I had a quick look at the action code - I'm not very familiar with it but I don't see anything obvious to change.

Bob

* Adding a BOM (Byte Order Marker) character might fix this.
tonkom 18 Jul, 2016
Hi Bob,

thanks for your reply. Unfortunately Byte Order Marker didnt fix the Problems with character set. German "Ulauts" are still displayed broken. Additionally, our customer still cant open the file in Excel(I changed the file extension to .html but it doesnt work for them, only opening in a Browser and copying the data into excel-sheet seems to work).
I really apprectiate your help.

Thanks,

Thomas
GreyHead 18 Jul, 2016
Hi Thomas,

You could try using a CSV export instead - that might give you more control.

Bob
tonkom 03 Aug, 2016
Hi Bob,

unfortunately, a second form(on the same website) which worked very well for a long time has the same effect now: attached xls file could not be opened by excel anymore. Im sure that there were no changes made to the form. I wonder how to get that working again? Any ideas appreciated.

Thank you,

Thomas
GreyHead 03 Aug, 2016
Hi Thomas,

There is no file attached, please Click Upload before Submit.

Bob
This topic is locked and no more replies can be posted.