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
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 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.
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
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
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
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
This topic is locked and no more replies can be posted.