[ajug-members] server side upload Excell, db insert columns

[David Wible]

The poi/hssf is a nice solution and works!

I've used it and would recommend to anyone considering it.  The only thing I 
found was make sure that xls has no filters on the columns (Data>Filter>Auto 
Filter in excel).

dw

>From: Scott Mitchell <smitchelus at gmail.com>
>Reply-To: scott at the-mitchells.org,        "General AJUG membership forum 
>(100-200 messages/month)"<ajug-members at ajug.org>
>To: "General AJUG membership forum (100-200 
>messages/month)"<ajug-members at ajug.org>
>Subject: Re: [ajug-members] server side upload Excell, db insert columns
>Date: Wed, 27 Apr 2005 08:23:16 -0400
>
>Curt, have you looked at POI's HSSF project? It is an API for
>reading/writing Excel spreadsheets. We use it for data conversion programs.
>Here's a link to their quick start which shows some code examples:
>http://jakarta.apache.org/poi/hssf/quick-guide.html
>
>Scott
>
>On 4/27/05, Curt Smith <chsmith at speakeasy.net> wrote:
> >
> > Anyone solve the MS Excell spread sheet upload and import columns into a
> > DB problem?
> >
> > My first thought is to require the customer to save as .csv and then do
> > simple row parsing on comma or space.
> >
> > Any toolkits or API's out there?
> >
> > Tnx and good luck, curt
> >
> > Curt Smith
> > csmith at javadepot.com
> > (w)404-897-3073
> > (h)404-294-6686
> >
> > _______________________________________________
> > ajug-members mailing list
> > ajug-members at ajug.org
> > http://www.ajug.org/mailman/listinfo/ajug-members
> >
>_______________________________________________
>ajug-members mailing list
>ajug-members at ajug.org
>http://www.ajug.org/mailman/listinfo/ajug-members