Re: Import from Excel — once more, with feeling. :-) (Apache POI)
use the libxl based xcomp that is available free of charge to all (it will cost you $199 in a licence from the libxl guy, but thats peanuts).
its dirt simple.
and you can import spreadsheets with calculations in them … and you get the values.
thats how we wrote the xcomp … and it works
see you at the third annual users conference
> On Feb 23, 2018, at 11:29 AM, rab tab <email@example.com> wrote:
> Hi $all,
> Importing directly from Excel has once again reared its head. 🙂
> I recently searched through the list archive on this topic and got some quite usable info. (Thanks everyone.) I still think the simplest way to accomplish this is via a CSV or, preferably, tab-delimited file, but I’m exploring ways to do this using a native Excel file directly. (I’m aware of LibXL, libxl.com.)
> Has anyone tried using “Apache POI – the Java API for Microsoft Documents?” poi.apache.org/index.html
> Any comments, opinions welcome.
> Rob Alexander
> “Straight ahead and strive for tone.” — Frank Marocco
> Manage your list subscriptions at lists.omnis-dev.com
> Start a new message -> mailto:firstname.lastname@example.org