Excel application scope cannot read my Sheet in excel

Help
, ,
1

The sheet has the good name but studio said the sheet doesn’t exist

image

2

@Soudios

Close the Excel and re run it and make sure you have given same sheet name in Read Range Activity.

3

HI @Soudios

You have to give the same sheet name that is available in the excel file as the sheet name in the read range activity. Just make sure it is the same and it should work for you.

4

yes it’s the same :

image

image
image1592×629 29.2 KB

Source: Read Range

Message: The sheet does not exist.

Exception Type: System.ArgumentException

RemoteException wrapping System.ArgumentException: The sheet does not exist.
at UiPath.Excel.WorkbookApplication.SetSheet(String sheetName, Boolean createNew)
at UiPath.Excel.Activities.ExcelInteropActivity`1.BeginExecute(AsyncCodeActivityContext context, AsyncCallback callback, Object state)
at System.Activities.AsyncCodeActivity.InternalExecute(ActivityInstance instance, ActivityExecutor executor, BookmarkManager bookmarkManager)
at System.Activities.ActivityInstance.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)
at System.Activities.Runtime.ActivityExecutor.ExecuteActivityWorkItem.ExecuteBody(ActivityExecutor executor, BookmarkManager bookmarkManager, Location resultLocation)

5

Please check if there are any Leading or trailing space in the sheet name.

1 Like
6

Have you checked whether there are any spaces in front or at the end of the sheet name in the excel file? Double click on the sheet name, and select the entire thing and copy it to the sheet property

1 Like
7

doesn’t work

8

Can you share the excel file if possible so that we can have a look?

or else, use the Get Sheets activity inside the excel applcation scope. This will give you a lsit of sheets

Now, use a for each activity to access each sheet.

Inside the loop, place the read range activity and for the sheet property, provide

item.ToString

if you have only one sheet, this will perfectly work…

9

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