How to write doubles into excel

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
image

image
"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)

Hello @naotosx

Is this data a DataTable?

this come from a .csv from a web page

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

2 Likes

Thanks!, you mean like this:
image
Convert.Todecimal(“valor”)

image

be casue i get this error:
image

mmmmm :disappointed_relieved:

@naotosx

Can you share your code ?

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

@naotosx

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

Hope it Helps :wink:

2 Likes

the decimal character is deleted in the result excel :C

I don’t understand.

Do you need the result as image below ?

that you need
image

Result
image

Or do you need the result as Double?

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 :smiley: . I really apreciate your time and help :wink:

2 Likes

Ok, So check this topic as solved.

Have a good day :slight_smile:

1 Like

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.