Need help to convert column value to 2 decimal

[Anneng]

Hi,
I need help to convert the column D into two decimal. I have tried using format value but it don’t work due to it only accept the var as generic value. Once i use read range and get a Var, the var will become datatable and it won’t be able to work in format value. Please help how am i going to change to two decimal place?

[ppr (Peter Preuss)]

@Anneng
we can convert as following

An essential approach could look like:

• use a for each row and iterate over all rows
• use an assign for douing the conversion row(YourColNameOrIndex) = Convert.ToDouble(row(YourColNameOrIndex)).ToString(“F2”)

[balupad14 (Balamurugan)]

Hi @Anneng ,

Take a look on this.

UiPathGo - BalaReva Excel Activities

Hi , In the release Version 2019.2.0. I have added a new activity called Change Cell Type. It changes the format of the value like below. [image] In the Cell Format , can specify the custom format what we have in the excel Like below image. [image] Sample : UiPathGoExcel.zip (18.4 KB) This is the video to configure the package in local. Here is the link to know about the formats. Regards Balamurugan.S

UiPath | How to change the cell or column format in Excel | Guide (datatype)

Regards
Balamurugan.S

[saijagadesh06 (Jagadeesan)]

@Anneng - Please refer the xaml file.

Excel.zip (8.7 KB)

Happy Learning

[Anneng]

conversion row(YourColNameOrIndex) = Convert.ToDouble(row(YourColNameOrIndex)).ToString(“F2”)

Do you have a sample? I can’t follow and what does convert.ToDouble means?

[Anneng]

Thanks, I will test it out now.

[Anneng]

I have error Write Line: Format specifier was invalid.
I change the column 0 to my column index 8 and the F2 to another cell. It seem like cannot work on write line.
Maybe you can explain Convert.ToDouble(CurrentRow(0)).ToString(“F2”), how does it work?

By the way how do you write the result back to the excel? Write line is only on the uipath system. I try write range and write cell, does not seem to be working.