INVERTS VALUES FROM A KEY-VALUE TALE INTO EXCEL

Inserts values from a key-value collection into a specified Excel file at a target cell location or set of explicit cell addresses. Use this worker when you need to programmatically populate an Excel spreadsheet with key-value data at precise locations within a named sheet.

When to use

Tagged: cell, excel, export, files, insert, key-value, spreadsheet.

Inputs

Label	ID	Type	Default	Required	Description
Excel File	excel_file	file	—	✓	The target Excel workbook (.xlsx / .xls) file into which values will be inserted; must be provided — no default.
Values	values	keyvalue	—	✓	Key-value collection whose values are written into the spreadsheet sequentially; each value maps to a cell starting from the position defined by cell_info.
Type of Insert	insertion_type	select	cell_start	✓	Controls how cells are addressed: ‘cell_start’ fills values sequentially beginning from a single cell (e.g. A1), while ‘specific_cells’ maps each value to an explicit comma-separated list of cells (e.g. A1,B3,C5); defaults to ‘cell_start’.
Cell Info	cell_info	text	A1		Cell address(es) used for insertion — either a single starting cell such as ‘A1’ (for cell_start mode) or a comma-separated list of addresses such as ‘A1,A2,A3’ (for specific_cells mode) that must match the number of values; defaults to ‘A1’.
Sheet name	sheet_name	text	—		Name of the worksheet tab within the workbook where values will be written; if left blank, the first (active) sheet is targeted.

Outputs

Label	ID	Type	Description
Records	records	dataset	Dataset representation of the updated Excel content, reflecting the rows and columns of the modified sheet after value insertion.

Disciplines

• data.dataset.transform
• data.io.excel

---

Auto-generated from platform schema. Worker id: excel_insert_values. Schema hash: 4a42b5c52df6. Hand-curated docs in workerexamples/ override this page when present.