Class ExcelWriterAction

Action that creates Excel files from JSON data Supports multiple sheets, formatting, and formulas

Example

// Create simple Excel with one sheet
await runAction({
  ActionName: 'Excel Writer',
  Params: [{
    Name: 'Sheets',
    Value: [{
      name: 'Sales Data',
      data: [
        { Product: 'Widget A', Sales: 100, Revenue: 1000 },
        { Product: 'Widget B', Sales: 150, Revenue: 1500 }
      ]
    }]
  }]
});

// Create Excel with multiple sheets and formatting
await runAction({
  ActionName: 'Excel Writer',
  Params: [{
    Name: 'Sheets',
    Value: [{
      name: 'Q1 Sales',
      data: salesData,
      headers: ['Product', 'Units', 'Revenue'],
      columnWidths: [20, 10, 15],
      styles: {
        headerStyle: { font: { bold: true }, fill: { type: 'pattern', pattern: 'solid', fgColor: { argb: 'FF4472C4' } } }
      }
    }, {
      name: 'Summary',
      data: summaryData
    }]
  }]
});
Copy