How to write doubles into excel

[naotosx (Naoto)]

Hi,

i’ve been triying to write or transform amounts in my excel to take them as values not as string, i mean:

This is my excel

"The number of this cell has text format or is preceded by an apostrophe "

i tried to use Format Value activity but it does not work

There is a way to do this ? i need them as double be cause i need to upload this excel with that column format

My excel:
excel.xls (366.9 KB)

[dkollyns (Diógenes Kollyns)]

Hello @naotosx

Is this data a DataTable?

[naotosx (Naoto)]

this come from a .csv from a web page

[Vivek_Arunagiri]

Use Assign NewDecimal = Convert.Todecimal(“inputString”)

[naotosx (Naoto)]

Thanks!, you mean like this:

Convert.Todecimal(“valor”)

be casue i get this error:

mmmmm

[dkollyns (Diógenes Kollyns)]

@naotosx

Can you share your code ?

[naotosx (Naoto)]

of course my friend excel - copia.xlsx (13.7 KB)
Main.xaml (9.8 KB)

[dkollyns (Diógenes Kollyns)]

@naotosx

See attached, it’s working!
Convert.xaml (12.3 KB)
convert.xlsx (13.7 KB)

Hope it Helps

[naotosx (Naoto)]

the decimal character is deleted in the result excel :C

[dkollyns (Diógenes Kollyns)]

I don’t understand.

Do you need the result as image below ?

that you need

Result

Or do you need the result as Double?

[naotosx (Naoto)]

yes as the imagen if you take a look you’ll see that e.g 381,95 → result: 38195 but i thiink that i found a way , i’m testing

Main.xaml (147.3 KB)

And it works . I really apreciate your time and help

[dkollyns (Diógenes Kollyns)]

Ok, So check this topic as solved.

Have a good day