Read cell with numeric value in Excel

[E.T.S]

Hello,

I am using a read cell activity to read a numeric value in one of my cells in Excel. I am getting this error when running that activity:

Unsure how to resolve?

Cheers

[Anil_G (Anil Gorthi)]

@E.T.S

it is advised to store the value in genericvalue type variable

and then use .ToString or Cint() or CDBL to convert it as needed

if you chnage variable type it should get fixed

cheers

[lrtetala (Lakshman Reddy)]

Hi @E.T.S

Check Preserve Format option in Read Cell activity

Cheers!!

[E.T.S]

Hi,

Thanks for your reply,

When I tried that the numbers are pulled through but not in the same format as in the cell. The cell has the value £600,000 so when I click preserve format that value being extracted is 600000

[lrtetala (Lakshman Reddy)]

@E.T.S

It is extracted perfectly can you check below ss

[E.T.S]

HI,

`thanks for your reply,

This is pulling the numeric value but not the rest of the value. The value in my cell is £600,000 and the value being pulled is 600000

[E.T.S]

The properties of the read cell is:

Which is giving me the error:

[lrtetala (Lakshman Reddy)]

@E.T.S

Can you share the sample excel file

[E.T.S]

Hi,

Unfortunately I cannot send the file but I did notice this in the Excel:

This is the value in the cell:

But this value is different here:

I think the bot is extracting the second value

[Anil_G (Anil Gorthi)]

@E.T.S

you can use preserve format …ideally it reads the backend value…may be your excel cell is formatted to display as currency

as said change variable to genericvalue and use preserve format

cheers

[E.T.S]

This works and gave the value I needed thanks!