Hello guys, can you please help me with some ideas how can I use uipath to read 3 columns from an excel file in the same time and concatenate its rows as a string, then write them into another app. Thank you!
Hello Ionut,
That’s easy enough. You’d use a Read Range activity to get the information out of Excel. You would then create your strings, potentially adding them to a List type collection, by going through the rows with something like a For Each Row activity and using Invoke Method to Add them by doing something like String.Format("{2}, {0} {1}.", rows("first").ToString, rows("middle").ToString, rows("last").ToString)
You would then have to take those String values and add it to your app one at a time most likely. I cannot really give you much help there because I would need more information regarding the application that you intend to add them to.
Hi @Ionut_Frincu,
You have tow options. I don’t know which one is suitable for you.
First one.
- Do the for each row loop.
- Inside you concatenate the values like this strValue= String.join(“,”,Row.itemArray)
Second one.
- After read the data from excel into the Datatable.
- Use Output Data Table, it will return it as csv format.
- To know about it below here.
Regards
Balamurugan.S
Thank you mate for your response. Can you please give me an example or sample how strValue= String.join(“,”,Row.itemArray) should be used inside the for each loop. Sorry but I am pretty new to uipath. Thank you!
Hi @Ionut_Frincu,
Here is the sample with screen shot.
Sample :
Ionut_Frincu.zip (17.0 KB)
Regards
Balamurugan.S
Thank you very much my friend, I appreciate. I would also need another suggestion how can I tell my uipath script to check if one of the column is changing its value at a point and if yes, then should send an email. Thanks!