Read & write to a share point excel file

Help Activities
, , ,
1

I want to Read & write to a share point excel file, but i can’t use Office365 packages due lower version( 2020.10.3). So what is alternative solution.

@Anil_G @Yoichi @supermanPunch

Thanks in advance

2

@ManjunathReddy

You will need to authenticate with SharePoint using an HTTP request. You can use HTTP Basic Authentication, NTLM, or other authentication methods supported by your SharePoint environment.
Use an HTTP GET request to access the SharePoint Excel file. You will need to provide the SharePoint file’s URL.
Download the Excel file to your local machine or directly to a memory stream using the HTTP response.
Use the “Excel Application Scope” activity or Excel Interop libraries to read and manipulate the Excel data from the downloaded file.
After processing the data, you can use HTTP POST or PUT requests to upload the modified Excel file back to SharePoint

Cheers…!

3

No It’s not working out

image

4

@ManjunathReddy

you can use uipathteam.sharepoint acitivites

cheers

5

You could try with a lower version of the package.

6

Hi @ManjunathReddy ,

With 2020.10 also I believe we could use the UiPath.MicrosoftOffice365.Activities package (already using in a project).

Could you let us know if you have started using and at any point was stuck or unable to move further ?

There are however certain configurations to be done on the Azure portal.