Read Range Workbook: Sequence contains no matching element

[Chetan_Wagh]

Hi All,

When I am trying to use Read range activity, this error occurs.
I want to read particular cells(L47:X71) in whole excel sheet and extract it as DataTable.

Any help will be appreciated

Thanks in advance

[Anil_G (Anil Gorthi)]

@Chetan_Wagh

First of all error says it cannot access …either the file is open or is still alive in background or the location is wrong or locked…please check the same and use accordingly…to kill background excel use task manager and check if anything is running in background

cheers

[Harshith_Adyanthaya]

Hi @Chetan_Wagh,

Can you try using Excel scope?

[Gokul001 (Gokul Balaji)]

Hi @Chetan_Wagh

This error occurs usually when you try to read a range that does not exist in your workbook 1.

Here are some possible reasons why this error might occur:

• The sheet name and range name is incorrect.

• The sheet or range does not exist in the workbook.

To resolve this error, you can try the following:

• Check that the sheet name and range name are correct.

• Check that the sheet or range exists in the workbook.

• You can try different excel activity Like : Excel scope, Modern Excel activity

Check out the docs

https://docs.uipath.com/activities/other/latest/user-guide/read-range

[Chetan_Wagh]

Yeah. The file was left open by mistake, closed it and retried. Hence I have colored it red. Ignore Please. Wanted to ask the second error,

[Anil_G (Anil Gorthi)]

@Chetan_Wagh

It does not look like an excel issue…can you try closing the project and reopen it and check…

Alternately check if the same issue is coming in a different project for that file

If its persistent then try using excel applications cope instead of workbook…but mostly it looks like a one of issue may be a corrupted file can try saving the file as different name and read it using save as option in excel

cheers

[Harshith_Adyanthaya]

Please do use Excel Application Scope, issue should be resolved.

[Chetan_Wagh]

Thank you so much @Harshith_Adyanthaya . It worked

[Chetan_Wagh]

Worked with EAS. Thank you @Anil_G

[Chetan_Wagh]

EAS worked. Thank you @Gokul001