I need to read and copy cell A1, and after that read and copy cell B1, A2 and B2, and forward. But every time that I extract the file, the number of lines change, sometimes is 3 lines, and others 30. I’ve tried Read Cell actvity and on the cell field “A”+counter (a counter that checks if the cell is empty, if not, add 1 more unity)
This activity ends when the cell of the column A is empty…
I’m using a Read Range activity, and putting in a DataTable variable. What I’m having issues is: the quantity of lines are always changing, every time I download the document, and I need to copy the cell, paste, and after that copy the beside cell and paste. I have to do a Do While, but look what I’ve tried
If you are looping them by using For Each Row
Then u can save them directly
say by using
Row(0).ToString in Set to clipboard for A1 FOR loop 1
Row(1).ToString in Set to clipboard for B1 FOR loop 1
I have seen in your workflow that you are using Break activity when condition is True, that is why stops. You shoud use Continue activity. This one finishes the execution of the current row and continue with the next one.