Skip to content

Datatable

In a datatable the top row provides the name of the data stored in each column.

The file is saved as an Excel / csv file and passed as a parameter to the TagUI script via the Task Pane.

The data is passed to the script with each row being a new collection of data. If for example there are 3 rows of data (not counting the header) the flow will be run 3 times.

Excel Datatable

When used as a data input, TagUI takes care of the looping through the data so that all is required is a script file which calls the datatable and the identifiers are replaced with the data from the datatable. No need to loop through the data rows as TagUI takes care of that and repeats based on the number of rows (-1) in the file.

The script file below shows the areas where the variable names are referenced and when run will be replaced by the data in this case 3 times.

Note

Variable names are surrounded with backticks - e.g. exhibitname.

(exhibit_script.tag)

http://localhost/exhibition-form/
click input_1_1
type input_1_1 as `exhibitname`
click input_1_4
type input_1_4 as `description`
click input_1_5
select input_1_5 as `manager`
click input_1_6
type input_1_6 as `startdate`
click input_1_7
type input_1_7 as `enddate`
click input_1_8
type input_1_8 as `website`
click input_1_9
type input_1_9 as `email`
click gform_submit_button_1

This could be run from the command line with the format: tagui [scriptfile] [data file]

tagui exhibit_script.tag .\exhibit_data.csv -e -t

Note

The -e switch runs Microsoft Edge

The -t switch runs the script in turbo mode.


Video: Excel Datatable in RPA

The video shows a csv file being used to complete a web form multiple times with the data in the CSV file.