after xls export: cant open file properly

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

Hi Tom,

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

Bob

Hi Bob,

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

Thomas

Hi Bob,

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

Thomas

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.

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

Hi Thomas,

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

Bob

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

Hi Thomas,

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

Bob