Write cells
xlide_write_cellsWrites a block of values and formulas into an Excel worksheet from a start cell, then saves the file. Handles formulas starting with '=' and preserves untouched content.
Instructions
Writes a rectangular block of values and formulas into a worksheet, starting at one cell, and saves the file. Each row of data is a row of the sheet. A string starting with '=' is written as a formula, as you would type it into Excel 365 with no _xlfn prefixes; anything else is a value. A value written over a formula removes that formula, which is what typing into the cell does. Only the rows you touch are rewritten, so charts, styles, pivot caches and the VBA project are untouched. Ask the user before overwriting cells that hold data. Nothing recalculates until Excel next opens the workbook.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| data | Yes | Rows of cell values. Numbers, strings, booleans, null for empty, and strings starting with '=' for formulas. | |
| sheet | Yes | Worksheet name, matched without case. | |
| timeout | No | Seconds allowed if Excel has to do the write. | |
| file_path | Yes | Absolute path to the Excel file. | |
| start_cell | Yes | Top-left cell of the block, such as B2. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||