Re: question re cell type and value when data is 'missing'

[Avik Sengupta <av...@itellix.com>]

I believe you can do that..  but dont take my word for it .. the quickest is to try it out on a small sheet, i would think. 

   -------Original Message-------
   > From: Steve <stephen@Basit.COM>
   > Subject: question re cell type and value when data is 'missing'
   > Sent: 20 Aug 2003 22:55:08
   >
   >  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
   -------Original Message-------