Get items from excel column in groups

Help Studio
, ,
1

Hi, currently I have an excel file with a column like this:

image
image97×648 1.92 KB

I would need to copy and paste those items to a website, but the website only allows 20 items each time, how can I achieve this?

2

Hi,

The following post will help you. Can you try the following sample with chunk size 20 and use ForEachRow inside ForEach.

Regards,

3

Hi, is there anyway to copy 20 once instead of looping it one by one?

4

Hi,

How about the following?

image
image1125×1575 51.1 KB

Sample20230830-1L.zip (9.3 KB)

Regards,

5

Hi @Joanne_Chang_LAX

Grouping the rows means in which format you want it in. You want in concatenating all the 20 rows as one string. Give the proper format you want then we will give you the better solution.

Hope it helps!!

6

Hi, sorry for bothering, but when I tried implementing this, when my file has less then the amount I wanted, it still repeated the process twice, do you know the possible reason to this?

So I have this column
image

and for this one I’m aiming for 50, so I did

image
image680×517 15.5 KB

but when I tried to do the message box, the same message box popped out twice, despite it shouldn’t be needing to repeat.

7

Hi,

Can you elaborate with specific sample?

Regards,

8

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