How to make repeating numerical series

Hello,

I’m trying to make a repeating numerical series in excel by column, but the number of rows is limited based on current number of rows in a worksheet.

For example, I need to insert a series of 1,2…8 but after 8, repeat back to 1, but the list ends on the last row of the worksheet. I don’t have Java knowledge, and I’m sure this could be done using Java, but is it possible using nodes?

Thanks!

Hi,

If I’m getting it correctly, you want to create a list of numbers counting from 1 to 8 repeatedly. Right?
Numbers
1
2

8
1
2

8

To do that you can use a Table Creator to produce first group of numbers form 1 to 8 (or read a table which has this already) and then use “Counting Loop Start” and “Loop End” nodes to produce as many rows as you like.

I hope this would help you. Or if I’m missing something please let me know and I will try again.

Best,
Armin

Thanks! I’ll give that a try. You’re correct in the sequence I want to generate. I just want to add it to a worksheet with data already, and have the sequence stop at the last row populated.