Excel problem -- Different format than specified by the file extension?

Excel problem -- Different format than specified by the file extension?

fsaibenefsaibene Posts: 1Questions: 1Answers: 0

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

  • F12MagicF12Magic Posts: 109Questions: 0Answers: 28

    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.

  • allanallan Posts: 63,818Questions: 1Answers: 10,517 Site admin

    Yup - don't use TableTools. It won't see any future updates!

    Allan

This discussion has been closed.