Help with "Do while:

Learn Academy Feedback
,
1

Hi! My cycle goes on three sheets in the file Excel. I need each value to be saved in a separate variable, not overwritten. How can I do that?

image
image499×709 17 KB

2

Hi @Darya

May I know to what are you referring by “each value”? Are you referring to the data that you extract in read range activity you have in your while loop?

3

Not. I need the value of “Get row item”. In each sheet it is different :disappointed_relieved:

4

You can add all of the items to a list - once you have used GetRowItem

Use Add to collection (create a new list of string)

It depends what you want to do with the data afterwards also.

5

I need the sum of these values. Is it possible in the collection? :open_mouth:

6

Yes, they would need to be a list of double then if they are decimals.
You may need to convert them before adding them to the collection.

Another way would be as the below:

You can create a new variable at the start called Sum.

Then after Get Row Item use an assign

Sum = Sum + Output (from Get Row Item / again convert to double or int as required)

2 Likes
7

It is work!! Thank you so much

1 Like
8

No problem :slight_smile: if you mark the solution it can help others if they have a similar problem

1 Like
9

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