?需求：導出自帶格式的excel表格

1.自定義二維數組格式 導出

全部代碼：

<el-button @click="exportExcel">導出</el-button>
const exportExcel = () => {const data = [['商品', '單價', '數量', '總價'],['A', 100, 1.55, { t: 'n', f: 'B2*C2' }],['B', 200, 2.33, { t: 'n', f: 'B3*C3' }]];const worksheet = utils.aoa_to_sheet(data);const workbook = utils.book_new();utils.book_append_sheet(workbook, worksheet, '銷售數據');writeFile(workbook, '11.xlsx');
};

效果圖：