Excel Templater
AI-generatedSummary
Fill an existing Excel template file with data provided as either UI form entries or JSON arrays, then save the modified Excel file to a specified output path.
Inputs
- Template Path (required) — Absolute path to the Excel template .xlsx file to load.
- Output Path (required) — Absolute path where the filled Excel file will be saved.
- Data Input Mode (required) — Choose the method of inputting data: 'UI Form' for structured entries or 'JSON Array' for legacy JSON format.
- Cell Data (JSON) — In 'JSON Array' mode, provide an array of objects each with 'cell' and 'value' to write single cell values.
- Data Entries — In 'UI Form' mode, provide multiple entries which can be single cell writes (cell reference and value) or tables (start cell, array of objects, and optional header writing).
- Options — Additional options including action if the output file already exists (overwrite, rename, or error) and the specific worksheet name to write to within the Excel template.
Output shape
a list of JSON objects each indicating success or failure for that input item
Returns an array with one entry per input item, containing 'success' flag, message or error, and the output file path on success. Supports continueOnFail for error handling on individual items.