Dynamic Extraction of Data Blocks from Excel

Help
, ,
10

@NAJAA_BAZILAH
I worked out a sample for you showcasing on how an extraction could be done. With some alignments I made the implementation flexible and stressed it with this as well:

grafik
grafik619×581 7.84 KB

Extraction was possible for your and my tables.

Constraints:

  • no overlapping data within the cols. Does mean we can detect blocks and if a block starts on Column B, then no Block will start on Column C (Overlappings)

Find XAML here:
NAJAA_BAZILAH.xaml (16.0 KB)
Excel Here:
Book2_PPR.xlsx (12.6 KB)

Have a look on the comments in the xaml and explorer it by debugging and breakpoint setting. As mentioned within, the Part for marker calculation was done quickly with LINQ. But we can shift to essential UiPath Activities as well.

1 Like