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
Extract datatable excel Help	14	1989	September 11, 2019
Extract data from excel column Activities datatable , excel	4	1339	May 20, 2022
How to Extract table from excel sheet Activities datatable , excel , studio	6	2298	March 3, 2021
Extract specific column from an excel Help datatable , excel , activities , studio	3	4200	October 29, 2018
Data extraction from table Help activities	13	2039	April 5, 2019

Extract set of rows from excel

Related topics