Re: Import from Excel — once more, with feeling. :-) (Apache POI)
The issue we run into at our Mac clients is that Apple has done a bang
good job making people afraid of JAVA. With the Studio 6 installation
using JAVA and popping up a nice message from Apple along the lines of
“we’ve removed JAVA from the OS because it’s as leaky as a basket case”
(and yes I’m paraphrasing) there isn’t a whole lot of good will with our
clients when you suggest installing a JAVA client anyway.
Even if by now in Studio 8 it can use the latest 64bit version of JAVA,
the scare tactic has been enough for Mac users to say “Client says no”
to anything that even smells of JAVA.
We removed JAVA support from our Studio installations a long ago and I’m
pretty happy that Omnis is moving away from using JAVA as a core
technology and instead making more use of Python.
So while I can’t say whether Apache’s solution is any good or not, I did
want to give a note of warning that you’re clients might not be thrilled
when asked to deploy JAVA on their clients if they are mac based.
Note that python seems to have libraries for writing to xls as well:
And with Python 2.7 coming hardwired into Mac OS and being part of the
JobBag installation on Windows those should be options as well.
Admittedly I haven’t tried them, I might actually give them a run for
their money later in the week.
On 27/2/18 2:45 am, rab tab wrote:
> Hi all,
> Specifically, does anyone have experience with “Apache POI – the Java API for Microsoft Documents?” poi.apache.org/index.html ?
> Grant, I’m already quite familiar with importing and manipulating a comma- or tab-separated text file. I appreciate the reply, though. 🙂
> Chris, yeah, I know about the DDEs etc, available, but this has to be for both Windows and Mac.
> Doug, Mike, I’ve heard about libxl based xcomp (good things), 🙂 and that may be the way we go, but want to know if anyone has any experience with Apache POI.
> Thanks everyone.