Thank you Karl.
That's exactly what I am doing. I wanted to go a step
further and read in the contents of a cell containing
a logical formula.
1. When reading it as a string I get "", it would be
nice if I could read it as getBooleanCellValue().
2. I also wanted to determine if the cell (containing
a formula which returns numeric value) is of type
date.
double cellValue = theCell.getNumericCellValue();
if (Double.isNaN(cellValue)){
// string value
String strCell = theCell.getStringCellValue();
} else {
// numeric
....
}
--- "KHZ (SAW)" <[EMAIL PROTECTED]> wrote:
> Hi Davinder.
>
> Actually you can query it as a numeric or a string
> value. If you've
> chosen the wrong type the result is "" or 0.
> Unfortunately you don't see
> the type. You just can look for the most reasonable
> result.
>
> Regards, Karl-Heinz.
>
>
> -----Urspr�ngliche Nachricht-----
> Von: Davinder Kohli [mailto:[EMAIL PROTECTED]
> Gesendet: Freitag, 16. Juli 2004 22:36
> An: POI Users List
> Betreff: formula return type
>
> Hi,
> How do I determine the return type of a formula? Is
> there an API provided to do this or do I need to
> checkout the formula and then determine its return
> type.
>
> Thanks,
> Davinder
>
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Mail - 50x more storage than other providers!
> http://promotions.yahoo.com/new_mail
>
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> [EMAIL PROTECTED]
> For additional commands, e-mail:
> [EMAIL PROTECTED]
>
>
>
>
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> [EMAIL PROTECTED]
> For additional commands, e-mail:
> [EMAIL PROTECTED]
>
>
__________________________________
Do you Yahoo!?
Yahoo! Mail - 50x more storage than other providers!
http://promotions.yahoo.com/new_mail
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
