EXCEL QUESTION - HOW TO LOOP THROUGH A SINGLE COLUMN AND READ IT BY 5 IN 5 ROWS

Hi all,

I have an urgent question -> how do I loop through a single column (A) and dinamically read the groups in RED (5 in 5 rows)?

Here’s an example of the procedure I want to do:

Thank you! :wink:

You can simple calculate the real row number with an assign:
realrow = block * 5 + blockrow
Then read cell(realrow,1).

Hi, thank you!

Would you kindly provide me a .xaml sample ?

@billabong271294 - Please check this XAML ReadBlocks_Excel.zip (41.9 KB) and let me know if this helps you…

What I did was, after reading the 5 rows from the excel, I setting the index count back to 1.

1 Like

If I ever become a millionaire, you surely will be remembered! Thank you!! :wink:

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.