Re: Import from Excel — once more, with feeling. :-) (Apache POI)
hi rob.
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
Doug Easterbrook
Arts Management Systems Ltd.
mailto:doug@artsman.com
www.artsman.com
Phone (403) 650-1978
see you at the third annual users conference
tickets.proctors.org/TheatreManager/95/online?performance=29086 <tickets.proctors.org/TheatreManager/95/online?performance=29086>
> On Feb 23, 2018, at 11:29 AM, rab tab <rabtab70@gmail.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
>
> Rob Alexander
> Mophilly
>
> “Straight ahead and strive for tone.” — Frank Marocco
>
> _____________________________________________________________
> Manage your list subscriptions at lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en@lists.omnis-dev.com
_____________________________________________________________
Manage your list subscriptions at lists.omnis-dev.com
Start a new message -> mailto:omnisdev-en@lists.omnis-dev.com