POI/HSSF default cell formatting

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