Add data from file
Enrich any grid with data from an Excel or CSV file.
The added columns and data temporary. They are available until the window is closed.
The added columns are NOT comments/annotations.
Add data from file
From the Grid Actions tab:
Click ‘Add data from file’ and select your file when prompted.
Set to ‘All Rows’ if you don’t want to add only for selected entries.
If you are using a CSV file, set the separator character used (usually a comma) from the submenu list.
Set the mapping key by selecting the header of the matching columns in the file and in the grid.
Select the file columns that you want to add to the grid.
Make sure that your file contains headers. These will be imported as column titles in the grid.
Remove all added data
Use the submenu item of ‘Add data from file’ to remove all data that was added from a file or list.
