I’m working on the “Excel Automation with Modern Experience in Studio” course (link).
The exercise has two parts to follow:
In the first part, the tutorial used the same “Reference As” name (MonthReport) for multiple Use Excel File activities. However, in my Studio, I had to give them unique names for it to work.
In the second part, a modern Click activity is used to format the newly created (by automation)MonthReport file. But in my version, it couldn’t identify the file, so I switched to a classic Click activity. Unfortunately, when I run it, I get this error:
In the first part, the tutorial used the same “Reference As” name (MonthReport) for multiple Use Excel Fileactivities. However, in my Studio, I had to give them unique names for it to work.
If you are referring multiple files in the same project - It is required to use unique values only as these references indictae different files. So, what you have done is correct only
For the second part - May I know why you want to click something in excel as most of the excel operations are supported by background activities and it is not a good practice to do via front end
Specific to your error - it show some selector issue. try recapturing the same. A screenshot of the element would be helpful
When using a modern Click activity and trying to capture the element, press F4 to change the UI Framework used for capturing.
This will probably allow you to select the desired button.
It is not recommended to use UI activities for Excel automation. Instead, use the dedicated Excel activities available in UiPath. If a task cannot be accomplished with Excel activities, consider using VBA macros.
Only use UI activities as a last resort when neither Excel activities nor macros can achieve the desired
Thank you! However that’s not the issue. Modern Click activity does not recognize Excel file at all.
Classic Click activity does, but it also doesn’t allow full project to run successfully, as shared in my screenshots.
Then follow below steps,
→ Use the excel process scope activity.
→ Inside of it insert the Use excel file activity. Give path of the excel file which you want to automate.
→ Inside of Use excel file activity insert the Click activity and indicate on the element which you want.
Make sure the excel should open in the background then only modern click activity allow you to indicate on excel.
Yes, the Excel process scope was used first, then multiple Use Excel file activities for different purposes. UI activities were also used inside of the Use Excel File activity. I am sharing screenshots of my workflow.
