RE: Using Java in RPGLE - cell comments and document properties

["Bob Cozzi" <cozzi@xxxxxxxxx>]

XML is in the Excel Help text, but if you have a spreadsheet formatted as
you need it, save/export it as XML and then open and read it (you may have
to change the suffix to TXT or something to open it in Notepad). 

-Bob


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Peter Dow
Sent: Monday, December 06, 2004 8:27 AM
To: RPG programming on the AS400 / iSeries
Subject: Re: Using Java in RPGLE - cell comments and document properties

Thanks for the idea Bob, but for now Java is ok.  But out of curiousity, how
would I get from XML or HTML to the .XLS file the customer is requesting?

Peter Dow
Dow Software Services, Inc.
909 793-9050 voice
909 793-4480 fax
951 522-3214 cell


----- Original Message ----- 
From: "Bob Cozzi" <cozzi@xxxxxxxxx>
To: "'RPG programming on the AS400 / iSeries'" <rpg400-l@xxxxxxxxxxxx>
Sent: Tuesday, December 07, 2004 6:12 AM
Subject: RE: Using Java in RPGLE - cell comments and document properties


> I think you're better off using XML or even HTML and embedding the
formulas
> in those file formats rather than screwing around with the actual Excel
file
> format itself. I'm sure POI is the best choice for now, however it does
> require the use of JAVA within RPG IV and you many not want to do that.
>
>
> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
> On Behalf Of Peter Dow
> Sent: Monday, December 06, 2004 3:29 AM
> To: RPG programming on the AS400 / iSeries
> Subject: Using Java in RPGLE - cell comments and document properties
>
> One more thing I'm looking for when creating an Excel spreadsheet from
RPGLE
> is the ability to create cell comments and document properties such as
> Title, Subject, Author, etc.  My customer would like to indicate that the
> spreadsheet was created on the AS/400 by the AS/400.  Yes, AS/400 -- their
> users don't have a clue about iSeries.
>
> I did not see anything on the Jakarta POI/HSSF (what do those stand for
> anyway, POI and HSSF?) website, but I followed this link
> http://sc.openoffice.org/excelfileformat.pdf and did a little reading.
> There wasn't anything specific, but there is a "NOTE" record in there that
> might be it.  Am I missing something again?  Or is this just not
implemented
> yet?
>
> Peter Dow
> Dow Software Services, Inc.
> 909 793-9050 voice
> 909 793-4480 fax
> 951 522-3214 cell
>
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.802 / Virus Database: 545 - Release Date: 12/3/2004
>
>
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
>
>
>
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
>


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.802 / Virus Database: 545 - Release Date: 12/3/2004


--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.