Hello Everyone, How can we get the data from Excel Sheet which is in the below format in a Sheet Organization Code : AXKK Address: US Reference: Website So we need to get AXKK,US

@anmita Try with following steps it will work Use Read range activity → Store it as DTRead Take for each row in data table → Pass the DTRead In Loop need to check the condition if Organization Code = AXKK then take the value else Address = US then take the value Thanks Varun

How to get data from row

Help Studio

Anil_G (Anil Gorthi) December 10, 2022, 9:59pm 2

Hi @anmita

Are the organization code and the value are in different columns if yea then please read the datat in datatable and use look up dattable

https://docs.uipath.com/activities/docs/lookup-data-table

Cheers

Topic		Replies	Views
How to extract special data from excel sheet Studio datatable , activities , studio	8	981	December 22, 2021
Excel conversion Studio studio , question , activities_panel	9	1068	December 14, 2021
Assign activity Help	15	4827	October 29, 2018
Extract or parse data from XAML of GetRowItem 's used in the Sequence Studio datatable , excel , uiautomation , studio , question , xml	0	919	July 29, 2020
How to read a data from a column in a excel Help datatable , excel , uiautomation , studio	4	1151	July 23, 2018

How to get data from row

Related topics