I’ve watched a lot of tutorials on UI path, and I don’t seem to figure out or find answers to some questions I have, so I’m asking you for some help understanding.
I would like to automate an excel sheet activity I’m doing constantly. I have a big template file with couple of sheets - on each sheet there are document names in one column and then document number in the other. Another excel file is usually generated automatically, and I need to open the template file each time to fill out the document number manually.
What I would like to do using UI Path is to created a process in which a user can submit the template file, and the program will automatically read in all columns from template sheet and the ‘‘need to be filled out’’ sheet and fill out the document number after matching the document names.
The problem is I’m really lost in the creation part. I’ve tried to open up a sequence with a part of excel application scope with the Read Column action but I’m already running into some problems
You need to name the sheets so if a sheet is named differently it immediately busts an error ( can you do it differently, so the program will not need to have the sheet names?)
If a sheet is missing I don’t seem to quite understand how to continue on an error. I’m aware that some functions have ContinueOnError attribute but this doesn’t seem to be the case in Read Column action.
Could anyone help me? Or propose a better way of doing this app? I’m quite lost, most of the tutorials on udemy I’ve spotted don’t quite answer my questions.
And it throws an error everytime the program cannot find the sheet. Am I doing it in the correct way? I want the robot to conitnue with reading sheets if he canot find a specific sheet
It helped!
One more question - how do i assign values in the datatable so the robot “knows” that the document name in cell A1 corresponds to document name in B1?