xlsx.js导出代码：新生可期-复发套细胞淋巴瘤患者援助项目项目说明书

const XLSX = require('xlsx'); const workbook = XLSX.utils.book_new(); const worksheet = XLSX.utils.aoa_to_sheet([ ['新生可期-复发套细胞淋巴瘤患者援助项目项目'], ['配送捐赠药物说明书'], ['接受药房：', '', '', '', ''], ['接收地址：', '', '', '', ''], ['配送单号：', '', '', '装箱时间：', ''], ['接收时间：', '', '', '接收温度：', ''], ['指定药师：', '', '', '配送人：', ''], ['配送药品明细：', '', '', '', ''], ['药品名称', '药品规格', '药品批号', '有效期', '数量'], ['康可期/阿可替尼胶囊', '', '', '', ''], ['数量合计', '', '', '', ''], ['药房签收：', '', '', '', ''], ['确认包装完整：', '', '', '', ''], ['其他情况备注', '', '', '', ''], ['接收人签字：', '', '', '盖 章 ：', ''], ]); const range = XLSX.utils.decode_range(worksheet['!ref']); for (let R = range.s.r; R <= range.e.r; ++R) { for (let C = range.s.c; C <= range.e.c; ++C) { const cell = XLSX.utils.encode_cell({ r: R, c: C }); const cellStyle = worksheet[cell] ? worksheet[cell].s : {}; const newCellStyle = Object.assign({}, cellStyle, { border: { top: { style: 'thin', color: { auto: 1 } }, right: { style: 'thin', color: { auto: 1 } }, bottom: { style: 'thin', color: { auto: 1 } }, left: { style: 'thin', color: { auto: 1 } } } }); if (R === 0 && C === 0) { Object.assign(newCellStyle, { font: { size: 14, bold: true, name: 'SimHei' }, alignment: { horizontal: 'center', vertical: 'middle' } }); } else if (R === 1 && C === 0) { Object.assign(newCellStyle, { font: { size: 14, bold: true, name: 'SimHei' }, alignment: { horizontal: 'center', vertical: 'middle' } }); } else if (R === 8 && C === 0) { Object.assign(newCellStyle, { font: { size: 9, name: 'SimSun' } }); } else if (R === 0 || R === 1 || R === 9 || R === 13) { Object.assign(newCellStyle, { font: { size: 14, bold: true, name: 'SimHei' }, alignment: { horizontal: 'center', vertical: 'middle' } }); } else { Object.assign(newCellStyle, { font: { size: 9, name: 'SimSun' } }); } worksheet[cell] = Object.assign({}, worksheet[cell], { s: newCellStyle }); } } workbook.SheetNames.push('Sheet1'); workbook.Sheets['Sheet1'] = worksheet; XLSX.writeFile(workbook, '新生可期-复发套细胞淋巴瘤患者援助项目项目说明书.xlsx');