Service Virtualization

Hi All

 Devtest version: 10.2.4

Issue:

1.We are preparing an input sheet using formulas.

2.When we are trying to read a numeric value from excel say 3.00 devtest is reading it as 3 resulting in failure of the case

How can we resolve this issue?

Thanks and Regards

Yugain

I think you need to mark that Excel cell as “text” and not as numeric. The consequence will be that this property will be a String property  in DevTest.

In my (hands-on) experience, the excel-to-java interface that is used by DevTest seems to interpret the excel cell content and transforms.

Cheers,

Danny

Hi Danny

Thanx for the reply. But the suggestion is not working out for me

Regards

Yugain

What step are you using to read the Excel values in DevTest? 

Hi Shiney

We are reading data using Read Data from excel option under Data Set section

Regards

Yugain

Do you mind sharing your Excel sheet.  I am not able to reproduce the issue. 

Hi Yugain,

Please see the attached project.  I was able to implement Danny's suggestion and preserve the decimal places.  In the Excel document I read, the numeric fields are formatted as text.

--Mike