save excel file using FileSaver.js
34,898
Solution 1
Try the following code that will help you to create an excel file for you.
var result = ["Item 1", "Item 3"];
const myJsonString = JSON.stringify(result);
const blob = new Blob([myJsonString], {
type: "application/vnd.ms-excel;charset=utf-8"
});
saveAs(blob, "Report.xls");
Solution 2
csv = ['name','md5','desc']
_.map $scope.trustFileList, (_file) ->
csv.push "\n#{_file.name}"
csv.push _file.md5
csv.push _file.desc
blob = new Blob([csv], {
type: "application/json;charset=utf-8"
});
saveAs(blob, "TrustFileWhiteList.xls");
Author by
Amit Kumar
Microsoft .NET developer, experience over 10 years. Expertise in web application development.
Updated on July 09, 2022Comments
-
Amit Kumar almost 2 years
I am trying to export data to excel in angular js
1) User clicks a button 2) Data in $scope.myArray gets saved to excel file.
I tried
var blob = new Blob($scope.myArray , { type: "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;charset=utf-8" }); saveAs(blob, "Report.xls"); };
It prompts to open the excel file. But whenever I try to open it, it says the file format or file extension is not valid.
Any Help!