js 数据库导出excel

// 安装依赖
// npm install xlsx file-saver

import XLSX from 'xlsx';
import { saveAs } from 'file-saver';

// 假设你有一个数据库查询结果数组 data
const data = [
  { name: 'Alice', age: 25 },
  { name: 'Bob', age: 30 }
];

// 将数据转换为工作表
const worksheet = XLSX.utils.json_to_sheet(data);

// 创建一个新的工作簿
const workbook = XLSX.utils.book_new();
XLSX.utils.book_append_sheet(workbook, worksheet, 'Sheet1');

// 将工作簿导出为二进制字符串
const excelBuffer = XLSX.write(workbook, {
  bookType: 'xlsx',
  type: 'array'
});

// 创建 Blob 对象
const blob = new Blob([excelBuffer], { type: 'application/octet-stream' });

// 使用 file-saver 保存文件
saveAs(blob, 'data.xlsx');

const worksheet = XLSX.utils.json_to_sheet(data, { header: ['name', 'age'] });

// 分页导出示例
function exportDataInChunks(data, chunkSize) {
  const workbook = XLSX.utils.book_new();
  for (let i = 0; i < data.length; i += chunkSize) {
    const chunk = data.slice(i, i + chunkSize);
    const worksheet = XLSX.utils.json_to_sheet(chunk);
    XLSX.utils.book_append_sheet(workbook, worksheet, `Sheet${i / chunkSize + 1}`);
  }
  const excelBuffer = XLSX.write(workbook, {
    bookType: 'xlsx',
    type: 'array'
  });
  const blob = new Blob([excelBuffer], { type: 'application/octet-stream' });
  saveAs(blob, 'data.xlsx');
}