vue导出excel文档

最新推荐文章于 2024-12-10 23:34:25 发布

老板上菜！

最新推荐文章于 2024-12-10 23:34:25 发布

阅读量165

点赞数

文章标签： vue.js excel 前端

本文链接：https://blog.youkuaiyun.com/qq_55870308/article/details/134192525

版权

npm i exceljs

<button @click="exportExcel">导出Excel</button>

import ExcelJS from 'exceljs';

exportExcel() {
  const workbook = new ExcelJS.Workbook();
  const worksheet = workbook.addWorksheet('Sheet1');
  const data = [
    ['姓名', '年龄'],
    ['Alice', 20],
    ['Bob', 25],
    ['Charlie', 30]
  ];

  // 假设data为要导出的数据数组
  data .forEach(item => {
    worksheet.addRow(item);
  })
  workbook.xlsx.writeBuffer().then((buffer) => {
    const blob = new Blob([buffer], { type: 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet' });
    const url = URL.createObjectURL(blob);
    const link = document.createElement('a');
    link.href = url;
    link.download = 'data.xlsx'; // 下载文件名
    link.click();
  });
 
},