×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
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
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
