Unable to read data

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

Hi @Rahul369,

Please verify the Sheet Name and Range.

I can see a space in sheet Name.


Mukesh

2 Likes

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

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

Hi @Rahul369,

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

Cheers
Jack

Hi Bro,

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

Cheers!!
Ram

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