Spreadsheet Loop
Command description
Iterate through an .xlsx spreadsheet row by row and run the indented child commands for each row. The command uses a bundled Python library and does not require WPS or Microsoft Office.
Command Input Parameters
| input parameters | Input parameter type | Description |
|---|---|---|
| File Location | str | The full path to the local file, such as C:\xxx |
Command Output Parameters
| Output parameters | Output parameter type | Description |
|---|---|---|
| Row Index | int | |
| Row Content | list[any] | The data of the row, each list element corresponds to a cell of the row, the data format is determined by the xlsx file |
Example
Get data from spreadsheet