Get the value of a cell
Get the value of a cell
Gets the value of a specific cell of a CSV file, identified by the given column and row. Useful for reading single values without going through the whole file.
Options
CSV file
Select the CSV file already read by a previous CSV file reading action. The field lists the CSV files available in the flow.
Column to get the information
Enter the letter or index of the column that holds the desired value. Example: A, B, C.
Line to get the information
Enter the number of the row that holds the desired value. Example: 1 for the first row.
Separator
Enter the separator character used in the CSV file. The default separator is ; (semicolon).
Returns
Javascript code
js
actions["action-id"].value // content of the cell at the given column and row (Any)
Field selection
- value — content of the cell at the given column and row (Any)
Rules and Conditions
- The CSV file, Column and Line fields are required.
- The CSV file must have been read earlier by the CSV file reading action.
- The separator must match the one used in the file; otherwise the cell may not be found correctly.
- The given row and column must exist in the file.