Re: Import from Excel — once more, with feeling. :-) (Apache POI)
so rather than look for obscure solutions..
reading an excel file using the Excel xcomp is basically no code and cross platform and solves all those issues.
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 27, 2018, at 11:44 AM, Thad Bogert <thad@technosolver.com> wrote:
>
> If the file is in the newer .xlsx format you can unzip the file and read worksheet data using oXML. The biggest limitation to this approach is that the worksheet would need to contain raw values. Otherwise you would need to create an interpreter to parse and execute functions and references.
>
> professor-excel.com/xml-zip-excel-file-structure/
>
> Inversely I don’t think it would require a lot of effort to create a class to export data in an excel format.
>
>
>
>
>
>> On Feb 23, 2018, at 1:29 PM, 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