js-xlsx

generate.js

let rows = [{}]
let wb = XLSX.utils.book_new()
let ws = XLSX.utils.aoa_to_sheet(rows)

// 设置每一列宽度
ws['!cols'] = [{wpx: 120}, {wpx: 100}, {wpx: 200}, {wpx: 100}]

let name = 'excel 文件'
XLSX.utils.book_append_sheet(wb, ws, name)

ctx.body = XLSX.write(wb, {
  type: 'buffer',
  bookType: 'xlsx'
})

read.js

const file = ctx.request.files.file
const workBook = XLSX.readFile(file.path)
const worksheet = workBook.Sheets[workBook.SheetNames[0]]
rows = XLSX.utils.sheet_to_json(worksheet, {range: 1, defval: ''})