Hi Guyz,

I have situation here where I'm building a robot in a statemachine. I want it to read a single excel file with 2 worksheets. the process for each sheet the robot has to perform is different from each other. now my question is how to pass each row (for both the sheets simultaneously) in the "Get transaction" invoke function?

RE Framework*

Try json file. IMHO

UI robot is not appearing to use.. Plz help me

If schemas of the tables are the same in sheets, then...

Read 1Sheet to dt1, Read 2Sheet to dt2,

Join dt1 and dt2 to dtTransaction.
For each row in dtTransaction
Add Queue Item

If you need to convert from DataRow to Dictionary(of string, object) as ItemInformationCollection argument of Add Queue Item activity, then there is code below. There is column name is key and cell value is value. This code must be put into For Each Row activity and element is "row"

row.Table.Columns.Cast(Of DataColumn)().ToDictionary(
 Function(c) c.ColumnName,
 Function(c) If( row(c.ColumnName).ToString.Equals(String.Empty),
   CType(String.Empty, Object),
   row(c.ColumnName)
 )
)

Thanks Will try

Merry Christmas all of you

Hi

I'm seriously looking for a solution

2different works should be done

1pull the data and excute the result

Basically it's a stock trading related topic, anyone help me. If u able to or take challenge.

Yes.& I didn't know how to deal with it.

I’m getting an error using the activity call “Send Mail” which should be use within a “Microsoft Office 365 Scope”. I know is error usually appears when you have a variable that is empty. But, I have hard coded all the properties and still getting this error. Any help would be highly appreciated

I need tin se uipath community edition

On windows server with no internet connection..

Need to run this for poc on that server..

Any option i can do this.. may be trail run or any trail key if avaiable ?

Have you entered the port number and server name ?

Hi everyone ,in Uipath is there any way to get robots utilisation ?

Select from db of Orchestrator