CSV file reading
CSV file reading
Reads a CSV file from a local path and loads its content in memory for the iteration and cell access actions of the CSV group.
Options
CSV file path
Full path of the CSV file to read on the machine the robot runs on, for example C:\Desktop\arquivo.csv. Use the picker button next to the field to browse the available files.
Separator
Character used to separate the values between columns in the CSV file. Default: ;.
Returns
Javascript code
js
actions["action-id"].values // list with the CSV file values arranged in rows and columns (List)
actions["action-id"].count // total number of rows in the CSV file (Number)
Field selection
- values — list with the CSV file values arranged in rows and columns (List)
- count — total number of rows in the CSV file (Number)
Rules and Conditions
- The CSV file path and Separator fields are required.
- The given file must exist at the given path on the machine running the robot.
- The separator must match exactly the delimiter used in the file — a wrong separator yields columns with merged values.
- Use this action before For each row in CSV file, For each column in CSV file, Get the value of a cell and Set value of a cell.