Read Cell Value activity failing to read cell data

[Thobile_Bengane]

I am trying to read data from a single excel cell using the Read Cell Value activity. The variable I am writing this output to is a string variable, and the contents of the cell of interest is a 5-digit number. Unfortunately, keep getting this error message: StringConverter cannot convert from System.Double. Please help.

[mkankatala (Mahesh Kankatala)]

Hi @Thobile_Bengane

Try changing the out_invoiceNumber argument to System.Double datatype and try.

Hope it helps!!

[Thobile_Bengane]

Hi @mkankatala . Thanks for your prompt response. Unfortunately chaging to a double varibale just gives me a validation error.

[mkankatala (Mahesh Kankatala)]

Keep the argument type in string. Execute and show me what is the error you are getting in the output panel. Take a screenshot and share with us… @Thobile_Bengane

[ashokkarale]

@Thobile_Bengane,

Keep the variable datatype to string and check the checkbox Get formatted text this should return the output as string.

Thanks,
Ashok

[ashokkarale]

@Thobile_Bengane,

This way.

Thanks,
Ashok

[Thobile_Bengane]

this worked, thank you