data is null showing but data already present in Excel sheet.
Please verify the Sheet Name and Range.
I can see a space in sheet Name.
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 ?
Can you try using Excel Application Scope instead? See if it works.
I can see some “” (double quotes) typed in Range box, which is next to “Sheet 1”, remove that and try
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