Cannot able to read Orchestrator Asset Value in Read Range

[saritha]

Hi All,

Can Anyone help me out with this. Thanks in Advance

I created Asset Value of Type “Text” (in which give the path file) in Orchestrator
And read the config File REFrame Work and concactinated the states.xlsx file
in read range like this

** In Read Range**
** Config(“assetValue”).ToString+""+“satates.xlsx”**

it s giving me error.

[AdityaVN (Aditya Vaddiraju)]

Hi @saritha

My understanding is, "\" is causing this error. Try using "\\" instead.
Do let me know if this worked

[poorna_nayak07 (Poornachandra M)]

Hi,

Instead you can try Path.Combine(Config("ExcelPath").ToString(),"StatesAndCapitals.xlsx")

[saritha]

Thank u for your reply. I tried , but didn’t work.

[saritha]

Thank u for your reply. I tried , but didn’t work .

[pikorpa (Piotr Kołakowski)]

Hey @saritha ,
Try use expression Config(“excelPath”).ToString+""+"StatesandCapitals.xlsx to the ‘write line’ activity and check the result. If you don’t find any illegal characters try type to the ‘read range’ activity path without using variables.
If ‘read range’ activity will work you have to compare both string character by character.

However, my guess is that you used quotes in the path. in the config file. Try remove it.

[kirankumar.mahanthi1 (Kirankumar Mahanthi)]

Hi @saritha ,

Small suggestion from my side dont keep double quotes for file path while entering in your asset. There might be chance it is pulling file path with double quotes and it treating as illegal character in path.

You could save your file path in config excel instead of orchestrator asset. Please try above ans let us know. Thanks.

[saritha]

Thanks for ur reply

I did that to and checked the path. Its printing the path exactly.

But not able to read the path in Read Range …

Don’t know exactly where was the mistake…

Please help me with this.

[saritha]

Hi Thanks for ur reply,

I tried using it in config file. It was working

But the thing is , I want it from Orchestrator…

[AdityaVN (Aditya Vaddiraju)]

how are you call the asset from orchestrator, hope you are using get asset activity

[pikorpa (Piotr Kołakowski)]

Hey @saritha
So you are use double quotes. You don’t need it in the path
Instead: “c:\folder\fileName.xlsx” please use: c:\folder\fileName.xlsx

[saritha]

Hi , gave it in config file
Thank you.

[saritha]

Hi , as u said I changed the quotes which I have given in Orchestrator . Now its working …

Thanks a lot.

Than you everyone for all ur replies…