RE: Transfer Exell to AS400 -- JAVA400-L

This is a multipart message in MIME format.
--
[ Picked text/plain from multipart/alternative ]
It would be very helpful if I could have sample of using POI.


Using standard JDBC, does it mean using JDBC from Microsoft?  It is Win2k
JDBC; I have not try it with XLS file.


Thanks,
CL






"Ducret, Gilles (CH)" <Gilles.DUCRET@lloydsbank.ch>
Sent by: java400-l-admin@midrange.com
03/05/2002 07:27 AM
Please respond to java400-l


        To:     "'java400-l@midrange.com'" <java400-l@midrange.com>
        cc:
        Subject:        RE: Transfer Exell to AS400


This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--
[ Picked text/plain from multipart/alternative ]
Is it possible to get a sample to transform Excell to XML using
POI. I can't find it on their web site?

-----Original Message-----
From: Jim Mason [mailto:jmason900@yahoo.com]
Sent: mardi, 5. mars 2002 16:12
To: java400-l@midrange.com
Subject: Re: Transfer Exell to AS400


Hi.

I've been able to read and write Excel spreadsheets to
and from DB2 data on different platforms without a
problem just using standard JDBC drivers...

Jim Mason

--- David Morris <David.Morris@plumcreek.com> wrote:
> CL,
>
> I am not sure why you need the intermediary step to
> XML, but
> it would seem that the challenge is getting the .XLS
> file to XML.
> I do not know if this will help, but the POI project
> does offer
> Java support for Excel files. POI is also now part
> of the
> Apache Jakarta project and is likely to pick up
> quite a bit
> of interest.
>
> If you are interested go to
> http://jakarta.apache.org/poi/ and
> check it out. I know that POI will run on the
> iSeries and others
> are using it to create XLS files. I don't know of
> anyone using
> it to read from .XLS files, but it is definitely a
> goal of the
> project.
>
> David Morris
>
> >>> Chanh_Le@countrywide.com 03/01/02 07:01PM >>>
> This is a multipart message in MIME format.
> --
> [ Picked text/plain from multipart/alternative ]
> Could you let me know where I can find an example
> how to load an MS
> Exell
> spreadsheet to XML then post to AS400 file.
>
>
> Thanks.
> CL
> _______________________________________________
> This is the Java Programming on and around the
> iSeries / AS400 (JAVA400-L) mailing list
> To post a message email: JAVA400-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit:
> http://lists.midrange.com/cgi-bin/listinfo/java400-l
> or email: JAVA400-L-request@midrange.com
> Before posting, please take a moment to review the
> archives
> at http://archive.midrange.com/java400-l.
>


__________________________________________________
Do You Yahoo!?
Try FREE Yahoo! Mail - the world's greatest free email!
http://mail.yahoo.com/
_______________________________________________
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
To post a message email: JAVA400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
or email: JAVA400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.


**********************************************************************
This E-mail and any files transmitted with it are confidential
and intended for the exclusive use of the addressee(s) only.
 You should not disclose its contents to any other person.
If you are not the intended recipient please notify the sender
immediately.
**********************************************************************
_______________________________________________
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
To post a message email: JAVA400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
or email: JAVA400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.



--