xlsx导出excel

cnpm i -S xlsx

// 导出表格
    const exportDataHandler = () => {
        const wb = XLSX.utils.book_new();
        const jsonData = tableData.Message;
        jsonData.forEach((item: any, index: number) => {
            jsonData[index] = {
                物品名称: item.TypeStandard,
                位置: item.itemiocation,
                订单名称: item.OrderNme,
                时间: item.OrderDte,
                负责人: item.principal,
                备注: item.Remarks,
            };
        });
        const jsonWs = XLSX.utils.json_to_sheet(jsonData);
        jsonWs['!cols'] = [
            { wch: 30 },
            { wch: 8 },
            { wch: 30 },
            { wch: 20 },
            { wch: 10 },
            { wch: 100 },
        ];
        XLSX.utils.book_append_sheet(wb, jsonWs, 'jsonWs');
        XLSX.writeFile(wb, '数据表格.xlsx');
    };