最近有个需求,需要从前端导出Excel文件与xml文件,写个文档记录一下
知识点
Blob
ArrayBuffer
Excel导出
npm包及文档:xlsx,file-saver
demo
写成工具:exportExcel.js
import FileSaver from 'file-saver';
import XLSX from 'xlsx';
const object = 'DATA_OBJECT';
const array = 'DATA_ARRAY';
const s2ab = (s) => {
if (s.length > 0) {
const buf = new ArrayBuffer(s.length);
const view = new Uint8Array(buf);
for (let i = 0; i !== s.length; ++i) {
view[i] = s.charCodeAt(i) & 0xFF;
}
return buf;
}
return new ArrayBuffer();
};
const appendSheet = (appendData) => {
const wookSheet = XLSX.utils.aoa_to_sheet(appendData.excelData