Hi Team, I would like to extract ‘address’ table from the below worksheet. Please note that there might be additional rows going forward in all the tables. However, Address will be in first column only and the separator of each table is an empty row. Could you please advise. Thank you in advance…

Well you can do this! 1 - Read Range get output as outDataTable 2 - Assign(SecondDataTable = outDataTable.Clone) 3 - For Each Row (outDataTable) 4 - use if condition like this row(0).ToString.Contains(“Address”) then Assign(BoolIndicator = True) 5 - Another if condition like this pass BoolIndi…

Extract set of rows from excel

Help

GBK (GBK) January 27, 2020, 6:21am 5

it may useful -

Topic		Replies	Views
How to Extract table from excel sheet Activities datatable , excel , studio	6	2345	March 3, 2021
Extract value from DataTable when condition is satisfied Help	20	5269	May 18, 2018
How to extract complete row from the datatable one by one Studio datatable , excel , studio , data_manipulation	5	3473	April 25, 2020
Extract rows encountered between specific rows in excel Help	26	5430	June 1, 2018
Extract a set of rows when value in a cell matches Help excel , activities , question	4	1435	January 30, 2020

Extract set of rows from excel

Related topics