Losing decimal places when using JXL

[surendar prabu]

Hi,

I am trying to read an excel sheet using the JXL API. When reading a cell with float/double values, the

cell.getContents() 

is returning only 3 decimal places. i.e; I get 0.169 in place of 0.16945.
Help me on how I can read the exact number in the cell.

Regards,
Surendar.

[Allan Sy]

I am having the same problem. It always rounds to 3 decimal places for number. I need this because I am dealing with foreign exchange rates and it should not be rounded off.

Can anybody help?

Thanks!

[Allan Sy]

Check this one out.

http://www.andykhan.com/jexcelapi/tutorial.html#reading

But I'm still having problems because 0.000109 has been converted to 1.09E-4.

[Ulf Dittmer]

Allan Sy wrote:But I'm still having problems because 0.000109 has been converted to 1.09E-4.

That's the same number, just displayed differently. Have you tried a different cell format?

[Surodip Patra]

Try this :

((NumberCell)cell).getValue()

This returns Double value and all the decimal points.

Thanks,
Surodip