With this module, you can read and iterate through a CSV file. It is also possible to generate individual cells as an action.
CSVimport Module
Setup
The module can be set up in the properties, for this the path of the CSV file must be specified in "CSV Path"
Use
Use in code:
With getCSV() the whole CSV is retrieved. After the CSV was fetched, the stored variable can also be used like CSVimport.rows[1][1] in code.
Use as iterator:
with the iterator functionality, parts of the CSV file can be stepped through, the start and end points are specified in the properties.
If the "Row end value" or the "Column end value" is left blank, then there is no limit.
The functionality for this can be found in the iterator folder of the module.
Use for specific cell:
It is possible to create actions for specific cell’s, fill in row and column number and click Create Action to create an action in the “Cell” folder.
Iterator:
In the properties you can set where you want to start and from when it should jump back to the start value. The “getValue” gets the value from the currently set line. It can also be called with 2 arguments.
If the "Row End Value" or the "Column End Value" is empty, then it has no limit.
Info
The module can also be used with text files.
As an example, if used with a .txt file and the separator is set to “ ”, individual words can be iterated through or addressed.
Functions
Action | Info | Input | Output |
init | - | - | |
getCsv | - | - | |
Internal | FOLDER | FOLDER | FOLDER |
fileExist | file (string) | - | |
linesFromFile | file (string) | - | |
Iterator | FOLDER | FOLDER | FOLDER |
resetRow | - | - | |
iterateRow | - | - | |
row | val (int), doSet (bool) | result (int) | |
resetColumn | - | - | |
iterateColumn | - | - | |
column | val (int), doSet (bool) | result (int) | |
getValue | Uses column and row action as preset if called without arguments. Gets the value from selected cell | row (int), column (int) | result (string) |
Cell | FOLDER | FOLDER | FOLDER |
build | (hidden) | - | - |
Pixera 2.0.108 | 18. June 2024
Module Version 1.1