Excel problem -- Different format than specified by the file extension ??
Excel problem -- Different format than specified by the file extension ??
meoshaugh
Posts: 4Questions: 0Answers: 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,
Marian
"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,
Marian
This discussion has been closed.
Replies
The reason for doing it this way was because it is so much simpler to export a CSV file than an Excel one. I'd like to write a proper Excel exporter sometime, but that will take time to read and understand the Excel file format, and I've not had a chance to do that yet.
One option is simply to rename the file name to .csv, and keep the user interface as saying that it is an Excel file (Excel is quite happy to read csv files). Given that Windows tends to hide the file extension, this seems like a fairly attractive option.
Allan