Read excel file in the background using invoke code

Help Activities
, , , , , , ,
1

Description

Hi , I want to read the excel file in background as my automation is background. In one of my requirement i used invoke code activity with vb.net code to read the excel and get the hyper link values from the respective cells. However the automation is failing as it is trying to open the excel bcz my automation is background .
Kindly suggest how i can read the excel in background so that i can incorporate the changes in my existing invoke code activity.

Link

https://cloud.uipath.com

Date

2024-11-08

Related UiPath products

Studio

2

@avinashy

Ideally formatting and all are part of interop …even in invoke code you would have used interop library…

Try using applicationvarible.visible = false; and check

If not then you need to search for other libraries which work in background without interop

Chees

3

@Anil_G Thanks for the response .However applicationvarible.visible = false didnt worked .
Still getting the error saying - Exception has been thrown by the target of an invocation.
Can you please help here how to proceed further to resolve this issue ?

4

@avinashy

Secondoption try with other libraries other than interop

And what is the exact exception…if you log inner exception we can see that

Cheers