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

anmita December 12, 2022, 1:05pm 6

Hi @Gokul001
Thanks for the Steps

This is the file need to extract the address , reference and date basically for each Org Code
Format (1).xlsx (5.1 KB)

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