× 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 Wed, May 21, 2014 at 9:00 AM, Jon Paris <jon.paris@xxxxxxxxxxxxxx> wrote:
Unless I'm misremembering John, Alan reached this point of having
the users save off in XML format (his idea not mine) _after_ having
tried the POI classes to access the data directly. I would have
recommended that approach (or PHP or ...) had he not already
gone down that route.

Having the users save in XML was definitely his idea. And I never
meant to imply that your *first choice* would be for the users to save
multiple XML worksheets. I just felt that if you had gotten to the
point where you were even *considering* asking the users to do yet
another step, then it was at least worth taking one more look back at
other alternatives.

He did start on the POI path before deciding on XML, but it's not
clear how far he got. What I mean is, I don't know if he got to a
point where *POI* couldn't do the job, or to a point where *he*
couldn't get POI to do the job.

I suspect that XML then became more attractive because (1)
conceptually, processing XML from scratch is simpler than processing a
"native" Excel file from scratch (even the .xlsx variety); and (2)
when you receive an XML file, you can *see*, with your own eyeballs,
what's in it. The end result is tantalizingly close. If you receive
an Excel file, you can't just open it in a text editor or even a hex
editor and go "ah, I see, you just have to pick out these pieces and
Bob's your uncle". No, with an Excel file, you really need proper
tooling.

Now, I did bring up some questions regarding POI (because I don't have
personal experience with it, and was trying to establish whether it
was indeed up to the task), but they never got answered. They mainly
had to do with formulas. I specifically mentioned that the packages I
*am* personally aware of can retrieve values from formula cells
(provided that those formulas were evaluated by Excel, and that the
workbook was saved by Excel). No answer.

My fear was that Adam (and others on this list) didn't really
understand what I was talking about, and thus didn't give my
alternatives a fair shake. Even then, I was completely fine with
that. I only spoke up again when your exchange with Adam showed that
the XML approach isn't turning out to be as straightforward as hoped.
That's why I've attempted to revisit the direct Excel-reading path,
but this time with concrete examples.

John Y.

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.