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

@sruthesanju , Check the Checkbox of this property Use display format and try <a class="lightbox" href="https://global.discourse-cdn.com/uipath/original/4X/8/e/9/8e975c175baa393e5ba61ce9fa634c6d38c310b9.png" data-download-href="/uploads/short-url/klq5qtv1oeWiUJ4s6zfWeaJZmxX.png?dl=1" title="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)]

Datatype not accepting

Help Activities

sruthesanju (Sweety) November 8, 2024, 8:28am 3

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

Topic		Replies	Views
Get row item error: "StringConverter cannot convert from System.Double" Studio datatable , excel , activities , question	10	10477	May 15, 2020
ReadCell: Decimal Converter cannot convert from System.Double Studio activities , variable , data_manipulation	3	2844	February 28, 2020
Is it possible to convert a string value to double in Add Data Row Activity? Activities datatable , excel , uiautomation , activities , studio	7	268	March 9, 2024
Conversion of Double from Excel Activities excel , double	5	1190	April 9, 2023
StringConverter cannot convert from System.Double Help	20	57426	November 10, 2022

Datatype not accepting

Related topics