Excel reading issues

Learn Academy Feedback
1

Hii everyone,
Flow of Workflow
Extract table from web page
Using For each Row
Detecting a value from the column A
Relating to the column A, the value corresponding to it that is if it is Column C then the Value from Column C is to be picked up.

Thanks and Regards,
Supriya

2

what exactly are you looking for?

3

In the for each row activity insert an IF activity with the following condition

IF

row.item(“ColumnA”).tostring = row.item(“ColumnC”).tostring

THEN

Assign VAR = row.item(“ColumnC”).tostring

ELSE

[Blank]

1 Like
4

@supu123 follow the below syntax

resuletdDT=YourDT.Select(“ColumnB=ColumnC”).CopyToDataTable

Regards,
Mahaling Patil

1 Like
5

Hiii…

image
image1335Ă—249 11.6 KB

I want to check whether the Party column contains “The Financial” is yes then store the “case number” related to it in a variable

image is the content after extract datatable in uipath

Mainly, The above image shows the column-1,column-2,… at the top
What are the steps and code to run the above process
please specify the expression related to it.

Thanks and Regards,
Supriya

6

Read the Collum and put it into a variable of strings. Then create a for each item of the colllum.
In this for each you make a if statement if the item.ToString.Contains(“THE VALUE YOU WANT”) Then write it away or save the First collum number.

7

As stated above, use a For Each loop on the datatable. Then an IF activity acting on each row to check if the word “Financial” appears:

image
image608Ă—552 14 KB

The assign syntax is “row.Item(“Column-1”).ToString”

You can then use the Case Number as you wish, maybe saving to another datatable.