Ona table with 2 columns with a value


#1

HOW I CAN SELECTE IN THE EXCEL 2 COLUMNS WITH THE NAME “SAM” AND THE OTHER COLUMN WITH THE LAST NAME “ADAMS”

EXCEL

NAME LAST NAME

SAM ADAMS
SARA G
PETER GRIFFIN
SAM ADAMS
SAM WINTER
DAVID LOZA

I have only one column with sam with a excel app and read rande, read cell and for each and for each row

but i can´t have the second column???

i find write in other excel or write the firt column with only sam anda the 2 column with adams

any idea?


#2

Use a read range, then assign the rows to a Datarow[] (Array of data rows).
Then you the Row.Select(“Name” like ‘SAM’")

where Row = Datarow[] variable
Name = Column name
Sam = Then name your trying to look up.


#3

can you share one example in uipath the .xaml , thank you


#4

something like this.Sam.xaml (14.8 KB)