Append to dynamic excel list
Description
Adds data values to the end of the data-list. You can only add one value per cell.
Input Ports
| Name | dataType | sourceType | required | description |
|---|---|---|---|---|
| Data-list | data-list | link-manual | false | The data-list that should receive the new data-item at the end of the list |
| Cell | text | link-only | true | The spreadsheet cell you want added to the list |
| Text value | text | link-only | true | The text value that will be allocated to the cell |
| Number value | number | link-only | true | The number value that will be allocated to the cell |
| Long-text value | long-text | link-only | true | The long-text value that will be allocated to the cell |
Scenarios
- The user wants to append spreadsheet values to a data-list to use in the
Write dynamic cells to Excel workbookcommand
Use case
Combination
Inputs
- Data-list:
- Cell:
B1 - Text value: ``
- Number value:
1 - Long-text value: ``
Experienced tips
- If the
data-listvalue is empty, the process will continue and append the values to an empty data-list - You can only assign one value to a cell
Output
Search Tags
append cell and value to data-list