JSON 转 Excel 实战案例 - 办公自动化 5 大场景（2026）

1
{
2
  "week": "2026-W01",
3
  "orders": [
4
    {
5
      "orderId": "ORD001",
6
      "product": "iPhone 15",
7
      "category": "手机",
8
      "price": 7999,
9
      "quantity": 2,
10
      "region": "北京",
11
      "salesperson": "张三",
12
      "date": "2026-01-01"
13
    }
14
  ]
15
}

1
// 每周一 9 点执行
2
cron.schedule('0 9 * * 1', async () => {
3
  // 1. 获取数据
4
  const data = await fetchWeeklySales();
5

6
  // 2. 创建 Excel
7
  const wb = createSalesReport(data);
8

9
  // 3. 发送邮件
10
  await sendEmail({
11
    to: 'management@company.com',
12
    subject: `销售周报 ${data.week}`,
13
    attachment: wb
14
  });
15

16
  console.log('报表已发送');
17
});

1
{
2
  "bank": [
3
    {
4
      "date": "2026-01-01",
5
      "description": "收到张三货款",
6
      "amount": 7999,
7
      "balance": 100000,
8
      "type": "income"
9
    }
10
  ],
11
  "orders": [
12
    {
13
      "orderId": "ORD001",
14
      "customer": "张三",
15
      "amount": 7999,
16
      "status": "paid"
17
    }
18
  ]
19
}

1
function createAnalysisReport(data) {
2
  const wb = XLSX.utils.book_new();
3

4
  // 添加各章节
5
  addOverviewSheet(wb, data);
6
  addSalesSheet(wb, data.sales);
7
  addUserSheet(wb, data.users);
8
  addFinanceSheet(wb, data.finance);
9
  addOperationsSheet(wb, data.operations);
10

11
  // 添加图表
12
  addCharts(wb);
13

14
  return wb;
15
}