anusha2
December 19, 2023, 1:44pm
1
How to read Excel data from SharePoint without downloading it
We are not authorised to download
Please help me on this
Gokul001
December 19, 2023, 1:47pm
2
Hi @anusha2
Welcome back to community
Can you check out this thread
Hello!
I am currently working on an automation that involves sharepoint. Some of the steps I have to do are:
Go to the “Logs” folder and read the “Log.xlsx” document (this is to log the results of the automation)
Go to “Recent Forms” folder, read each form to make sure certain fields are filled out, then record whether or not the correct fields are filled in the Log document
Logic-wise, I understand what I have to do, however my biggest issue is reading the data on sharepoint. I have t…
Hello, I know how to work with Excel that is locally stored in a folder. But how do you work with excel that is stored online, on Sharepoint? I need to read and update multiple cells in excel and I want the result to be accisible by other people...
Reading time: 1 mins 🕑
Likes: 1 ❤
Anil_G
December 19, 2023, 2:28pm
3
@anusha2
You can use office365 activities
The UiPath Documentation Portal - the home of all our valuable information. Find here everything you need to guide you in your automation journey in the UiPath ecosystem, from complex installation guides to quick tutorials, to practical business...
Cheers
@anusha2 You may have to work with your enterprises’ SharePoint team and give you API Client ID and Client Secret which can then be used in SharePoint Custom Activities. This solves access issue.