Hi Guys, I have an Excel File which has a dynamic amount of rows. I am taking info from each row and adding to an API Body, which limits the call to 100. I have read the Excel and what I’d like to do is use a Do While and add the first 100 rows from the DT (with which I am using a For Each to man…

Just include a condition within your for each row in Master DT when a counter = 100 or rowcount of DT, then do your API call, reset counter.

@Kyleb91 In the interest of keeping the code quality high while also maintaining the head on your hair, I would recommend you use Queues. Upon starting, convert each row into a queue item and then use them as you need. That way, you won’t need to remove the rows from datatable or face concurrent m…

@Kyleb91 Have a Look Here in how a datable can be Segmented for a Processing [image] Process repeated for each multiple rows Studio @christine.tzenghy let me introduce a general approach that can be also adopted to more case specific details. Assumptons: DataTable wit…

You can use logic as simple as this, dont bother in deleting rows already read, as it only will slow you down… [image]

Thanks for options guys! Much appreciated! @Matt_S your solution is the most simplistic approach so went with that (after some additional conditions for cases of less than 100). @ppr this method is fantastic, I will need to study this. Thanks again @bcorrea and @RPAForEveryone also!

@Kyleb91 for getting only the top 100 rows following line used in a for each row can maybe help as well YourDataTableVar.AsEnumarable.Take(100).CopyToDataTable

Thanks @ppr I had initially used this too. Let’s say there are 150 rows, how would you approach the next loop taking care of just the remaining 50 rows that have not been dealt with, and If statement and Counter?

this is handling with the skip take as the take is not error throwing when less rows are remaining find xaml here: ForEach_Segment_RowSets.xaml (11.8 KB)

@Kyleb91 - The .Take() method won’t throw an error, it just grabs the remainder if there are less items than the indicated amount

Thanks @Dave , yeah I noted that, but once looping back to the DT, it would subsequently take the same initial 100.

Oh sorry, I misunderstood. It looks like ppr mentioned the .skip(counter).take(amount) way, which is the way I always have handled things as well since I like the simplicity and ease of reading. Then after the loop you just update the counter to be counter = counter + amount This way on the first it…

For Each 100 Rows

Help Studio

ppr (Peter Preuss) September 21, 2020, 6:21pm 4

@Kyleb91
Have a Look Here in how a datable can be Segmented for a Processing

1 Like

Topic		Replies	Views
How to loop through specific number of rows Activities excel	8	3367	September 18, 2021
How to read each 20 rows with condition and create new sheet Studio	21	3810	July 9, 2020
Remove lines from datatable until its empty Activities datatable , excel , activities , question	4	1271	December 21, 2021
Iterate excel range for every 100 data upload Activities excel , activities , question	23	492	March 25, 2024
Dividing my datatable into 20 rows Automation Starter	8	1122	August 16, 2022

For Each 100 Rows

Related topics