Thanks Karl!
In the meantime I got the the solution(though a crude one)for my
problem.Now I am first reading the cell's data format.if this is a cell
having %,I multiply its Numeric value by 100 and append "%"to it and then
show it on UI.
thanks a lot.
regards.
KT.
-----Original Message-----
From: KHZ (SAW) [mailto:[EMAIL PROTECTED]
Sent: Friday, July 22, 2005 2:24 PM
To: 'POI Users List'
Subject: AW: reading cells containing % values.
Hi Tewari.
You receive the internal representation.
The % is just the external representation. So it's the same problem like
that with the date some days ago and also something with numeric data
just a few days ago.
Regards, Karl-Heinz.
-----Ursprüngliche Nachricht-----
Von: Tewari,kuldeep [mailto:[EMAIL PROTECTED]
Gesendet: Freitag, 22. Juli 2005 07:57
An: [email protected]
Betreff: reading cells containing % values.
Hi,
I have an excel sheet,some cells contain % values(50%,60%
etc...).When I read from the sheet, I get these values as .50,.60 etc..
Is there any way to get these values as they are in the excel sheet.
Please help.
regards.
KT.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
