Reputation: 1304
I'm trying to convert a HTML table to XLSX uisng AngularJS or even plain JavaScript.
When I'm converting to XLS using below its downloading fine and a XLS file is opening.
var blob = new Blob([template], {type: "data:application/vnd.ms-excel"});
window.navigator.msSaveOrOpenBlob(blob, "myExcel.xls");
But, my requirement wants the file in XLSX, so I changed the MIME type and extension of file in the same code like below,
var blob = new Blob([template], {type: "data:application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"});
window.navigator.msSaveOrOpenBlob(blob, "myExcel.xlsx");
But when I'm opening the downloaded xlsx file its corrupted and MS office is trowing error popup.
What I'm doing wrong and how I can convert a HTML table to XLSX? Even alternate ideas also accepted.
PS: The table is quite complicated, rows within columns and all, so plugins like ALASQL, JS-XLSX is not helping.
Upvotes: 9
Views: 21900
Reputation: 1
try to edit the file type,
const blob = new Blob([data], {
// type: 'application/vnd.ms-excel;' //old
type: 'application/vnd.openxmlformats- officedocument.spreadsheetml.sheet;
charset=utf-8' //try this new
})
Upvotes: 0
Reputation: 156
The problem may lie in the type XLSX. This post states that it is a zipped set of XLS files. Have a read through. I cannot comment, because my score isn't over 50 yet, so I'm posting as an answer.
https://stackoverflow.com/a/37516332/1425168
Upvotes: 3
Reputation: 889
just try to change mime-type
change it to application/vnd.ms-excel
it works fine with XLSX also.
var blob = new Blob([template], {type: "application/vnd.ms-excel"});
window.navigator.msSaveOrOpenBlob(blob, "myExcel.xlsx");
Try this code.
Upvotes: 1