Need Help reading Font color from POI. I have a excel file with few rows of data and need to store dthe font color, font type and font size in database. I tried getting cellStyle ann get color it give me short value but when I tried to get the actual Color value from Pallete it give me null. Any sample code iN this regard would be a great help
Thanks hema -----Original Message----- From: Tewari,kuldeep [mailto:[EMAIL PROTECTED] Sent: Monday, July 25, 2005 4:34 AM To: POI Users List Subject: RE: reading cells containing % values. 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/ --------------------------------------------------------------------- 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/
