1
2
3
4
5
6
7
8
| import * as XLSX from 'xlsx'; // 使用命名导入方式
|
| export function export_json_to_excel(headers, data, filename = '导出数据') {
| const worksheet = XLSX.utils.json_to_sheet(data, { header: headers });
| const workbook = XLSX.utils.book_new();
| XLSX.utils.book_append_sheet(workbook, worksheet, 'Sheet1');
| XLSX.writeFile(workbook, `${filename}.xlsx`);
| }
|
|