Re: Import from Excel — once more, with feeling. :-) (Apache POI)
Hi Rob,
IMHO finding anyone with those targeted skills will prove a challenge. Like others have said previously there are multiple alternatives already available for getting Excel to work with omnis that are powerful enough to let you get away with anything you want to do.
OTOH, as Bas & Clifford mentioned there is the python framework for manipulating Excel docs.
Finally, and this may probably not help you out, BUT, did you know that an XLSX document is actually a zip file? try changing the extension to zip and unzip that file to dig into the guts of the document. You may get what you want without going down a rabbit hole. 😉
Vik Shah
Keys2Solutions
> On 27 Feb 2018, at 01:45, rab tab <rabtab70@gmail.com> 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.
> Rob
>
>
> Rob Alexander
> Mophilly
>
> “Straight ahead and strive for tone.” — Frank Marocco
>
>> On 20180223, at 13:53, Grant Thiessen bookitinc <bookit@bookitinc.com> wrote:
>>
>> I do this a list.
>>
>> I define a list, then:
>>
>> Set current list lvList
>> Define list {whatever fields you need}
>> Prompt for import file
>> If flag false ; user cancelled
>> Quit method
>> End If
>> Prepare for import from file {Delimited (tabs)}
>> Import data lvList
>> Close import file
>> End import
>>
>> loads the excel file into my list, where I can do what I want with it, manipulate, save data, etc.
>>
>> Grant
>>
>>> On 02-23-2018, at 12: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
_____________________________________________________________
Manage your list subscriptions at lists.omnis-dev.com
Start a new message -> mailto:omnisdev-en@lists.omnis-dev.com