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 manipulate the strings for the API Body).
I then would Ideally delete these used rows, and repeat with the next 100, if there are more (there also may be less than 100 rows).
I then make the HTTP Request for each 100 rows which I have dealt with, and then
The Exit condition for the Do While would then be if the original DT.Rows.Count = 0.
I am having difficulty in moving on to the next 100 rows, if the indeed exist, I am over-complicating it and would like to achieve this in minimal code.
Any help would be great!