Waring message while opening the excel file

mech2soft

Hi,

I have Export to excel functionality on my DataTable. When I open the same (excel), I get the message "the file you are trying to open, 'filename.xls', is in a different format than specified by the file extension.

I am using following file version

DataTables 1.10.4

TableTools 2.2.3

jQuery v1.11.1

MS Office 2010 (to open saved excel).

Need help to suppress/fix above warning message.

Appreciate any help.

Thanks,

Praveen

allan

The only option is to rename the created file to be a CSV file - since that is what it technically is. It is not an XLS file (search the forum and there are a number of threads about this).

So I would suggest using the CSV button rather than Excel.

Allan