vue导出excel表
时间: 2023-07-12 21:28:31 浏览: 62
要在Vue中导出Excel表,你可以使用以下步骤:
1. 安装依赖:使用npm或yarn安装两个依赖:
```
npm install file-saver xlsx --save
```
2. 导入依赖:在Vue组件中导入依赖:
```js
import { saveAs } from 'file-saver';
import XLSX from 'xlsx';
```
3. 创建Excel表格:在Vue组件中创建Excel表格,例如:
```js
const worksheet = XLSX.utils.json_to_sheet([
{ Name: 'John Doe', Age: 28 },
{ Name: 'Jane Smith', Age: 32 },
]);
const workbook = XLSX.utils.book_new();
XLSX.utils.book_append_sheet(workbook, worksheet, 'Sheet1');
```
4. 导出Excel表格:在Vue组件中导出Excel表格,例如:
```js
const excelBuffer = XLSX.write(workbook, { bookType: 'xlsx', type: 'array' });
const data = new Blob([excelBuffer], { type: 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;charset=UTF-8' });
saveAs(data, 'example.xlsx');
```
这将导出名为"example.xlsx"的Excel表格。