Text To Excel

Minimal example:

{
  "sheets": [{
    "name": "Sheet1",
    "headers": ["Name", "Age", "City"],
    "data": [
      ["Alice", 30, "Beijing"],
      ["Bob", 25, "Shanghai"]
    ]
  }]
}

Full-featured example with styles, charts, and validation:

{
  "sheets": [{
    "name": "Sales",
    "title_row": {"text": "Q1 Sales Report", "style": {"font": {"bold": true, "size": 16}}},
    "headers": ["Month", "Revenue", "Growth"],
    "data": [
      ["January", 50000, 0.12],
      ["February", 62000, 0.24],
      ["March", 58000, 0.16]
    ],
    "column_types": ["text", "currency_cny", "percent"],
    "freeze_pane": "A2",
    "auto_filter": true,
    "charts": [{
      "type": "bar",
      "title": "Monthly Revenue",
      "x_column": 1,
      "y_columns": [2],
      "position": "E2"
    }],
    "conditional_formats": [{
      "type": "color_scale",
      "range": "B2:B4"
    }]
  }]
}

Step 4: Generate Excel

1. Write the JSON config to a temp file
2. Run: python3 scripts/generate_excel.py <config.json> <output_path>
3. Verify the file was created
4. Report success with the file path

Style Defaults

The script applies professional defaults automatically:

• Headers: Blue background (#4472C4), white bold text, centered
• Data rows: Alternating gray/white bands, thin borders
• Column widths: Auto-calculated based on content length
• Title row (optional): Large bold text, merged across all columns

Override any default by specifying header_style, data_style, or per-cell styles in the config.

Advanced Features

• Multi-sheet: Add multiple objects to the sheets array
• Merge cells: Use merge_cells with range strings or row/col objects
• Freeze pane: Set freeze_pane to e.g. "A2" to freeze header row
• Auto-filter: Set auto_filter: true to enable dropdown filters
• Charts: Bar, line, pie, area, scatter charts — see references/config_schema.md
• Data validation: Dropdown lists, numeric ranges, date ranges, text length limits
• Conditional formatting: Cell-based rules, color scales, data bars
• Number formats: Predefined (percent, currency_cny, currency_usd, date) or custom Excel format strings
• Print settings: Orientation, paper size, fit-to-page

See full schema: references/config_schema.md