nodejs 创建并输出xlsx

install xlsx

1	npm install --save xlsx

demo

import * as xlsx from 'xlsx';

export default async (req, res) => {
  const { type = 'xlsx', name = 'export' } = req.query;

  const Workbook = xlsx.utils.book_new();
  let wsData = [
    { ヘッダ１: 1, ヘッダ２: 2 },
    { ヘッダ１: 'A', ヘッダ２: 'B' }
  ];
  let option = {
    header: ['ヘッダ１', 'ヘッダ２']
  };

  let ws = xlsx.utils.json_to_sheet(wsData, option);

  xlsx.utils.book_append_sheet(Workbook, ws, 'test1');
  xlsx.utils.book_append_sheet(Workbook, ws, 'test2');

  const data = xlsx.write(Workbook, { type: 'buffer', bookType: type });
  res.attachment(`${name}.${type}`);
  res.status(200).send(data);
};

# node

Alipay

Wechat

nodejs 创建并输出xlsx

Like this article? Support the author with

Comments

Categories

Tag Cloud

Recent

Archives

Tags

Recent

Archives

Tags

Your browser is out-of-date!