Html to excel file generation gives error file format and extension don't match. How to correct

[Rekha Pai]

Hi,

While downloading html table as excel sheet I am getting the following error. "The file format and extension "abc.xls" don't match.The file could be corrupted or unsafe.Unless you trust the source don't open it. Do you want to open it anyway?" How to get rid of this message?

Regards,
Rekha

[Tim Moores]

HTML is not an Excel sheet - you can't save the former with the file extension of the latter and expect thing to work. Let's take a step back: how exactly are you trying to make this work?

[Rekha Pai]

Hi,

I am creating a Blob and setting the type as ms-excel. This gives the error but if I click yes it neatly opens the table in excel sheet.

Regards,
Rekha

[Tim Moores]

What's the relationship between

I am creating a Blob and setting the type as ms-excel.

and

Html to excel file generation

? How is a blob (which is a database concept) related to HTML (or Excel, for that matter)?

it neatly opens the table in excel sheet.

So the problem is solved now?

[Rekha Pai]

Hi,

I am creating the Blob in javascript. The problem is not solved. I want to get rid of the message "the file format don't match....".

var exceldata = new Blob([tab_text], { type: "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;charset=utf-8" });
var link = document.createElement('a'); //create link download file
link.href = window.URL.createObjectURL(exceldata); // set url for link download
link.setAttribute('download', fileName); //set attribute for link created
document.body.appendChild(link);
link.click();
document.body.removeChild(link);

This is downloading the file. But When I open it in excel it shows the error message.

Regards,
Rekha

[Tim Moores]

I'm not sure it can be avoided. You're creating an HTML file, but treat it as if it were an Excel file - the behavior you describe follows naturally from that.