Hi Andy, Btw, thanks for all the work you and the other people have done on this project! It's a lot of fun using it.
My intent was to read (only) the ColumnInfoRecords and save the HSSFCellStyle objects for each column when I initially open the worksheet. Later I'd use that information to apply the cell style to a newly created HSSFCell object. I assumed I'd need the number of ColumnInfo records, but it looks like with the eventmodel I just register a listener for the ColumnInfo record only (recordsid = 0x7d, right?) and let the event factory call me whenever it reads a ColumnInfo record in the stream. You are correct that RPG has no concept of objects, but I am able to perform methods in Java classes and receive values from them; what I'm not certain of is registering a listener. You're probably right in saying that I'll have to have some Java wrapper that acts as the listener and somehow gets the data back to my RPG program. This has me curious though -- how does Excel do this? When an empty worksheet has column formatting applied to it, and I put a value in a cell in one of those columns, the formatting is applied. Is Excel doing something similar do you suppose? It would be nice if the createCell method did this for me. Peter Dow Dow Software Services, Inc. www.dowsoftware.com 909 793-9050 voice 909 793-4480 fax -----Original Message----- From: Andrew C. Oliver [mailto:[EMAIL PROTECTED] 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. -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.9.2/52 - Release Date: 7/19/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/
