.. _auto_excel_insert_values:

*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
------

.. list-table::
   :header-rows: 1
   :widths: 20 20 20 20 20 20

   * - 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
-------

.. list-table::
   :header-rows: 1
   :widths: 20 20 20 20

   * - 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

.. raw:: html

   <hr style="margin-top:2em">
   <p style="font-size:11px;color:#888">
   Auto-generated from <code>platform</code> schema. Worker id: <code>excel_insert_values</code>. Schema hash: <code>4a42b5c52df6</code>. Hand-curated docs in <code>workerexamples/</code> override this page when present.
   </p>