Thanks Avik and Michael. Appreciate the info that this may have been
recently added. However, can you be a little more direct? Which method do
you call to get the String that is the result of a formula in an Excel
created and saved document. (No macros have been used, just human entry).
Specif
If you load run the macro with the formula in Excel, then, yes, you will be
able to retrieve the String result of the formula using HSSF.
If you load or change the data with HSSF, then you will also be able to put
the formula into the cell. But you will not be able to retrieve the result
of that f
I think we recently added in the ability to retrieve string forumula values. I dont
remember if it was before or after 2.0pre3 .. which version are you using.
---Original Message---
> From: Will Glass-Husain <[EMAIL PROTECTED]>
> Subject: Re: retrieving saved String value of f
Thanks. Actually it's the reverse I want. I have an Excel spreadsheet that
contains a formula returning a String. I've a tool written in Java that
imports the data into a database. My question is simple: how hard is it to
implement the retrieval of the calculated String in Java. Is the calcula
Sounds interesting--where would I find that? I tried browsing CVS, but it's
not obvious where to look, i.e. which Java package.
- Rob
-Original Message-
From: Danny Mui [mailto:[EMAIL PROTECTED]
Sent: Saturday, October 25, 2003 8:03 PM
To: POI Users List
Subject: Re: Event-based API for
Have you checked out the HEAD? Andy put out the performance branch
there that reduces memory usage as well increasing performance. It's a
little broken right now but if it works for you...
Cocoon uses the usermodel at the end of the day :)
danny
Robert Lowe wrote:
I'm currently using POI to