I found out that using
org.apache.poi.hssf.extractor.ExcelExtractor
barely as
HSSFWorkbook wb = DnaEntryManager.readFile(filePath);
ExcelExtractor extractor = new ExcelExtractor(wb);
String text = extractor.getText();
System.out.println(text);
I get the file as a long string where the value calculated with FREQUENCY
formulas ARE included.
This way, parsing the string, I found a workaround to get the calculated
value.
Can anybody explain how/why the extractor is able to read the values and put
it in string format?
----- Original Message -----
From: "Stefano Bianchi" <[email protected]>
To: "POI Users List" <[email protected]>
Sent: Tuesday, January 03, 2012 5:07 PM
Subject: Re: POI-3.7 formula support (FREQUENCY)
Sorry,
the version included in 3.5 is merely empty:
public class
org.apache.poi.hssf.record.formula.functions.Frequency
extends
org.apache.poi.hssf.record.formula.functions.NotImplementedFunction
----- Original Message -----
From: "Stefano Bianchi" <[email protected]>
To: "POI Users List" <[email protected]>
Sent: Tuesday, January 03, 2012 5:02 PM
Subject: Re: POI-3.7 formula support (FREQUENCY)
Dear all,
I found information on the web
http://www.jarfinder.com/index.php/java/info/org.apache.poi.hssf.record.formula.functions.Frequency
that
org.apache.poi.hssf.record.formula.functions.Frequency
was actually included in previous releases, and in fact I could find the
related .class file in the 3.5 jar.
Any reason why it was not further included?
May I try to force using this class file in my code?
Any hint appreciated,
cheers
Stefano
----- Original Message -----
From: "Nick Burch" <[email protected]>
To: "POI Users List" <[email protected]>
Sent: Wednesday, November 09, 2011 9:02 PM
Subject: Re: POI-3.7 formula support (FREQUENCY)
On Wed, 9 Nov 2011, Stefano Bianchi wrote:
I am using POI-3.7-20101029.
You might want to try the most recent 3.8 beta, though I think it may
not help for this case
but could not find the list of built in functions.
You'll need to check the sourcecode for that. It'd probably be handy if
we could have something that would export the list from code to the
site, if anyone fancies working up a patch... :)
org.apache.poi.hssf.record.formula.functions.Frequency
class in the src distribution, I suppose this is not supported yet.
Can anybody confirm?
Will it be added? If yes, any plan?
I'd suggest you make a start on adding it in. It's not actually all that
hard to add new functions to POI. Yegor gave a talk last year that's a
good introduction to this:
http://people.apache.org/~yegor/apachecon_us2010/Evaluation_Of_Excel_Formulas_In_POI.pptx
If you get it working, please send in a patch!
Nick
---------------------------------------------------------------------
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
