Set Cell Activity
The Set Cell activity allows the user to write a specific value into a designated cell or range within an Excel worksheet. This activity is essential for updating spreadsheets, generating reports, or recording data processing results dynamically.
| Field | Description | Requirement |
|---|---|---|
| Excel name | Specifies the reference name of the Excel instance to be modified. | Required |
| Sheet name | Defines the name of the worksheet where the value will be written. Defaults to the active sheet if left blank. | Optional |
| Range | Indicates the specific cell address (e.g., "A1") or range where the value should be placed. | Optional |
| Cell Value | The data or variable content to be written into the specified cell or range. | Optional |
Action Types & Examples
Write to Cell
- Format:
stringorvariable - Example Result: Writing "Processed" into cell
B2.
Implementation Examples
Field Setup
- Excel name:
${newExcel} - Sheet name:
Sheet1 - Range:
C10orA2:B10 - Cell Value:
1500
Execution Parameters
- Target Instance:
MonthlyReport - Data Write: Value
1500is inserted intoSales_Data!C10.
Technical Notes
If the
Rangefield is left empty, the activity may default to the currently selected cell in the active instance. It is recommended to always specify a range to ensure data integrity during parallel executions.