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)
January 27, 2020, 8:05am
2
Hi @syedbahauddin
by using this try to check whether you are able to extract the values
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
1 Like
close this thread don’t create duplicate posts
cheers @syedbahauddin
1 Like
system
(system)
Closed
January 30, 2020, 8:18am
6
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.