Automation-developer-associate-training-(v2023.10) - Excel Automation with Modern Experience in

[wendy.xiong]

I’m on Excel Automation with Modern Experience in “Build Automation using Excel Modern Activities”, I’m following along with the demo but when using the reference name in the Use Excel File activities “MonthReport” I am only able to use it once. The demo video uses it multiple times. What is the issue?

Automation Developer Associate Training (v2023.10) Course | UiPath Academy

[imad-pro (Imad Eddine Berjamy)]

Could you clarify if you’re reinitializing the reference between uses? If you are, try keeping it within the same scope and see if that resolves the issue.

[wendy.xiong]

I was able to correct the one spot but this last one is not working.

This is what’s on the demo video:

[imad-pro (Imad Eddine Berjamy)]

Did you assign MonthReport before?

[imad-pro (Imad Eddine Berjamy)]

Please zip your workflow and drop it. I need to see it so we save time

[wendy.xiong]

ExcelDataConsolidationTemplate.zip (54.9 KB)

[imad-pro (Imad Eddine Berjamy)]

I fixed your bug.
sometimes is going wrong with UiPath here, I did a small hack , instaed of drag a new Use Excel Activity for MonthReport File, I just copied the one from acquisition and pasted it inside Use Sales Excel.
Everything explained in this loom video @wendy.xiong
Loom Video explanation
Good luck

[sharazkm32 (Sharaz K M)]

Adding to above details,

Scope of reference is within the use excel activity only.

Any name should be fine in reference provided you are using the same name within the use excel scope activity. It doesn’t make any difference even if you use difference reference name for the same file from different use excel scope

[singh_sumit (Sumit Singh Tariyal)]

Hey @wendy.xiong the error you are getting because the variable(Reference) is already declared.so you cannot use the same reference in the Same workflow. because the reference is referred as your input file name.so same name cannot be used in two places.
cheers