Nuxt3 - 使用 SheetJs 将 JSON 转换并下载为 Excel 文件

安装

npm i --save https://cdn.sheetjs.com/xlsx-0.20.1/xlsx-0.20.1.tgz

参考文档：https://docs.sheetjs.com/docs/

代码示例:

<script setup>
import { ref } from 'vue'
import { utils, writeFileXLSX } from 'xlsx'

const pres = ref([
  { name: '小丽', birthday: '1998-02-22' },
  { name: '小美', birthday: '1997-12-10' },
])

function exportFile() {
  const ws = utils.json_to_sheet(pres.value)
  const wb = utils.book_new()
  utils.book_append_sheet(wb, ws, 'Data')
  writeFileXLSX(wb, 'SheetJSVueAoO.xlsx')
}
</script>

<template>
  <button @click="exportFile">导出XLSX</button>
</template>