Def.
cvs: 逗號分隔型取值格式(英文全稱為Comma Separated Values,簡稱CSV),是一種純文本格式,用來存儲數(shù)據(jù)
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");