[ajug-members] server side upload Excell, db insert columns
davewible at hotmail.com
Wed Apr 27 10:08:50 EDT 2005
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).
>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:
>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
More information about the ajug-members