在Angular js中将对象导出为Excel文件

npm install angular-xlsx --save

<script src="https://unpkg.com/xlsx/dist/xlsx.full.min.js"></script>
<script src="https://unpkg.com/file-saver/dist/FileSaver.min.js"></script>

$scope.exportToExcel = function() {
  var data = [
    { name: 'John', age: 30, city: 'New York' },
    { name: 'Jane', age: 25, city: 'London' },
    { name: 'Bob', age: 35, city: 'Paris' }
  ];

  var worksheet = XLSX.utils.json_to_sheet(data);
  var workbook = XLSX.utils.book_new();
  XLSX.utils.book_append_sheet(workbook, worksheet, 'Sheet1');
  var excelBuffer = XLSX.write(workbook, { bookType: 'xlsx', type: 'array' });
  var blob = new Blob([excelBuffer], { type: 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;charset=UTF-8' });
  saveAs(blob, 'data.xlsx');
};

<button ng-click="exportToExcel()">Export to Excel</button>