Read Range: Exception has been thrown by the target of an invocation

Help StudioX
,
1

hi everyone i’m just wondering why i encountered error Read Range: Exception has been thrown by the target of an invocation. i want to copy all data from sheet COMPS to data table. but it gives me error.

ReadRangeErr

seeking for your helping hand. thank you.

2

Hi @arthurang

Invalid Sheet Name: Make sure that the sheet name you specified in the “Read Range” activity (“COMPS” in your case) exists in the Excel file and is spelled correctly. Sheet names are case-sensitive.

Empty Sheet: If the specified sheet is empty, attempting to read data from it using “Read Range” will result in an error. Ensure that there is data present in the “COMPS” sheet.

File Path: Check that the file path you provided in the “Read Range” activity points to the correct Excel file. If the file doesn’t exist or the path is incorrect, you will encounter this error.

Permissions: Ensure that the UiPath robot has the necessary permissions to access and read the Excel file.

Hope it helps!!

3

Hi @Parvathy thank you for your reply. Sheet Name is valid and is not empty also. file path is correct since the activity is under Use Excel File Activity and before this activity there are already write range activity…

4

Hi @arthurang

So, you are reading the data written from Write Range activity using Read Range activity right. You need to use another Use Excel File and from that you can read the data using Read Range.

Regards

1 Like
5

yes sir you are right. i am reading the data written from Write Range activity. i will check and get back to you. thank you.

6

you were right @Parvathy i need to separate my read range. i’m just wondering why is not possible to have read range after write range activity in the same sheet.

1 Like
7

You’re Welcome @arthurang

Happy Automation

Regards

1 Like
8

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