Excel Application Scope and Read Range

Hi all,

I’m getting an error saying that the sheet name I pass to the Read Range activity doesn’t exist, but it does.

UiPath versions:
Community Edition: 2019.6
Enterprise: 2018.3

Workflow:

Error message:
readRange_DNE

Excel file:
excelFile

A similar issue has been discussed here. I tried their resolution, but it gives the same result.

This file is downloaded from a third-party website so Excel automatically opens it in a protected view. Changing the default settings for this isn’t an option as this is a work server. Any other opinions are greatly appreciated!

2 Likes

Hello @nlee1131
Excel package is updated??

Thanks

2 Likes

Hi @sandeep13

Both environments are running UiPath.Excel.Activities 2.6.2

1 Like

You tried both Excel read range and workbook read range. Right??

2 Likes

Yeah, both returned the same error.

2 Likes

Are you saving the Excel file first? If not, your Excel scope might be creating a new empty file in the project folder because your filepath is only the filename. If you open it from the download, then the path is in a different location.

2 Likes

Hi all,

Thanks for the help. It ended up being an issue that the activities don’t allow the use of wildcards in the file or sheet names.

Solved by using a ‘Get Workbook Sheets’ activity and using sheets.Item(0)

4 Likes

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.