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, 12:17pm 3

Hi @Anil_G

This is the Format

So how can we extract US and Asia depending on Org Code

A Reference Xml would be helpful

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