Hello.
I am new to UiPath and am doing the “Automation Developer Associate Training” learning course.
In the course “Excel Automation with the Modern Design in Studio”.
In this course you are creating a new excel file that you refer to as MonthlyReport - this creates a Resource in the Data manager with that name.
The issue I am facing is that once I have created that Resource/Reference I am no longer able to refer to it later in the process, If I write MonthlyReport in a new “Use Excel file” stage in “reference as” I am getting the error that there already is an item with the same name, but in the training video, he does put in the same name in the reference.
I got by this by just naming the “new” references 2 and 3. But I think I am supposed to refer to the same name as it is the same output file.
Later in the same course I am supposed to create a Pivot table in the Output file “MonthReport” and here he is using the reference created earlier in as the Source. but my UiPath is giving me the error that “MonthReport” is not declared, tried with all 3 Resources that I created.
What I am doing wrong? and why does it work in the training material but not for me?
I first thought that those Resources was only able to be referred to in the specific scope of the process. but there is no settings in the resources that defines any scope for the resources.
Hope the issue I am facing is clear enough for anyone to help me move on in the training material.
Are you trying to use the references inside the parent excel application scope confainer within which you are having the use excel containers.?
And
While using modern activity such as duplicates, copy/paste,create pivot table are you getting the references in options for source field by clicking the
“+” icon.?
I ended up figuring out the solution to my issues.
The “Create Pivot” table issue WAS because it was placed outside of the “Use Excel” container - after it was moved inside a use Excel container I was able to reference to the excel in the source field.
The “Multiple resources with same name” issue was not fixable. I believe this has been changed in UiPath since the tutorials was created. The video clearly shows him create “References” with the same name in different “Use Excel” containers. and he is allowed to do that and they show up with the same name in the “Data manager”. I even had someone with experience in UiPath take a look at the video and my process and he could not see why it does work for him in the tutorial and not me, but in the end, it is probably best practice to create references with different names instead of the same name.
