I’m currently working with UiPath Studio version 22.16, and due to the type of license I have, I don’t have access to Connectors in Orchestrator.
I need to update an Excel file stored on SharePoint, either by writing data or modifying specific cells/ranges without relying Online Excel activities.
Any guidance, tips, or experience sharing would be greatly appreciated.
You can try this if possible with you like install OneDrive for Business and sign in with your company credentials then go to the SharePoint document library → Sync → This will create a folder in your local system like C:\Users\<User>\SharePoint\<SiteName>\. So any changes you make locally (with UiPath Excel activities) will automatically sync back to SharePoint in the background.
As per my knowledge you should download the excel file from sharepoint using HTTP Request or sharepoint API, edit/manupulate it locally with excel activities, then upload it back.
If helpful, mark as solution. Happy automation with UiPath