Definition and Usage
Write data (values, lists, or tables) into a specified range of a worksheet, filling cells sequentially based on the data size. This command allows you to populate Excel worksheets with various types of data, automatically handling the distribution of data across cells from the specified starting position.
Parameter Values
Input parameters
Parameter Name | Description | Required | Options / Notes |
Excel instance | Please select an Excel instance (created via the "Launch Excel" or "Get active Excel worksheet" command) to identify the instance to operate on. | Yes | Must reference a valid Excel instance |
Worksheet name | Specify the worksheet name (leave blank for the active worksheet) | No | If left blank, the active worksheet will be used |
Start row | The row number where the data writing starts | Yes | Can be specified as a number (e.g., 1) |
Start column | The column number or name where the data writing begins | Yes | Can be specified as a letter (e.g., A) or number (e.g., 1) |
Value to write | The value (or values) to be written into the Excel range | Yes | Can be a single value, list, or table |
Error handling
Parameter Name | Description |
Throw error & stop | When an error occurs, the action will trigger an error and stop the execution of the entire app. |
Retry command | If an error occurs, the action will retry the command in an attempt to resolve the issue and continue the process. |
Ignore error & continue | When an error occurs, the action will be ignored, and the workflow will continue without interruption. |
Variables produced
This action doesn't produce any variables.
Using Variables in Conditions
Parameters in this command can accept variables from previous steps. When you see a {x} icon next to a field, you can insert variables by clicking on it. This is particularly useful for dynamically determining the start position or the values to write based on previous operations in your workflow.
Notes
Before using this command, ensure that a valid Excel instance has been created using either the "Launch Excel" or "Get active Excel worksheet" command.
When writing lists or tables, the data will automatically expand from the starting position based on the data structure.
If the provided data is a list, it will be written in a row or column starting from the specified position.
If the provided data is a table, it will be written as a grid of cells with rows and columns.
Ensure that the target range doesn't contain important data that you don't want to overwrite, as this command will replace existing cell values.