CSV Operations Addon

This addon provides actions for working with CSV files. You can use this addon to create CSV files during your test execution, merge two CSV files, export a CSV file to JSON file, etc. This addon is also useful for exporting parameters to CSV file during the test execution.
Available Actions
Append values to a CSV file - Appends new values to an existing CSV file
This action has the following inputs:
Values- Specify the values. Values are separated by your chosen delimiter and each row is separated by a new line
Path - Path to where you want the CSV file to be stored on the local machine
Delimiter - The character you want to use to separate the values (e.g. comma, semi-colon etc.). The same delimiter should be used to separate values in the Values field
Create a new CSV file - Creates a CSV file from a given string of values
This action requires the following inputs:
Names - Specify the column names as a list. Separate each item on the list with your choosen delimiter (for example, commas)
Values- Specify the values. Values are separated by your chosen delimiter and each row is separated by a new line
Path - Path to where you want the CSV file to be stored on the local machine
FileName - The name you want to give the file
Delimiter - The character you want to use to separate the values (e.g. comma, semi-colon etc.). The same delimiter should be used to separate values in the Names and Values fields
Delete a column from a CSV file by index - Deletes a column from a CSV file at the specified index
This action requires the following inputs:
Path - Full path to the locally stored CSV file (e.g. C:\Temp\myFile.csv)
Index - The index of the column you wish to delete from the file. The index starts from zero
Export CSV file to json - Opens a CSV file and writes the contents of the file into a json string
This action requires the following inputs:
CsvPath - Full path to the locally stored CSV file (e.g. C:\Temp\myFile.csv)
FileName - The name of the json file that will be stored on your local machine
JsonPath - Path on your local machine where you want to save the json file
Merge two CSV files - Merges a new CSV file to an existing CSV file
This action requires the following inputs:
OldFile - Path to the CSV file you wish to append to (e.g. C:\Temp\old.csv)
NewFile - Path to the CSV file to add to the other file (e.g. C:\Temp\new.csv)
Reverse the order of a CSV file - Reverses the order of the provided CSV file. This action takes in one input
Path - Path to the locally stored CSV file (e.g. C:\Temp\myFile.csv
Read CSV row - Read the entire data of a given row.
filePath - Path to the CSV file you wish to read (e.g. C:\Test\test.csv)
row - the index other the row to read (starts from 1)
Read CSV column - Read the entire data of a given column.
filePath - Path to the CSV file you wish to read (e.g. C:\Test\test.csv)
column- the index other the column to read (starts from 1)
As of version 4.0 of the addon, you are able to specify the encoding of the CSV file being read and written to with an additional optional field.
fileEncoding
By default, the encoding used will be UTF-8 and supports others such as UTF-8, UTF-16, UTF-16LE, UTF-16BE, US-ASCII, ISO-8859-1etc.
​
Random Values from CSV File Addon
Deep Link Toolkit Addon
Last modified 1yr ago