js导出xlxs

Def.

cvs: 逗号分隔型取值格式（英文全称为Comma Separated Values，简称CSV），是一种纯文本格式，用来存储数据
xlsx: A file with the XLSX file extension is a Microsoft Excel Open XML Format Spreadsheet file. It's an XML-based spreadsheet file created by Microsoft Excel version 2007 and later.

Tools

xlsx
npm: https://www.npmjs.com/package/xlsx
source: https://github.com/sheetjs/js-xlsx

Example

Export from browser to local

import XLSX from 'xlsx'
import FileSaver from 'file-saver'

var worksheet = XLSX.utils.aoa_to_sheet(data);
var new_workbook = XLSX.utils.book_new();
XLSX.utils.book_append_sheet(new_workbook, worksheet, "出货单");
const wbout = XLSX.write(new_workbook, { bookType:'xlsx', bookSST:false, type:'binary' });
FileSaver.saveAs(new Blob([s2ab(wbout)],{type:"application/octet-stream"}), "test.xlsx");