fill_excel_template
Fill Excel templates with data at named cells and ranges. Insert cell values and table data into .xlsx files, with optional formula recalculation. Ideal for automating spreadsheet generation.
Instructions
Fill an Excel template with data at named cells and ranges.
Args: template_base64: Base64-encoded Excel template file. values: Cell values to set (key = cell ref like 'Sheet1!A1' or named range, value = content). tables: Table data to insert at named ranges (key = range name, value = row arrays). recalculate: Recalculate formulas after filling (default: true).
Returns: Base64-encoded filled XLSX file.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| template_base64 | Yes | ||
| values | No | ||
| tables | No | ||
| recalculate | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |