I have an Excel file from which I want to read individual cells in a loop and combine content into a text file.
For example, I’d like to assign cells to variables: A1=var1, B1=var2, C1=var3 and write a text file that combines the variable in this manner: var1 + “and” var2 + “or” + var3.
I want this process to be repeated in a loop for any number of rows in the Excel spreadsheet (A2=var1, B2=var2, C2=var3 etc.), appending another line in the .text file for each row.
I am currently reading the full range from Excel but I can’t assign individual cells to different variables to combine them in the text file in the correct order.
Could anyone provide suggestions on how to tackle this? Please be as descriptive as you can as I am quite new to UI Path.
Thanks for your help.