Error reading excel from onedrive folder

Help
, , ,
1

Hello folks,

Quick question, I am trying to use an Excel Read Activity on a excel file which is saved on a onedrive local folder. And I keep getting the error from the image:
image

I have already tried to kill all excel processes from the machine before reading the file but it did not fix it.

Any tip on how to manage it?

Thank you all!

2

@FelipeOliveira

Once give it a try with Workbook Read Range activity and check it.

3

Hi @FelipeOliveira

Based on shared path check the one drive folder is there based on path exists activity

give the if condition as BoolPath exists means go to then condition or else invalid path

Thanks
ashwin S

4

I’ve checked for the path and it was there

5

ok do it for a check basis like doing the path exists

if the file exists means

use read range or else say it as an invalid path

Thanks
Ashwin S

6

I have tried it too and got the same error code.
My best guess is the onedrive windows process is locking the file and blocking the excel/uipath API. Is that possible?

7

@FelipeOliveira

Then do one thing. First copy the file from one drive to local shared folder and then read from there.

8

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.