I am new to UIPath and am looking for the best approach to automate the reading of row items in my excel spreadsheet (each row is a unique entry - for example a patient) and then to create individual text files for each row. The text files will then be read by my application.
I assume the best approach is to create a data table from the excel spreadsheet in UIPath? Once I have the data table created how do I transform the rows into files?
My table has four columns, surname, forename, birthdate & patient number. I wish to create a text file for each row in my excel spreadsheet. There are 25 rows in my spreadsheet for testing.
Any help would be gladly appreciated!