The Complete Production SOP: How to Deploy and Run ExcelJS High-Performance Spreadsheet Read/Write & Streaming in Autonomous AI Agents

---
name: "exceljs-spreadsheet-export-stream"
description: "Read, write, style, and stream massive multi-sheet Excel (.xlsx) workbooks with formulas."
metadata:
  runtime_compatibility: ["codex", "claude-code", "cursor", "windsurf"]
triggers:
  - "export excel file exceljs"
  - "stream large xlsx exceljs"
  - "style excel cells exceljs"
permissions:
  fs_read: true
  fs_write: "workspace"
---

import * as ExcelJS from 'exceljs';
import { createWriteStream } from 'fs';

export async function streamOrdersReport(outputPath: string, recordGenerator: AsyncIterable<any>) {
  const fileStream = createWriteStream(outputPath);
  const workbook = new ExcelJS.stream.xlsx.WorkbookWriter({
    stream: fileStream,
    useStyles: true,
    useSharedStrings: false
  });

  const worksheet = workbook.addWorksheet('Orders');
  worksheet.columns = [
    { header: 'Order ID', key: 'id', width: 15 },
    { header: 'Customer', key: 'customer', width: 25 },
    { header: 'Amount', key: 'amount', width: 15 },
    { header: 'Status', key: 'status', width: 12 }
  ];

  // Style header row
  const headerRow = worksheet.getRow(1);
  headerRow.font = { name: 'Arial', size: 11, bold: true, color: { argb: 'FFFFFFFF' } };
  headerRow.fill = {
    type: 'pattern',
    pattern: 'solid',
    fgColor: { argb: 'FF0F172A' }
  };
  headerRow.commit();

  for await (const record of recordGenerator) {
    const row = worksheet.addRow({
      id: record.id,
      customer: record.customer,
      amount: record.amount,
      status: record.status
    });
    row.commit();
  }

  await worksheet.commit();
  await workbook.commit();
}