How to extract table from sharepoint

[Rahul_J]

Hi Team,

How can we extract the table which has 4-5 columns and 50+ rows from SharePoint Excel??

Regards,
Rahul

[TUSHAR_DIWASE (TD)]

HI ,
you can sync SharePoint library with onedrive. so that your folder and files will get reflected into local folder(which is auto sync with sharepoint).

with this way you can use normal excel related activity. After using excel application scope , your excel will get auto updated with latest copy in sharepoint …you can perform necessary action and at the end of excel application scope use some delay so that your changes is get auto sync with sharepoint.
dont use workbook activity.as it wont open excel so auto sync will not happen

[arivu96 (Arivazhagan A)]

HI @Rahul_J,
Please refer below link
UiPath: Advice on how to approach Excel file on Sharepoint - Ask - RobotICT Community

Regards,
Arivu

[ushu (Usha kiranmai)]

@Rahul_J

Reading Excel data from sharepoint

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…