Hello,
I want to edit an Excel-File which is saved on the sharepoint.
We have the Office365 package and it is working. I have already implemented some activities with Outlook, so I am sure that we have all the application ID and tenant ID, which is needed.
With “Find Files And Folders” I can find the excel saved in the sharepoint Folder, but i can not pass the result, which is a Microsoft.Graph.DriveItem, to open the file?
Find files will give you array of driveitems…you have to use one item only for example if output is the variable then use output(0) …or in find files you have another option as well which is the first which gives you are driveitem…which can be used directly
cheers
Hi,
unfortunately I can not convert Microsoft.Graph.DriveItem (which is the output(0)) to String to use it in “Use Excel File”
If I use output(0).ToString the activity is searching for the file in the folder, where the UiPath proccess is saved.
It can be used in office 365 read range and not in use excel file…
Use excel file works when you have a excel on system and not on the cloud
https://docs.uipath.com/activities/docs/office365-read-range
Or after find files use download file and then use use excel on downloaded file
Cheers
If you want to process it locally using “Use Excel File” (not affecting the file in SharePoint), you need to first download the file.
But the “Read Range” Activity must be used inside the “Use Excel file”.
So there is no way to edit the file inside the sharepoint, without downloading it and uploading it afterwards?
There is a differnet read range you would find under office 365
Please search the activities under office 365 …I have provided a reference link as well
Cheers
Sorry! Somehow I was still using the different Read Range Activities …
Thank you for your patience!! 
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.