How to resolve " String cannot convert to double"

Hi All

I have read values from excel but i got following error

Excel value: 12345000080

Can anyone know how to resolve it?

HI @divya.17290

Can you share the screenshot of Look up DataTable Properties

Try like this in the Look up DataTable activity

Cdbl(Currentrow("Column name").Tostring)

Regards
Gokul

I read and store as a string but i got error " String cannot convert to double"

Hi @divya.17290

Share the Screenshot of the Assign activity. How did you convert to double.

You are converting the string into Double.

For that Try this

Use Assign activity

Create an Variable LHS : Input
In the RHS : Cdbl(Currentrow("Column name").Tostring)

Regards
Gokul

I didn’t convert anystring value, i m just read the row and assign to a string variable then i got error

Hi @divya.17290 ,

Try changing the Output variable of Look Up Datatable Activity to UiPath.Core.GenericValue type variable and check if you are able to get the Output.

Hi @divya.17290

Change the datatype of the variable that you have used in the cell value properties of Lookup datatable to double

Regards
Sudharsan

2 Likes

Hello @divya.17290 , the error is due to the value in excel sheet might be in double. So change the lookup variable type as a system.double, the error will be clear.

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