poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Igor Androsov <iandro...@yahoo.com>
Subject Re: HSSF POI READING FORMULAS IN AN EXCEL ARCHIVE
Date Fri, 20 Jan 2006 00:08:21 GMT
Everyone thank you for infrmative reply I will try
these cases on my code.

Igor

--- Daniel Noll <daniel@nuix.com.au> wrote:

> Donahue, Michael wrote:
> > Igor -
> >
> > I haven't had an opportunity to use HSSFDateUtil
> on a cell of type
> > CELL_TYPE_FORMULA, but I believe all cells have an
> assigned cell style and
> > all cell styles have an assigned data format.  So
> it would seem that you
> > could just copy the nested if
> (HSSFDateUtil.isCellDateFormatted(cell)) from
> > my example to check the data format of any cell
> type.  If it's a date data
> > format, then process it as a date, else handle it
> as a formula.
> >   
> (I think you mean "else handle it as a number", but
> regardless...)
> 
> This is more or less what I'm doing in our code
> here.
> 
>     private String cellToString(HSSFCell cell) {
>         switch (cell.getCellType()) {
>             // other cell types ...
>             case HSSFCell.CELL_TYPE_NUMERIC:
>                 return cellValueToString();
>             case HSSFCell.CELL_TYPE_FORMULA:
>                 return cell.getCellFormula() + "=" +
> cellValueToString();
>         }
>     }
> 
>     private String cellValueToString(HSSFCell cell)
> {
>         if (HSSFDateUtil.isCellDateFormatted(cell))
> {
>             return
> DATE_FORMAT.format(cell.getDateCellValue());
>         } else {
>             return
> String.valueOf(cell.getNumericCellValue());
>         }
>     }
> 
> It works "well enough".  I would rather format the
> value using the real 
> date format that the sheet had configured, but
> HSSFDataFormat returns 
> formats which bear no relationship to the
> SimpleDateFormat class, and I 
> have no current interest in using regular
> expressions to mangle them 
> enough to make them usable. :-)
> 
> I also wonder: what if the formula result is a
> boolean?  Is that 
> possible in Excel?  What if it's a string?  I should
> also check for 
> string formats, I suppose (format 0x31), but there
> isn't a format for 
> booleans.
> 
> What would have made life a whole lot easier is a
> method to get the 
> value of the cell as an Object.
> 
> And who knows what "General" means... if it's a
> number format, it 
> certainly isn't clear how it differs from the other
> number formats.
> 
> Daniel
> 
> 
> -- 
> Daniel Noll
> 
> Nuix Australia Pty Ltd
> Suite 79, 89 Jones St, Ultimo NSW 2007, Australia
> Phone: (02) 9280 0699
> Fax:   (02) 9212 6902
> 
> This message is intended only for the named
> recipient. If you are not
> the intended recipient you are notified that
> disclosing, copying,
> distributing or taking any action in reliance on the
> contents of this
> message or attachment is strictly prohibited.
> 
> 
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> poi-user-unsubscribe@jakarta.apache.org
> Mailing List:    
> http://jakarta.apache.org/site/mail2.html#poi
> The Apache Jakarta Poi Project: 
> http://jakarta.apache.org/poi/
> 
> 


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/


Mime
View raw message