On Thu, 18 Oct 2012, Mani wrote:
For memory problem, i am using EventModel and sax parser to read the
data from the Excel. I have used the XLSX2CSV.java example given the
apache site. While reading the decimal number,it is not fetched as it in
the Excel Sheet. For eg, the value in the excel cell is 9.32226879.
After reading through the sax parser, i am getting it as
9.3222687900000007.
http://en.wikipedia.org/wiki/Floating_point
You're getting back exactly what is in the file, which isn't always
exactly what you expect...
Is there any way i can fetch the decimal number as it is in Excel.
You probably want to use DataFormatter, which applies excel style
formatting rules to raw numbers to give you strings like in Excel
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
