How to export html table to excel without warnings?

Question

JavaScript

Hello.
Need to export html table to excel.

To do this, I use a simple link, where href="`data:application/vnd.ms-excel,${tableHtml}`"
tableHtml - html string representation of the table =

this.tableHtml = this.$refs.table.outerHTML.replace(/ /g, '%20');

Everything works, only when opening this excel file they give the following.


I tried several different libraries, nothing helps.
There is only a working sheet.js, but in the free version it does not save formatting and styles.

Answer 1

It is advisable to look at the file that you are saving. Alternatively, try changing xls to xlsx, because they are different formats. Well, this question has already been asked.
How to fix "xls file format does not match file permission" error?