Can't read orchestrator asset

Hello,
I make new asset type text:
name:Polly_InputQueueFileDirectory
path: C:\Users\vganchev\Documents\UiPath\BG_Invoices_Automation\Data\Input

In config excel file name for this asset: assetPollyICKatalogFileDirectory

When I want to call this path in my reframework it’s saying:
“message”: “Read Range: The sheet does not exist.”

I’m usng in my excel application scope this workbook path:
in_Config(“assetPollyICKatalogFileDirectory”).ToString+“NameOfExcelFile.xlsx”

What I’m doing wrong?

Thanks in advance

Hi @Veselin_Ganchev
what is the sheet name you have given

Thanks
ashwin S

@AshwinS2 ,
Sheet names are the same: Sheet1

the expression should be like this
in_Config(“assetPollyICKatalogFileDirectory”).ToString+“\”+“NameOfExcelFile.xlsx”
and make sure that the file is closed before accessing
for that use KILL PROCESS activity and mention the process name property as “EXCEL” and then use EXCEL APPLICATION SCOPE

Cheers @Veselin_Ganchev

You are correct @Palaniyappan,
I noticed when I start to debug.
Start typing my string in notepad and the result was:
C:\Users\vganchev\Documents\UiPath\BG_Invoices_Automation\Data\InputNameOfExcelFile.xlsx
It was without slash…

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