data format

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

data format

Avik Sengupta
Dumb question:

How does one get the data format of an existing cell (ie, excel file
read in by POI) as a string (ie, as '#0.00')

TIA
-
Avik



---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
Mailing List:    http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta POI Project: http://jakarta.apache.org/poi/

Reply | Threaded
Open this post in threaded view
|

RE: data format

Laubach Shawn Contr 327 CSSG/GFSL
Get an instance of the formatter then pass in the format index from the cell
style.

http://jakarta.apache.org/poi/apidocs/org/apache/poi/hssf/usermodel/HSSFData
Format.html#getFormat(short)

http://jakarta.apache.org/poi/apidocs/org/apache/poi/hssf/usermodel/HSSFWork
book.html#createDataFormat()

http://jakarta.apache.org/poi/apidocs/org/apache/poi/hssf/usermodel/HSSFCell
Style.html#getDataFormat()

Shawn

-----Original Message-----
From: Avik Sengupta [mailto:[hidden email]]
Sent: Friday, May 20, 2005 3:03 AM
To: [hidden email]
Subject: data format

Dumb question:

How does one get the data format of an existing cell (ie, excel file
read in by POI) as a string (ie, as '#0.00')

TIA
-
Avik



---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
Mailing List:    http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta POI Project: http://jakarta.apache.org/poi/

---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
Mailing List:    http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta POI Project: http://jakarta.apache.org/poi/