The sheet does not exist

Help
1

Hi all, I have problem with excel sheet, the notification show " The sheet does not exist"

image
image730×335 17.9 KB

But when i use sheet name “Sheet1” or “1” it worked. I already check the space too.
image
Please help me to fix it ! Thanks all !

2

I do not see any issue. Try attaching excel sheet and your xaml for the reference.
Or delete the Excel Application Scope and re-do the process flow.

Regards,
Karthik Byggari

3

Hi @marcus1206

Can you please check any leading or trailing spaces are present in excel sheet.

please share sample input file if you can. :slight_smile:

Regards,
Vijay Kumar C.

1 Like
4

Hi @marcus1206,
It may be ‘Vietnam 1’ instead of ‘Vietnam1’.

Thanks and regards,
Despi

1 Like
5

As others have suggested, confirm the tab name is exactly the same as what you are trying to look for -

A few ways would be to use Get Sheets on the workbook or if you know that is the sheet name, try to rename the tab and copy that into UiPath.

Regards,

Tim

6

I had already check but it not work. I cannot upload my file because It contains client data.

7

Everything looks good so let’s rule out obvious things, are you sure your file path is pointing to the right file?

8

Of course, I checked, I don’t understand it just work when type the default value “Sheet1”

9

Any chance you could share the xaml file? Try re-doing the excel application scope?

10

Hello, I’m having the same issue, when I submit a file with a renamed sheet it does not work and the program is trying to read a sheet with the default sheet name in french (cause my system is in french) which is “Feuil1” though there is absolutely no sheet whith that name into my file:

img for uipath forums
img for uipath forums995×899 98.8 KB

Edit: before processing the excel file, my process retrieve it from emails in Outlook and save it locally, then if I try to read this saved file with an another process with exactly same instructions (so without retrieving it from outlook), it work!
Please help if someone knows, I really don’t understand :sob:

Re-edit: it worked! It was a stupid path error on my part, have a nice day you all :blush:

11

Yes it might be !

1 Like
12

can you tell me how it got resolved i am facing the same error

13

@Sourav_Jha Can you check is it the right path that you are giving in the read range

14

Yeah i have mentioned the correct path
Screenshot 2022-04-05 122327

15

@Sourav_Jha It looks like a wrokbook activity. Can you also give a try with Excel read range activity

16

yeah it is workbook activity , i will try with excel activity as well and let you know

17

Tried in excel activity as well it is not having the opting of path
s

18

@Sourav_Jha Search for Excel Application Scope within that keep read range. Belo screenshot for ref

Make sure you give the entire excel path (Ex: C:\Input.xlsx)

Capture
Capture1152×544 25 KB

19

ok i will try that as well

20

Tried that as well showing the same error

K
K1907×977 95.5 KB