Write Data from Excel into Sharepoint

[bharrell (Bryan Harrell)]

Good afternoon,

Does anyone have a sample process doing the following:

Navigate to Sharepoint using authentication
Read and write data from Excel (locally saved) to Sharepoint

Thanks

[AshwinS2 (Ashwin S)]

Hi @bharrell

Use open browser activity and pass the sharepoint url

Use type into for username

Use type secure text for password

Use Click activity and download the excel

Use read range

Use write range

Thanks
AshwinS

[carmen]

Hi @bharrell

If you want to interact with sharepoint is better to use the custom activities.

Here you can find the documentation that can help you

SharePoint custom activities documentation not available

SharePoint_Custom_Activities_Documentation.pdf link is broken @radu_bucur can you update the link to the documentation for the custom sharepoint package? https://go.uipath.com/component/sharepoint-custom-activities-package

[bharrell (Bryan Harrell)]

Thanks so much!

[mridulgrover21]

Hi,
Do anyone have a sample process of how to copy data from excel to sharepoint list which is the quick edit mode? Following the same steps as mentioned above but somehow somewhere i am doing it wrong… If i could see the sample process or any screenshot would help.

[jon.whisman]

@mridulgrover21 : did you ever find a solution for this? I have the same need. We have numerous daily processes where a user takes data from excel and pastes into SharePoint list in quick edit / datasheet mode (to initiate SharePoint workflows, etc.)