Write Cell
Description
The Write Cell activity writes a value to a worksheet cell within an Excel workbook.
The target cell can be identified using a cell address, by specifying row and column indexes, or by appending to the next empty cell on a chosen column or row when Append to End is enabled.
Common settings
Use Process Data to bind supported inputs to workflow values or upstream outputs. See Common Activity Features for shared execution, error-handling, and output-persistence settings. Availability depends on the activity.
Design-Time Configuration
Workbook Configuration
This activity requires an Excel workbook.
Learn more → Excel Workbook Configuration
Worksheet Selection
This activity operates on a worksheet within the workbook.
Learn more → Excel Worksheet Selection
Append to End
When enabled, writes the value at the next empty cell after the last used data on the chosen column or row.
Appending skips gaps within existing data. For example, if B1 and B3 contain values and B2 is empty, appending to column B writes to B4. If A5 and C5 contain values, appending to row 5 writes to D5. For an empty column E, writing starts at E1; for an empty row 10, writing starts at A10.
Default value is False.
Configure this checkbox at design time. Append to End does not support Process Data variables or Liquid expressions.
When Append to End is enabled, cell address and row/column indexes are ignored. Provide either Column Name or Row Number, but not both.
Cell Selection
Selects the cell that will receive the value when Append to End is disabled.
The cell can be identified using either a cell address or a combination of row and column indexes.
Ignored when Append to End is enabled.
Learn more → Worksheet Data Selection
Column Name
When Append to End is enabled, writes in the next empty cell of this column (for example, A).
Provide either Column Name or Row Number, not both.
Row Number
When Append to End is enabled, writes in the next empty cell of this row (for example, 1).
Provide either Column Name or Row Number, not both.
Value
Value to write to the selected cell.
The value can be static text, a number, a date, a formula, or a dynamically generated value from the workflow.
Examples:
- Customer Name
- 12345
- 2026-06-18
- =SUM(A1:A10)
Behavior
When Append to End is disabled, the specified value is written to the selected cell. If the target cell already contains a value, formula, or formatting, only the cell value is replaced. Existing formatting remains unchanged unless modified by another activity.
When Append to End is enabled, the value is written at the next empty cell on the specified column or row. Cell address and row/column indexes do not apply.
A value beginning with = is stored as a formula in the workbook. The server-side workbook engine performs the operation; a desktop Excel session is not required.
Outputs
This activity does not produce any activity-specific outputs.
Execution settings
Configure Wait All Incoming when execution paths converge, and On Error for failure handling. Select Inherit where available to use the workflow-level error policy.
Example: Write a formula
Select the worksheet and target cell D10, then set Value to =SUM(D2:D9). Use Read Cell Formula to verify the stored expression or Read Cell when the next step needs the cell value.