Add New column to excel in uipath

Help Studio
, ,
1

Hello guys

I have a question. I have a data table and I want to add a new column. Its name should be “Status” and the value should be “Open.” So how can I apply this?

Thanks,

2

Hi @Nada_Ismail,

We can add Column to the Existing datatable using “Add Column” Activity

image
image1250×590 33 KB

image
image1201×783 55.5 KB

Also, If you need to updated value in the new created column “Status”. You can use “Add Cell” Activity to add the value one each cells.

[Note:

Reference - https://youtu.be/jaXjHtDAy-U

Thanks in advance,
Jayavignesh G

1 Like
3

Yes, I know this activity but I don’t know how to write the condition :grinning:

4

Hi @Nada_Ismail ,

Maybe you could try using the Default Value Property when using the Add Data Column activity with value as "Open" So that the values is added to all the rows for that column.

If you would require to add the Status value to specific rows satisfying the condition, then we would need to loop over the rows using For Each Row activity and use an If Activity to update the value for that column which satisfies the condition.

Depending on the ease of condition to be applied, we could also try with other methods :

5

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