Format Excel column with new data

Help Activities
, , , , ,
1

Hi, I have this column named “Product Category” and “N.W” as shown below:

image
image556×794 4.73 KB

I need to add a new column called “NW Elasthane”.

  1. Whenever, “Product Category” contains “… 95% ORGANIC COTTON 5% ELASTHANE” we do 5% of the N.W(0.05*N.W) and paste it in “NW Elasthane”

  2. Whenever, “Product Category” contains “…92% ORGANIC COTTON 8% ELASTHANE” we do 8% of the N.W(0.08*N.W) and paste it in “NW Elasthane”

  3. Whenever, “Product Category” contains “…100% ORGANIC COTTON” we paste 0 in “NW Elasthane”

AFTER:

image
image660×782 5.71 KB

Can someone help please?
Thanks!
UIPath_Excel_Scratch.xlsx (113.6 KB)

2

Check your thread.

https://forum.uipath.com/t/add-column-with-data-to-excel/308378

4

I am doing this:
image

But I am getting this error:
image

5

@prasath_S Can you help me on this one please mate?

6

Hi @Yudhisteer_Chintaram1

Could you share the workflow and excel file so i can check from my end…thanks

7

Your N.W column contains Double Data Type values. Also sometimes this column is empty. So make sure you add assign activity under IF which checks column is not null.

Assuming N.W column is not Double:
row("NW Elasthane") = (CDbl(row("N.W")) * 0.05). ToString

Assuming N.W column is Double:
row("NW Elasthane") = (row("N.W") * 0.05). ToString

8

“IF which checks column is not null.”
What is going to be my condition in the IF statement?
Thanks!

9

Try row("N.W").ToString <> ""

If suppose you don’t check for empty column values, then NW Elasthane column value be 0.

10

Not like this?

image
image646×523 19 KB

11

Yes like this. For “100% ORGANIC COTTON”, you are going to assign NW Elasthane column 0. So here you don’t require If.

Instead of adding Switch inside If, try adding If inside “95% ORGANIC COTTON 5% ELASTHANE” & 92% ORGANIC COTTON 8% ELASTHANE” case.

12

I am really struggling @Shraddha_Gore .
Could please show me please?

14

Hi @Yudhisteer_Chintaram1 ,

Add_NW_Elasthane_Column.xaml (13.0 KB)

Here I’ve assigned Double Data Type to NW Elasthane column while adding it to Datatable. As a result, it assigns 0 to empty column values.

15

If you want blank NW Elasthane, then you’ll have to assign N.W Column String datatype.
And Implement If Else like this,

If_Else_String
If_Else_String780×305 8.87 KB

16

Thanks a lot!!!

17

U can find the solution in this workflow
Format_Excel_Column_NewData.xaml (6.6 KB)

Attached the Output file here @Yudhisteer_Chintaram1
UIPath_Excel_Scratch.xlsx (25.6 KB)

18

Thanks a lot!

19

Welcome,
Please mark as a Solution @Yudhisteer_Chintaram1