Excel problem -- Different format than specified by the file extension?
Excel problem -- Different format than specified by the file extension?
I am seeing a problem when trying to open the excel file. If I run the demo at http://datatables.net/release-datatables/extras/TableTools/, use the save to excel option, then try to open the file in excel, I get this error:
"The file you are trying to open, (file name), is in a different format than specified by the file extension...
Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now?"
How can I prevent this warning? My users are getting alarmed/confused.
Thanks
Answers
Hi,
TableTools is a retired plugin. You should make use of the Buttons extension. More specifically in your case, the
excel
.PS: The error isn't really an error. The warning happens because the file isn't in the standard excel format, but a format (which excel recognizes) renamed to a file with a xls extension.
Yup - don't use TableTools. It won't see any future updates!
Allan