Re: Import from Excel — once more, with feeling. :-) (Apache POI)
I second this. You can use native Excel files this way and not insist on exporting int CSV or TXT type first.
Mike Matthews, Managing Director, Lineal Software Solutions Ltd
Apple Reseller, Microsoft Partner, SQLWorks Business Partner
phone: 01271 375999 | web: lineal.co.uk | email: mike.matthews@lineal.co.uk
> On 24 Feb 2018, at 02:11, Doug Easterbrook <doug@artsman.com> wrote:
>
> 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
_____________________________________________________________
Manage your list subscriptions at lists.omnis-dev.com
Start a new message -> mailto:omnisdev-en@lists.omnis-dev.com
