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

Most Active Users - Yesterday
ashokkarale
anjani_priya
Dheerendra_vishwakarma
Parvathy
Aakash_Singh_Rawat
Luis_Fernando
bjorn2390
neco
pere
Shiva_Nikhil
More details...

Extract set of rows from excel

Related Topics