Excel Application Scope and Read Range

[nlee1131]

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:

Excel file:

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!

[sandeep13 (Sandeep Pathak)]

Hello @nlee1131
Excel package is updated??

Thanks

[nlee1131]

Hi @sandeep13

Both environments are running UiPath.Excel.Activities 2.6.2

[sandeep13 (Sandeep Pathak)]

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

[nlee1131]

Yeah, both returned the same error.

[ClaytonM]

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.

[nlee1131]

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)