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');
生成xlsx.js导出代码:复发套细胞淋巴瘤患者援助项目配送单

原文地址: https://www.cveoy.top/t/topic/oigg 著作权归作者所有。请勿转载和采集!

免费AI点我,无需注册和登录