Skip to main content
Docs
Go to the Studio
Roberty Studio
RPAFile Management

CSV file reading

CSV file reading

Reads a CSV file and returns its content as a list of values. It allows you to configure the separator used in the file to guarantee the correct reading of the data.


Options​

CSV file path​

Enter the full path of the CSV file to be read, including the name and the extension. Example: C:\Desktop\data.csv.

Separator​

Enter the character used as the column separator in the CSV file. The default separator is ; (semicolon), but it may vary depending on the file (e.g. , or |).

Returns​

Javascript code​

js
actions["action-id"].values  // returns a list of values from the CSV file (List)
actions["action-id"].count   // returns the number of lines in the CSV file (Number)

Field selection​

  • values — returns a list of values from the CSV file (List)
  • count — returns the number of lines in the CSV file (Number)

Rules and Conditions​

  • The CSV file path field is required.
  • The separator must match the one used in the file; otherwise, the columns will not be separated correctly.
  • To go through it row by row after the reading, use the For each CSV row or For each CSV column actions.
  • To get or set the value of a specific cell, use Get cell value or Set cell value.