使用FileSaver.js保存excel文件 [英] save excel file using FileSaver.js

问题描述

我正在尝试将数据导出到angular js中的excel

I am trying to export data to excel in angular js

1)用户单击一个按钮 2)$ scope.myArray中的数据将保存到excel文件中.

1) User clicks a button 2) Data in $scope.myArray gets saved to excel file.

我尝试过

var blob = new Blob($scope.myArray , {
    type: "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;charset=utf-8"
});
saveAs(blob, "Report.xls");
};

它提示打开excel文件. 但是，每当我尝试打开它时，它都表明文件格式或文件扩展名无效.

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.

任何帮助！

推荐答案

尝试以下代码，以帮助您为您创建一个excel文件.

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");

演示

这篇关于使用FileSaver.js保存excel文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！