Skip to main content

Update Excel

Synopsis​

This operator allows updating individual cells and entire tables in Excel spreadsheets.

Description​

This operator allows replacing the contents of individual cells or entire tables in an Excel spreadsheet. Both cells and tables are referenced by their name, e.g., A1 or Table1.

When updating a table, the operator will automatically adjust the number of rows and update charts, formatting rules, and names referencing the data. The operator does not support changing the number of columns: the input data must always have the same number of columns as the spreadsheet table.

The operator has limited support for reevaluating formulas: it can revaluate simple expressions but does not support all Excel functions. Formula reevaluation can be disabled using the respective parameter.

Input​

file​

The Excel spreadsheet to update.

data​

The data table to update the spreadsheet with (if any).

Output​

file​

The updated Excel spreadsheet.

through​

The input data table (if any).

Parameters​

Element​

The spreadsheet element to update.

Sheet​

The name of the sheet to update.

Cell​

The cell to update (e.g., A1).

Value​

The value to update the cell with (text or numeric).

Table​

The name of the table to update.

Timezone​

The timezone to use for writing date-time cells.

Update formulas​

Evaluate formulas and update cached values.