根据HTML代码生成xlsx.js导出代码 - Excel表格数据导出 - 常规

const XLSX = require('xlsx');

const data = [ [ { v: '新生可期-复发套细胞淋巴瘤患者援助项目项目', s: { font: { size: 14, bold: true }, alignment: { horizontal: 'center' } } } ], [ { v: '配送捐赠药物说明书', s: { font: { size: 14, bold: true }, alignment: { horizontal: 'center' } } } ], [ { v: '接受药房：', s: { font: { size: 11 }, border: { bottom: { style: 'thin', color: { rgb: '000000' } }, right: { style: 'thin', color: { rgb: '000000' } } } } }, { v: '', s: { font: { size: 11 } } }, { v: '', s: { font: { size: 11 } } }, { v: '', s: { font: { size: 11 } } }, { v: '', s: { font: { size: 11 } } } ], [ { v: '接收地址：', s: { font: { size: 11 }, border: { bottom: { style: 'thin', color: { rgb: '000000' } }, right: { style: 'thin', color: { rgb: '000000' } } } } }, { v: '', s: { font: { size: 11 } } }, { v: '', s: { font: { size: 11 } } }, { v: '', s: { font: { size: 11 } } }, { v: '', s: { font: { size: 11 } } } ], [ { v: '配送单号：', s: { font: { size: 11 }, border: { bottom: { style: 'thin', color: { rgb: '000000' } }, right: { style: 'thin', color: { rgb: '000000' } } } } }, { v: '', s: { font: { size: 11 } } }, { v: '', s: { font: { size: 11 } } }, { v: '装箱时间：', s: { font: { size: 9 }, border: { bottom: { style: 'thin', color: { rgb: '000000' } }, right: { style: 'thin', color: { rgb: '000000' } } } } }, { v: '', s: { font: { size: 9 } } } ], [ { v: '接收时间：', s: { font: { size: 9 }, border: { bottom: { style: 'thin', color: { rgb: '000000' } }, right: { style: 'thin', color: { rgb: '000000' } } } } }, { v: '', s: { font: { size: 9 } } }, { v: '', s: { font: { size: 9 } } }, { v: '接收温度：', s: { font: { size: 9 }, border: { bottom: { style: 'thin', color: { rgb: '000000' } }, right: { style: 'thin', color: { rgb: '000000' } } } } }, { v: '', s: { font: { size: 9 } } } ], [ { v: '指定药师：', s: { font: { size: 11 }, border: { bottom: { style: 'thin', color: { rgb: '000000' } }, right: { style: 'thin', color: { rgb: '000000' } } } } }, { v: '', s: { font: { size: 11 } } }, { v: '', s: { font: { size: 11 } } }, { v: '配送人：', s: { font: { size: 11 }, border: { bottom: { style: 'thin', color: { rgb: '000000' } }, right: { style: 'thin', color: { rgb: '000000' } } } } }, { v: '', s: { font: { size: 11 } } } ], [ { v: '配送药品明细：', s: { font: { size: 11 }, border: { bottom: { style: 'thin', color: { rgb: '000000' } }, right: { style: 'thin', color: { rgb: '000000' } } } } }, { v: '', s: { font: { size: 11 } } }, { v: '', s: { font: { size: 11 } } }, { v: '', s: { font: { size: 11 } } }, { v: '', s: { font: { size: 11 } } } ], [ { v: '药品名称', s: { font: { size: 9 }, border: { bottom: { style: 'thin', color: { rgb: '000000' } }, right: { style: 'thin', color: { rgb: '000000' } } } } }, { v: '药品规格', s: { font: { size: 9 }, border: { bottom: { style: 'thin', color: { rgb: '000000' } }, right: { style: 'thin', color: { rgb: '000000' } } } } }, { v: '药品批号', s: { font: { size: 9 }, border: { bottom: { style: 'thin', color: { rgb: '000000' } }, right: { style: 'thin', color: { rgb: '000000' } } } } }, { v: '有效期', s: { font: { size: 9 }, border: { bottom: { style: 'thin', color: { rgb: '000000' } }, right: { style: 'thin', color: { rgb: '000000' } } } } }, { v: '数量', s: { font: { size: 9 }, border: { bottom: { style: 'thin', color: { rgb: '000000' } }, right: { style: 'thin', color: { rgb: '000000' } } } } } ], [ { v: '康可期/阿可替尼胶囊', s: { font: { size: 11 }, border: { bottom: { style: 'thin', color: { rgb: '000000' } }, right: { style: 'thin', color: { rgb: '000000' } } } } }, { v: '', s: { font: { size: 11 } } }, { v: '', s: { font: { size: 9 }, border: { bottom: { style: 'thin', color: { rgb: '000000' } }, right: { style: 'thin', color: { rgb: '000000' } } } } }, { v: '', s: { font: { size: 9 }, border: { bottom: { style: 'thin', color: { rgb: '000000' } }, right: { style: 'thin', color: { rgb: '000000' } } } } }, { v: '', s: { font: { size: 9 }, border: { bottom: { style: 'thin', color: { rgb: '000000' } }, right: { style: 'thin', color: { rgb: '000000' } } } } } ], [ { v: '数量合计', s: { font: { size: 9 }, border: { bottom: { style: 'thin', color: { rgb: '000000' } }, right: { style: 'thin', color: { rgb: '000000' } } } } }, { v: '', s: { font: { size: 9 } } }, { v: '', s: { font: { size: 9 } } }, { v: '', s: { font: { size: 9 } } }, { v: '', s: { font: { size: 9 }, border: { bottom: { style: 'thin', color: { rgb: '000000' } }, right: { style: 'thin', color: { rgb: '000000' } } } } } ], [ { v: '药房签收：', s: { font: { size: 11 }, border: { bottom: { style: 'thin', color: { rgb: '000000' } }, right: { style: 'thin', color: { rgb: '000000' } } } } }, { v: '', s: { font: { size: 11 } } }, { v: '', s: { font: { size: 11 } } }, { v: '', s: { font: { size: 11 } } }, { v: '', s: { font: { size: 11 } } } ], [ { v: '确认包装完整：', s: { font: { size: 9 }, border: { bottom: { style: 'thin', color: { rgb: '000000' } }, right: { style: 'thin', color: { rgb: '000000' } } } } }, { v: '', s: { font: { size: 11 }, border: { bottom: { style: 'thin', color: { rgb: '000000' } }, right: { style: 'thin', color: { rgb: '000000' } } } } }, { v: '', s: { font: { size: 11 } } }, { v: '', s: { font: { size: 11 } } }, { v: '', s: { font: { size: 11 } } } ], [ { v: '其他情况备注', s: { font: { size: 9 }, border: { bottom: { style: 'thin', color: { rgb: '000000' } }, right: { style: 'thin', color: { rgb: '000000' } } } } }, { v: '', s: { font: { size: 11 }, border: { bottom: { style: 'thin', color: { rgb: '000000' } }, right: { style: 'thin', color: { rgb: '000000' } } } } }, { v: '', s: { font: { size: 11 } } }, { v: '', s: { font: { size: 11 } } }, { v: '', s: { font: { size: 11 } } } ], [ { v: '接收人签字：', s: { font: { size: 9 }, border: { bottom: { style: 'thin', color: { rgb: '000000' } }, right: { style: 'thin', color: { rgb: '000000' } } } } }, { v: '', s: { font: { size: 11 }, border: { bottom: { style: 'thin', color: { rgb: '000000' } }, right: { style: 'thin', color: { rgb: '000000' } } } } }, { v: '', s: { font: { size: 11 } } }, { v: '盖章：', s: { font: { size: 9 }, border: { bottom: { style: 'thin', color: { rgb: '000000' } }, right: { style: 'thin', color: { rgb: '000000' } } } } }, { v: '', s: { font: { size: 11 }, border: { bottom: { style: 'thin', color: { rgb: '000000' } }, right: { style: 'thin', color: { rgb: '000000' } } } } } ] ];

const ws = XLSX.utils.aoa_to_sheet(data); const wb = XLSX.utils.book_new(); XLSX.utils.book_append_sheet(wb, ws, 'Sheet1');

XLSX.writeFile(wb, 'output.xlsx');