Read Range - failed to setting current sheet

Help Studio
, , ,
1

I am working on excel file on SharePoint, but from last few days BOT fails giving exception as “Failed to setting current sheet”.

Need solution to resolve this as this will hamper whole workflow.

1 Like
2

Hey @Amit_Jadhav

You are using SharePoint activities or UiAutomation?

Thanks
#nK

3

I am using Excel activities and giving the SharePoint path of the file.

4

Hey @Amit_Jadhav

The local path synced with SharePoint right ?

Thanks
#nK

5

Yes exactly.

6

Cool, could you please share a snap of your activity with props visible to troubleshoot ?

7

here’s the snap of one of the excel activity.

image
image741×507 40.5 KB

8

Hey @Amit_Jadhav

So the error is in the Read cell activity ?

And if yes whether the sheet name provided exist ?

Thanks
#nK

9

Yes in attached snap error occurs in read cell activity but in other case same occurs for read range also.
And the provided sheet name also there.

Attached is error snap.

image
image1343×179 9.87 KB

10

Hey @Amit_Jadhav

Just try checking the spell and space if any as it should be exactly similar.

Also, I hope there is no access issue I guess.

If possible please try copying the file locally without SharePoint sync

Thanks
#nK

11

Thanks for suggestion.

There was no any spell and space errors as same works if we retry the activity in debug mode.

And for second suggestion,
File is being used one two servers so using locally is not a solution here.

12

Using locally is not a solution, just to see if any access issue.

So if you say retry then basically it may be accessed by multiple users which may cause this issue.

13

Tried accessing same file at a time on both server and it works fine for many times, so accessed by multiple people may not cause issue i guess and also accessed by only BOT or single user causes the exception.

14

Okay understood. So what’s the version of Excel activities you are using ?

Also enable Read-Only option and try once.

15

The version of excel activities i am using is 2.9.5.

I will check once with read only option enable and revert back.

Thanks.

1 Like
16

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