由一个 导出 扩展出来的一系列知识点

// 导出所有联系人
router.get('/exportContactsExcel', async function (req, res) {
  let data = [
    {
      name: '第一个sheet',
      data: [['字段1', '字段2', '字段3'], ['1', 'Michael', '99'], ['2', 'Tom', '98']]
    },
    {
      name: '第二个sheet',
      data: [['A1', 'B1'], ['A2', 'B2']]
    }
  ]

  // 将格式化的数据写如excel文件
  let buffer = xlsx.build(data)
  res.setHeader('Content-Type', 'application/vnd.openxmlformats')  // 设置excel的文件拓展名 MIME 类型
  res.setHeader('Content-Disposition', 'attachment; filename=' + 'export.xlsx') // 下载的文件名为export.xlsx
  res.end(buffer) // 返回的是一个buffer
})

.doc application/msword
.dot application/msword
.docx application/vnd.openxmlformats-officedocument.wordprocessingml.document
.dotx application/vnd.openxmlformats-officedocument.wordprocessingml.template
.docm application/vnd.ms-word.document.macroEnabled.12
.dotm application/vnd.ms-word.template.macroEnabled.12
.xls application/vnd.ms-excel
.xlt application/vnd.ms-excel
.xla application/vnd.ms-excel
.xlsx application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
.xltx application/vnd.openxmlformats-officedocument.spreadsheetml.template
.xlsm application/vnd.ms-excel.sheet.macroEnabled.12
.xltm application/vnd.ms-excel.template.macroEnabled.12
.xlam application/vnd.ms-excel.addin.macroEnabled.12
.xlsb application/vnd.ms-excel.sheet.binary.macroEnabled.12
.ppt application/vnd.ms-powerpoint
.pot application/vnd.ms-powerpoint
.pps application/vnd.ms-powerpoint
.ppa application/vnd.ms-powerpoint
.pptx application/vnd.openxmlformats-officedocument.presentationml.presentation
.potx application/vnd.openxmlformats-officedocument.presentationml.template
.ppsx application/vnd.openxmlformats-officedocument.presentationml.slideshow
.ppam application/vnd.ms-powerpoint.addin.macroEnabled.12
.pptm application/vnd.ms-powerpoint.presentation.macroEnabled.12
.potm application/vnd.ms-powerpoint.template.macroEnabled.12
.ppsm application/vnd.ms-powerpoint.slideshow.macroEnabled.12

res.setHeader('Content-Disposition', 'attachment; filename=' + 'export.xlsx') // 下载的文件名为export.xlsx

 window.open('/exportContactsExcel')