Copy csv file to excel with decimal problem after decimal point

Help Forum
1

to copy a csv file to exel i use read csv and write it in a excel file, this part work well but when i check the result a have a difference on number.

in the csv file i have : 102,562 and after copy i have 102562

I don’t understand because i have no problem with 2 decimal only if the number have 3 decimal after decimal point
image

2

Hi ,

I hope comma is the decimal point here but in excel it is generally taken as number separators.

The below function can be used in the Excel to change number seperator and Decimal format
=NUMBERVALUE(Text,Decimal_separator,Group_separator)

1 Like
3

The datatable in which you read the CSV, make sure the column you are facing the issue in has string data type. The commas are getting affected because CSV uses comma as separators.

If the final Excel is a template, you can add the datatype on a column too, make it as a currency datatype

2 Likes
4

Hi Try this

Excel Scope Read Range, store in DataTable variable
    For each row In dt1
        Assign activity: row("YourColumnName") = "'"+If(IsNumeric(row("columnname").ToString), CDbl(row("columnname")).ToString("0.00"), "0.00")
    
    Write Range, use the DataTable variable and overwrite the excel file.

Hope this will work!!!

1 Like
5

Hi @ghazanfar
it doesn’t work for me

image
image880×412 8.57 KB

6

@Priyanka_Ramesh

Do you have a sample plz ? i dont really understand

7

@rahulsharma

I use semicolon in read csv
image

8

to copy a csv file to exel i use read csv and write it in a excel file, this part work well but when i check the result a have a difference on number.

in the csv file i have : 102,562 and after copy i have 102562
The good number is : 102,562

I don’t understand because i have no problem with 2 decimal only if the number have 3 decimal after decimal point
image

9

I can not see any “decimal point”, but comma. Does it mean that comma is decimal separator in your CSV?

Cheers

1 Like
10

@J0ska
yes the separator is ==> ;

11

This is the CSV separator, NOT decimal separator, right?

The value “102,562” should read “one hundred and two” or “one hundred and two thousands?”

Cheers

1 Like
13

@J0ska
in the csv file i have : 102,562 and after copy i have 102562
The good number is : 102,562

14

I can not help you if you do not answer to the question :frowning:
Bye

1 Like
15

sorry :slight_smile:
The value “102,562” should read “one hundred and two”

16

grafik

2 Likes
17

In that case your system - system locale - is set-up to interpret comma as thousands separator (not decimal separator) → before writing to Excel replace comma “,” by point “.”

And indeed check your system locale.

Cheers

1 Like
18

@ppr
so i need to use read column activity after copying the csv file in the excel file and replace it instead of 102,562 in your sentence right ?
Double.Parse(ColonneDecimal.ToString, System.Globalization.CultureInfo.CreateSpecificCulture(“fr-FR”)).ToString

19

@J0ska
i have any problem if the number have 2 decimal ==> example 120,05
but if the number is 120,503 it doesnt work

20

Hi @Soudios

Refer the thread

Regards
Gokul

1 Like
21

@Gokul001
it doesnt work