Hi, I have this column named “Product Category” and “N.W” as shown below: [image] I need to add a new column called “NW Elasthane”. 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” Whenever, “Product Cat…

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("N…

Format Excel column with new data

Help Activities

Shraddha_Gore (Shraddha Gore) April 20, 2021, 4:50pm 2

Check your thread.

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

2 Likes

Topic		Replies	Views
Add column with data to excel Activities datatable , excel , uiautomation , activities , data_scraping , question	3	681	April 24, 2021
Modify a row from a Uipath datatable Help datatable , excel , robot , studio	18	7015	October 29, 2018
Data scraping to Excel and add formulas Help activities , studio	15	956	May 9, 2019
How to add (string variable) data to excel column 5? Help studio	36	4202	February 11, 2019
Convert excel column to 2 decimal places Activities datatable , excel , selector , uiautomation , activities , data_scraping , question	8	3419	April 30, 2021

Format Excel column with new data

Related topics