i’ve a problem with use a excell functions. I’m searching to make a"query" in the file to take a customers’ emails of the column “email”. Next i’ve to need to take this item and then write it in a new file as a new column.
I’m trying to do it using the actvities “Read Row” into the “For each” to read the elements of the first row, the columns’ names. Scrolling it i would search the column “email” and then using “Read Column” to get te customers’ emails. But this don’t run.
Thanks you Fernando.
Your file go. I’ve an other question for you. To read the element of single column using only the column’s header, don’t using the cell’name with the excell’s actvities is possible? Or i should use the DataTable?
For the requirement that you are asking now, you have to do with datatable and if you don’t give the cell name, it is not possible for bot to understand which column to read.
For this requirement, you need to use the datatable. However, when dealing with read column, read cell or any excel related activities, you have to specify the excel range in the format that Excel has. So basically, you need to give the excel column (A, B, C and so on) along with the row number.
But, once you get the excel data onto a datatable variable in UiPath, then you can use the column names you had in your excel to work with the data using data table functions. So for example, once you get the data to a datatable, let’s say you want to loop through the data table to get a value under the column “email”:
Then you can use row("Email").ToString to get the value of the currently looping row of the Email column
Hope this gives you the idea?
Also, if this solves the problem, please mark the appropriate answer as the solution so it could help others as well
Anil_G
mpraveen1902
Palaniyappan
Yoichi
tazunnisa.badavide
Nguyen_Van_Luong1
Carla_Munoz
ayushi_jain3
Parvathy
nikhil.girish