Hi Marc:

Is this the class you might be looking for?

http://poi.apache.org/apidocs/org/apache/poi/hssf/usermodel/HSSFRichTextString.html

You can use HSSFCell.getRichStringCellValue() to get Excel formatted string.

http://poi.apache.org/apidocs/org/apache/poi/hssf/usermodel/HSSFCell.html

Or another interpretation of what you may be thinking is a combination of HSSFCell.getCellNum() and HSSFCell.getCellStyle()

http://poi.apache.org/apidocs/org/apache/poi/hssf/usermodel/HSSFCell.html

Hope this helps.


Marc Guillemot wrote:
Hi,

is there a simple way to get the formatted value (as String) of a cell
without having to use custom code to deal with the cell format?

If no, wouldn't it make sense to add such a feature?

Cheers,
Marc.

--
============================
Hsiang-An (Andy) Chien
Office of the Vice-Provost,
240-K, Planning and Budget
University of Toronto
Simcoe Hall
27 King's College Circle
Toronto ON M5S 1A1
(416) 978 5035
www.utoronto.ca/planning

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to