生成xlsx.js导出代码:复发套细胞淋巴瘤患者援助项目配送单
const XLSX = require('xlsx');
const data = [
['新生可期-复发套细胞淋巴瘤患者援助项目项目'],
['配送捐赠药物说明书'],
['接收药房:'],
['接收地址:'],
['配送单号:', '装箱时间: '],
['药品名称', '药品规格', '药品规格', '药品批号', '有效期', '数量'],
['药品A', '规格A', '规格A', '批号A', '有效期A', '1'],
['药品B', '规格B', '规格B', '批号B', '有效期B', '2'],
['药品C', '规格C', '规格C', '批号C', '有效期C', '3']
];
const ws = XLSX.utils.aoa_to_sheet(data);
const range = { s: { c: 0, r: 0 }, e: { c: 5, r: 8 } };
ws['!merges'] = [{ ...range }];
const borderStyle = { top: { style: 'thin' }, bottom: { style: 'thin' }, left: { style: 'thin' }, right: { style: 'thin' } };
const style = { font: { size: 9, bold: true }, alignment: { horizontal: 'center', vertical: 'center' }, border: borderStyle };
const rangeString = XLSX.utils.encode_range(range);
for (let i = range.s.r; i <= range.e.r; i++) {
for (let j = range.s.c; j <= range.e.c; j++) {
const cell = XLSX.utils.encode_cell({ r: i, c: j });
ws[cell].s = style;
}
}
const wb = XLSX.utils.book_new();
XLSX.utils.book_append_sheet(wb, ws, 'Sheet1');
XLSX.writeFile(wb, 'output.xlsx');
原文地址: https://www.cveoy.top/t/topic/oigg 著作权归作者所有。请勿转载和采集!