Reading values form excel (using workbook read range) but the value is comming as exponential, need to perform normal arithmetic operations on the values

Help
1

Hi Team,

I am working on the project automation where I have 9 values which I read from excel file
Filename:- xyz.xlsx
Sheet:- ABC
I am using “read cell” activity from workbook provision (I don’t want to use excel application scope due to some requirement reason)

Now for all these 9 values, I am reading them and printing them in message box:- I am getting it in exponential form

I want to use if condition on them to check if they are between -0.05 and +0.05.
But when I am doing the comparison the comparison going in the else condition (which meaning exponential number compared with integer value)

Please help.

@Palaniyappan, @HareeshMR, @aksh1yadav, @vishal.kp, @loginerror

2

Fine
may i know what was the condition expression used, a screenshot if possible
Cheers @hacky

3

The values in the excel are of what type?

4

@Palaniyappan

(PL2ValueH91 > -0.05 And PL2ValueH91 < 0.05) And (PL2ValueI91 > -0.05 And PL2ValueI91 < 0.05) And (PL2ValueJ91 > -0.05 And PL2ValueJ91 < 0.05) And (PL2ValueK91 > -0.05 And PL2ValueK91 < 0.05) And (PL2ValueL91 > -0.05 And PL2ValueL91 < 0.05) And (PL2ValueN91 > -0.05 And PL2ValueN91 < 0.05) And (PL2ValueO91 > -0.05 And PL2ValueO91 < 0.05) And (PL2ValueP91 > -0.05 And PL2ValueP91 < 0.05)

This is used in the if condition and PL2ValueH91, PL2ValueI91, etc being the variables of Read Cell activity

5

@vishal.kp

As per what I see, when I checked it in the format cells option in excel I see its of “custom” type.
And since its client’s file, I dont see myself changing to format.

6

using the read cell activity to what variable type are you passing the value?

7

@vishal.kp
—H91--------------I91------J91----------K91-------L91-----------N91--------O91------P91—
Capture
(Please note that M91 value is hidden)
This is how it looks like in excel file.
But when I take these values in “Read range” of workbook and also excel application scope into generic variable, I see that the output is :-
Capture

Above are the exponential values for the exact values (also in the excel file there are many formulas and calculations behind every cell).

8

After getting the values, can you try converting the values to double or integer and then check in the if condition @hacky? Just a suggestion

9

@HareeshMR

Thanks buddy, But I already checked this and it works fine.

Regards,
@hacky

10

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