You can't get the ColumnInfoRecordsAggregate. You get the
ColumnInfoRecord. However you shouldn't be programming at this level
generally for non-read only uses. Meaning just use "usermodel" for all
of your read/write apps and only use the event stuff for read only and
don't worry about the record, eventmodel, etc packages (stay usermodel).
I have no knowledge of RPG (came from C and assembler), however its just
a callback w/interface. Not sure how you call to RPG from Java or vice
versa, and I imagine RPG has no concept of "objects" and "interfaces" so
I'd imagine you'd create a small wrapper in Java that called your RPG
program passing the value back.
-Andy
Peter Dow (DSS) wrote:
Hi Everyone,
I'm using the POI/HSSF classes on an IBM iSeries (AS/400) to add/update
cells in a worksheet. The problem I'm having is that the existing worksheet
has column formatting, which I would like to apply to new cells when I add
them (no problems with existing cells - they retain their formatting).
From reading the documentation (keeping in mind I'm an RPG programmer, not
Java), it looks like I need to get the number of ColumnInfo records from the
ColumnInfoRecordsAggregate record, iterate through the ColumnInfoRecords and
set up an array of HSSFCellStyle objects for each column. I can then use
the appropriate array element when adding a new cell. The only problem with
this scenario is that I see no way to get the ColumnInfoRecordsAggregate
unless I use the eventmodel to read all the records, and I'm not sure how to
set up a Java listener in an RPG program.
Any help is appreciated!
Peter Dow
Dow Software Services, Inc.
www.dowsoftware.com
909 793-9050 voice
909 793-4480 fax
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.9.0/50 - Release Date: 7/16/2005
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
--
Andrew C. Oliver
SuperLink Software, Inc.
Java to Excel using POI
http://www.superlinksoftware.com/services/poi
Commercial support including features added/implemented, bugs fixed.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
