Integer formatting in excel

[aquinn]

Hi, I am using the write range to input an integer into an excel spreadsheet but excel is then formatting it as X.XXXXX+16 opposed to the actual number I need to get out of the cell at a later time, how can I format it to be pulled as the whole integer or as a string?
Please see attached

[ppr (Peter Preuss)]

have a look here for reformatings

When i try write a DT to excel, it deletes zeros for only 6 digit numbers. Do you have any idea how to solve this problem

give a try on reformat the cell format by a custom format. We can use following activity to do this: [grafik] [grafik] The custom format you can prototype manually in excel Also have a look here on e.g. the ’ (Apostroph) approach

[Palaniyappan (Palaniyappan P)]

Hi

Please check the below options

1. Try changing the type of the column as “Text” and it worked

2. We can either use this activity
   https://docs.uipath.com/activities/docs/format-value

3. Convert exponential values in excel to numbers

Cheers @aquinn

[aquinn]

Hi, How would i change it to string through UiPath?

and I tried the string row (“ColumName”).ToString.expression=Integer.Parse(row(“ColumnName”).ToString,System.Globalization.NumberStyles.Any)) from suggestion 3 and it flags me an error

@aquinn

[Palaniyappan (Palaniyappan P)]

Add .ToString
Atlast to this expression

@aquinn

[aquinn]

please see attached

[aquinn]

[Palaniyappan (Palaniyappan P)]

Are u using this in a assign activity inside a for each row activity
If so it’s like this

row(“yourcolumnname”) =
Integer.Parse(row(“ColumnName”).ToString,System.Globalization.NumberStyles.Any)).ToString

row(“yourcolumnname”) in left side of assign and then after equals to should be in right side

Cheers @aquinn

[aquinn]

@Palaniyappan

row(“yourcolumnname”) =
Integer.Parse(row(“ColumnName”).ToString,System.Globalization.NumberStyles.Any)).ToString

I want to store the output of the column in a variable, how would I do this?

[aquinn]

and i am still getting the error mesage

[Palaniyappan (Palaniyappan P)]

Pleas retype it again

I could see the column name is different and pls type from your end
@aquinn

[aquinn]

[Palaniyappan (Palaniyappan P)]

Remove this part
row(“yourcolumnname”) =

In that expression
@aquinn

[aquinn]

@Palaniyappan

Integer.Parse(row(“ColumnName”).ToString,System.Globalization.NumberStyles.Any)).ToString

Sorry i have done that now, but am getting this:

[aquinn]

the value is too large for int32

[aquinn]

30855000032420900 this is an example, they are all this length