Re: POI-HSSF classes

On 5/1/2014 4:13 PM, Alan Cassidy wrote:

I've been tasked with a project that starts with reading data from an Excel file. The file is very complex, includes a Pivot table, and quite a number of multiple sheets. The accountant creates it with a lot of macros. I've not programmed with Excel files yet, or even Java, except to create comma-delimited files.

So Scott's wrapper functions are pretty much exactly that: wrappers for
POI functionality provided by the Java POI project. Scott hasn't
wrappered /every/ POI class and method, but he's done a lot. That's
prefatory to saying that the real place to look for functionality
questions is the Java POI project.

Formula support in POI is a work in progress.
http://poi.apache.org/spreadsheet/formula.html I have a proof of
concept program that has a formula evaluator; I'm ashamed to say that I
don't know if I wrote it or if Scott did. Search for
FORMULA_EVALUATOR_CLASS. If you can't find it, I remember a thread not
too long ago where I posted the pieces...
http://archive.midrange.com/rpg400-l/201306/msg00022.html

--buck