RE: As400 reading/writing excel files.

["Mangavalli, Ramanujam" <RamM@xxxxxxxxxxx>]

Actually, if you generate XML, you can create an XLS document. But I think,
you will need Office Web components installed.
When you save an XLS spreadsheet, try saving it as a web page. And then open
the web page using Notepad to see all the XML. If you open the webpage in
IE, you will see the Excel office web component bring up the sheet. I am not
an expert but just what I noticed in Office 2000 and above. And I think, you
can use RPG or cobol also to generate this XML.

HTH.


-----Original Message-----
From: Fenton, Tim [mailto:Tim_Fenton@hen.invesco.com]
Sent: Thursday, January 03, 2002 4:30 AM
To: 'java400-l@midrange.com'
Subject: RE: As400 reading/writing excel files.


SEQUEL's EXECUTE command allows you to use SQL to output in Excel format on
AS/400:
        PCFMT( *XLS )


-----Original Message-----
From: Bharath V.S. Dhurjati [mailto:bharath@pswebworks.com]
Sent: 03 January 2002 04:04
To: java400-l@midrange.com
Subject: Re: As400 reading/writing excel files.


Till that comes out, Tidestone/Actuate's FormulaOne.
http://www.actuate.com
Pricey.

----- Original Message -----
From: "Hatzenbeler, Tim" <thatzenbeler@clinitech.net>
To: <java400-l@midrange.com>
Sent: Wednesday, January 02, 2002 7:02 PM
Subject: As400 reading/writing excel files.


> 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 ]
> For those who may need this type of function (like myself), I have been
> following a project called POI @ www.sourceforge.com  its a Java2 program
> that can read & write native excel spread sheets in 100% java2....
>
> I have not tried it on our as/400 yet (were still using Java 1.1)  but the
> developers seem very interested in making it a solid product, so I thought
> the more users that use it, the better the program might be, also it's
open
> source....
>
> Tim.
> _______________________________________________
> 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 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.


The information in this e-mail and any attachments
(the 'e-mail') is confidential and intended solely for
the addressee(s) named above.  This e-mail may be
subject to legal professional or other privilege or legal
rules.  The unauthorised use, disclosure or copying
of the e-mail is prohibited.  If you are not the intended
recipient, or a person responsible for delivering the
e-mail to the intended recipient you must not disclose,
copy, distribute or retain this e-mail or any part of it.
This e-mail does not, directly or indirectly, represent
financial advice.
_______________________________________________
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.