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