Hello. I am working on a process and im trying to store multiple row values present in a column (in excel) into a single variable or an argument inside the UiPath Studio Community Edition.
how to do this?
Hello. I am working on a process and im trying to store multiple row values present in a column (in excel) into a single variable or an argument inside the UiPath Studio Community Edition.
how to do this?
If you need to get a column value alone, then you can read the excel as a datatable using read range. Then you can convert the needed column value into an array of string datatype as follows
dtvariable.AsEnumerable.Select(Function(r) r("columnname").ToString.Trim ).ToArray
Should i do this step using an assign activity?
I used Assign activity and assigned dtvariable.AsEnumerable.Select(Function(r) r(âcolumnnameâ).ToString.Trim ).ToArray to the sub_ variable.
now when Iâm trying to use the keywords present in the column(excel) to match the email subject in outlook mail, Iâm getting this error.
sample_1.xaml: Compiler error(s) encountered processing expression âitem.Subject.Contains(sub_) Or item.Body.Contains(body)â.
Overload resolution failed because no accessible âContainsâ can be called with these arguments:
sample_1.xaml: Compiler error(s) encountered processing expression âitem.Subject.Contains(sub_) Or item.Body.Contains(body)â.
Overload resolution failed because no accessible âContainsâ can be called with these arguments:
the output is a array which contains value of all rows in a column.
loop through the array sub_ and then check whether the subject contains the keyword or not.
I didnât quite understand that. can you please explain?
Can you explain more about this??
I didnât get any keywords from the sub_ variable. I am getting the value as system.string