How can I work with Excel that is stored online, in Sharepoint? I need to read and update multiple cells in excel

Help Studio
1

How can I work with Excel that is stored online, in Sharepoint? I need to read and update multiple cells in excel

2

If you have Microsoft Office 365, set up in Azure an API connection, and then add the UiPath.MicrosoftOffice365 package. you will use the Microsoft Office 365 Scope activity, and inside that you can access SharePoint file.

Note, depending on your System Admins expertise in Azure, use the IntegratedWindowsAuthentication method. the Secret or Certificate option gives you blanket access to all Azure accounts.

1 Like
3

Iā€™m using Excel application scope, is this correct?

after opening excel you need to click on a tab, do you have any say please

image