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/
