Unable to read data

Learn
1

data is null showing but data already present in Excel sheet.

Capture
Capture979Ă—644 35.1 KB

2

Hi @anon24744774,

Please verify the Sheet Name and Range.

I can see a space in sheet Name.

–
Mukesh

2 Likes
3

yes alread verify but still error showing.

Read Range: Failed setting the current sheet to: Sheet 1 in workbook: C:\Users\winclient07\Desktop\Demo\XXX_HR_EMPLOYEES_RPA.xlsx. Original error message: Exception from HRESULT: 0x800AC472

4

Can you Copy paste the Name of the sheet and remove any extra spaces. You can make use of excel application scope also.

If possible can you share the excel file ?

–
Mukesh

1 Like
5

Hi @anon24744774,

Can you try using Excel Application Scope instead? See if it works.

Cheers
Jack

6

Hi Bro,

I can see some “” (double quotes) typed in Range box, which is next to “Sheet 1”, remove that and try

Cheers!!
Ram

7

I can also see that there is a space between “Sheet and 1”, i.e. “Sheet 1”, it might be “Sheet1”

Mean to say, check for the proper sheet name

Regards,
Ram