Use Excel File, duplicate Reference

Help Studio
, ,
1

In the course “Build Automation using Excel Modern Activities”, the instructor uses “In the Excel file, we’ll enter the “Output\ Month Report” file path and reference it as MonthReport.” multiple times, but when I try to do the same, I receive “Error: System.Exception: “MonthReport” is not a valid variable name! Found an item with the same variable name.” and it will not let me enter the value. I don’t see this as a variable under Data Manager, just a reference.

When I download the example project, I don’t get any errors as a result of being built this way, and I can freely edit the references to be the same.

Thanks for any help you can give.

2

@alan.makranczy

Welcome to the community

Can you ahow some screenshots on how you are using

Cheers

3

try to click on analyze file . it will show the errors with two variables of same name .

4

I am running into the exact same problem.
This is what it looks like in my project:

image
image720×969 27.8 KB

This is what it looks like in the sample project:

image
image777×977 30.1 KB

When running analyze file → analyze project on the sample file this is what shows up:

image
image2109×214 27.1 KB

When running analyze file → analyze project on my file this is what shows up:

image
image2080×191 22.1 KB

The error message that shows up after I try to exit the reference as box:
image

You can find the course and files over here: UiPath Academy

Edit: Just tried to change the reference in the sourcefile to “test” and then changed it back and got the same error. Probably it has something to do with different versions of UiPath Studio when the projects was created.

5

Hi @pierre.aberg

I encountered a similar issue with the new version 2.23.3 preview. However, after decreasing the version to UiPath.Excel.Activities=2.16.1, it started working again.

image

please check and let me know.

6

Hi Alan Makranczy, I’ve determined that the issue lies with the reference name used to refer to the workbook in the folder.

  • To resolve this, we need to create a unique reference name for the workbook.
  • As demonstrated in the academy, using the same reference name worked in older versions of Excel (e.g., 2022), but it seems to be causing an error in our newer version.
  • Therefore, the solution is to provide a unique reference name in the “Use File” activity.
  • Please let me know if you’re unable to fix the issue.