express 读取表格和生成表格

1 

//读取表格
import xlsx from 'node-xlsx'
import request from 'request'
const fs = require('fs')
var list = xlsx.parse(`${__dirname}/export.xlsx`)

2 .

//生成表格
let data = [
  {
    name: 'firstSheet',
    data: [
      [
        '',
        'partners_proxy_accounts',
        'fact_get_votes',
        'our_proxy_accounts',
        '',
        '',
        '',
        'our_proxy_account',
        'fact_votes',
        'partners_proxy_account'
      ],
      ['11', '22', '33', '44', '', '', '55', '66', '77', '88']
    ]
  },
  {
    name: 'secondSheet',
    data: [
      [
        '',
        'partners_proxy_accounts',
        'fact_get_votes',
        'our_proxy_accounts',
        '',
        '',
        '',
        'our_proxy_account',
        'fact_votes',
        'partners_proxy_account'
      ],
      ['11', '22', '33', '44', '', '', '55', '66', '77', '88']
    ]
  }
]

const range0 = { s: { c: 0, r: 0 }, e: { c: 1, r: 0 } } //此处是合并条件 0,0和1,0是坐标 指的是A1单元格 到A2单元合并
const range1 = { s: { c: 7, r: 0 }, e: { c: 8, r: 0 } } //此处是合并条件 0,0和1,0是坐标 指的是A1单元格 到A2单元合并

const options = {
  '!cols': [
    { wpx: 50 },
    { wpx: 160 },
    { wpx: 120 },
    { wpx: 220 },
    { wpx: 100 },
    { wpx: 100 },
    { wpx: 50 },
    { wpx: 160 },
    { wpx: 120 },
    { wpx: 220 }
  ]
  // '!merges': [range0, range1]
} //如果合并多个单元格,在此处添加 多条合并数组即可

var buffer = xlsx.build(data, options)

fs.writeFileSync(`public/xlsx/xxsaaxss.xlsx`, buffer, 'binary')// 放到public下面文件里