Re: Import from Excel — once more, with feeling. :-) (Apache POI)
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