Hi, I have a sheet where I need to convert the values of some columns into decimal values upto 2 decimals. the column names are:- decimal1,decimal2,decimal3,deciaml4,decimal5,decimal6. I have attached a sheet for the same. Test2.xlsx (10.3 KB) Can anyone let me know how to do it??

Use invoke code activity and pass this dt.AsEnumerable().ToList().ForEach( Sub(row) row.SetField("decimal1", String.Format("{0:0.00}", Convert.ToDouble(row("decimal1").ToString))) row.SetField("decimal2", String.Format("{0:0.00}", Convert.ToDouble(row("decimal2").ToString))) …

Converting column values to decimal upto 2 values

Help Studio

Kunal_Jain (Kunal Jain) October 23, 2023, 9:06am 9

Hi @Palaniyappan
Yes I have added an excel application scope and a read range activity.
And commented out the code of build data table.

How to get just two number after decimal places

Topic		Replies	Views
Could not able to make column value into two decimal Studio studio , question , activities_panel	6	287	November 21, 2023
Need help to convert column value to 2 decimal Studio excel , robot , studio	6	3004	May 15, 2021
How to add 2 decimal at end of column number Studio	11	388	August 5, 2023
String to double conversion Help	22	9397	March 19, 2019
Column values to 2 decimal places Academy Feedback lp_business_analyst_fnd	3	934	May 9, 2023

Most Active Users - Yesterday
ashokkarale
Yoichi
jawagarraja123
ppr
anjani_priya
Sayed_Tabrez2
devasaiprasad_K
MD_Farhan1
Parvathy
shashidhar.marihal
More details...

Converting column values to decimal upto 2 values

Related Topics