Extract a set of rows when value in a cell matches

[syedbahauddin (Bahauddin N Syed)]

Hi All,

Need help in extracting data from an excel file where the complete data is in one sheet and each table is divided by an empty row. I would like to extract “Address” table (can’t give fixed index since address table can be place at the bottom).

[AshwinS2 (Ashwin S)]

Hi @syedbahauddin

by using this try to check whether you are able to extract the values

BalaReva.Excel.Activities

Hi Friends, I have included some new activities that merge and unmerge the cells Name Space : [image] Merge Cells - Merge the cells inside the excel file. Properties : [image] Sample File : MergeCells.zip (24.9 KB) UnMerge Cells- Unmerge the cells inside the excel file. Properties: [image] Sample : UnMergeCells.zip (24.8 KB) Let me know if you have any errors. I would be happy to get more suggestions Regards Balamurugan.S

Thanks
Ashwin S

[Pradeep_Shiv]

close this thread don’t create duplicate posts
cheers @syedbahauddin

[syedbahauddin (Bahauddin N Syed)]

https://forum.uipath.com/t/re-extract-excel-table/188470/7

Yeah sure