Read range sheet name issue

Help Studio
1

Hi,
Im having an issue with the read range activity, I set the sheet name to find as “Home”, but when its executed it automatically throws an erros that says that the sheet “Hoja1” doesnt exist. Anyone knows what could be happening?
Thanks in advance

2

heres the file with the activity, i have already reintalled uipath, tried updating packages and testing a new read range in a different project.pruebas.xaml (7.5 KB)

3

Sheet name in read range is empty. write sheet name=“Home” it will not throws an error.

Sheetname

4

I changed it in my tests, i still have the same issue. I even tried to open the file in notepad to see if there was something strange. Doesn´t matter what i put in the space you highlighted, i recieve the same error.

5

change range to “” which mean empty. I will read whole sheet range

image

6

image
image1069×233 13.3 KB
this is what happens
image
image1023×238 13.1 KB

7

Open excel workbook and validate sheet name …may be it contains some spaces or different sheet name. and also validate the excel workbook path as well

8

Already done that friend, the message suggests that no matter what worksheet name I specify it will search for a sheet named “Hoja1”

9

Open task manager and check if any previous excel session is open or not if open then close it from task bar and run the process again

10

Same message

image
image1047×292 14.2 KB

11

Found the issue, apparently the problem was with the excel file, when i moved my data to a new excel file the same read range activity worked with no problem.

12

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