RPACSV

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.