Datatype not accepting

Help Activities
, , , , , , , ,
1

In need to read Excel A13 value when the value has single value ie 12345 it is accepting in double and not accepting in string but if it has two value ie12345,12456 it is accepting in string not in double how to resolve this in UiPath

2

@sruthesanju,

Are you using Read Cell activity? If yes, one option would be get the value in string and then convert it into the desired datatype.

If anything else, please share some more context.

3

If I get the single value in string it is throwing error as cannot convert from double

4

When comma is the decimal seperator (check within debug and debugging panels)
Understanding the 6 Debugging Panels of UiPath in the easiest way possible! - News / Tutorials - UiPath Community Forum

then we can convert / check by

The image shows the Immediate Window in Visual Studio with three examples of parsing and trying to parse numeric strings with German (de-DE) culture settings, highlighting successful parsing for valid strings and failure for a string containing non-numeric characters. (Captioned by AI)
The image shows the Immediate Window in Visual Studio with three examples of parsing and trying to parse numeric strings with German (de-DE) culture settings, highlighting successful parsing for valid strings and failure for a string containing non-numeric characters. (Captioned by AI)767×170 44.1 KB

Double.Parse("12345,12456", System.Globalization.CultureInfo.CreateSpecificCulture("de-DE"))
Double.TryParse("12345,12456",NumberStyles.Any,System.Globalization.CultureInfo.CreateSpecificCulture("de-DE").NumberFormat,nothing)
5

@sruthesanju,

Check the Checkbox of this property Use display format and try

An image showing a UiPath workflow with a "Read Cell Workbook" activity configured to read cell A1 from "Sheet3" of "Input.xlsx," with the "Use display format" option enabled. (Captioned by AI)
An image showing a UiPath workflow with a "Read Cell Workbook" activity configured to read cell A1 from "Sheet3" of "Input.xlsx," with the "Use display format" option enabled. (Captioned by AI)1845×516 102 KB

6

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