sheetjs导出excel
2020-01-16 本文已影响0人
栗子daisy
sheetjs
npm install xlsx
import XLSX from 'xlsx';
数据转excel
var filename = "file.xlsx"; //文件名称
var data = [[1,2,3],[true, false, null, "sheetjs"],["foo","bar",new Date("2014-02-19T14:30Z"), "0.3"], ["baz", null, "qux"]]; //数据，一定注意需要时二维数组
var ws_name = "Sheet1"; //Excel第一个sheet的名称
var wb = XLSX.utils.book_new(), ws = XLSX.utils.aoa_to_sheet(data);
XLSX.utils.book_append_sheet(wb, ws, ws_name); //将数据添加到工作薄
XLSX.writeFile(wb, filename); //导出Excel
table转excel
var elt = document.getElementById('data-table');
var wb = XLSX.utils.table_to_book(elt, {sheet:"Sheet JS"});
XLSX.write(wb, { bookSST:true, type: 'base64'}) :
XLSX.writeFile(wb, test.xlsx);
| Option Name | Default | Description |
|---|---|---|
| type | Output data encoding (see Output Type below) | |
| cellDates | false | Store dates as type d (default is n) |
| bookSST | false | Generate Shared String Table ** |
| bookType | "xlsx" | Type of Workbook (see below for supported formats) |
| sheet | "" | Name of Worksheet for single-sheet formats ** |
| compression | false | Use ZIP compression for ZIP-based formats ** |
| Props | Override workbook properties when writing ** | |
| themeXLSX | Override theme XML when writing XLSX/XLSB/XLSM ** | |
| ignoreEC | true | Suppress "number as text" errors ** |
————————————————
参考：https://blog.csdn.net/qq_27727251/article/details/97814671
https://www.jianshu.com/p/a1973e58a4b6
https://blog.csdn.net/u014087707/article/details/80193654
https://www.npmjs.com/package/xlsx
