Read row by row (Excel)

Help Activities
, ,
1

Greetings,

I would like to make UIPath read row by row and convert it to text. However, the content was in column by column format. So when I use expression, row(1).ToString, the output will be row of that column. I want to make UIPath to list out like image below:

image

My Output should be = A, and then B, and then C, and then D, and then E. One by one through message box.

I only know row(1).ToString but it output = A ā†’ A2

Appreciate the helps.

2

Hi @DTECH,

Can you share what kind of output you want to get from the excel you shared?

Regards,
MY

3

Hi @DTECH

Can you please explain bit more.

Thanks

4

Hi, I have updated on main statement. The output should be A ā†’ B ā†’ C ā†’ D inside message box instead of A->A2

5

Hi, I have updated on main statement, sorry for not explaining in detail

6

thanks for the explanation.

Have you tried using outdatatable? It will return you all excel as strings.

image

Then when you split according to the new line, you will get each row as a string.
result.Split(Environment.NewLine.ToArray,StringSplitOptions.RemoveEmptyEntries)(1)

image

Regards,
MY

7

@DTECH Correct me if I am wrong. When you are looping through the first row instead of printing A,B,C,D,E in a message box you wan to print as A2, B2, C2 etc

9

No, I mean, I want to print A, loop again, print B, loop again, print C loop again D.
Once finish first row, it goes 2nd row, print A1, loop again, print B1

10

@DTECH

test.xlsx (8.2 KB)
test.xaml (7.8 KB)

in foreach row loop, use another foreach to loop over dt.columns
this will print
A->B->Cā€¦
A2->B2->C2ā€¦

image
image1117Ɨ377 23.2 KB

output
image

11

Thanks, man, it was close but it print in one specific line now. Is it possible to print one by one ?

image

image

12

@DTECH Can you share your workflow here

13

image

Thanks for the attached but somehow mine cannot read

14

I believe there are better solutions, but Iā€™m sharing as a continuation. If you split your output again, you can list it as follows. @DTECH

image
image796Ɨ372 11.2 KB

image

15

If you increase your system activity the problem is solved. @DTECH

image

16

Here, sorry for misconfusion, the steps should just read one by one from left to right. So either A1 or A also can. The output should be A ā†’ B ā†’ C . If no more on first row, loop again to A1 ā†’ B1 ā†’ C1

Main.xaml (9.1 KB)
Book1.xlsx (8.2 KB)

17

Thanks a lot man, appreciate this expression. Cheers and thanks gain.

18

Thanks, I hope it will be helpful. @DTECH

Main (1).xaml (10.2 KB)

19

image
image1178Ɨ534 26 KB

result
image

1 Like
20

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