question re cell type and value when data is "missing"

[Steve <st...@Basit.COM>]

The HSSF documentaton says:  "Cells should have their cell type set to
either HSSFCell.CELL_TYPE_NUMERIC or HSSFCell.CELL_TYPE_STRING.  Cells must
also have a value set. Set the value by calling setCellValue with either a
String or double as a parameter."
However, I notice that there is CELL_TYPE_BLANK. Can this be used instead of
NUMERIC or STRING?
I have a worksheet where the cells are integers. However, in some cases the
data values are "missing" and
I don't want to put 0 in the cell. I want it to show up as "blank".  I'm not
sure if I should make that cell BLANK
and not set its value, or make it STRING with value of "".  Or, just NOT
CREATE the cell.

Which alternatives are allowed?
Which is best?



---------------------------------------------------------------------
To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-dev-help@jakarta.apache.org