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

[billabong271294]

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!

[moenk (Thomas Meier)]

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

[billabong271294]

Hi, thank you!

Would you kindly provide me a .xaml sample ?

[prasath17 (Guru)]

@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.

[billabong271294]

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