Thanks, Levi. After I sent the original message, I realized that BlankRecord probably wouldn't help, because it is set in a cell, and in my case, I don't have a cell (getCell() returns null).
I am on the trail of using ColumnInfoRecord, ColumnInfoRecordsAggregate, RowRecord, and others that contain an index to an ExtendedFormatRecord, which seems to compose the essential ingredient of HSSFCellStyle. Finding and accessing these objects is going to be a fair amount of work, however. Has anyone followed this trail before? --Michael -----Original Message----- From: Levi Strope [mailto:[EMAIL PROTECTED] Sent: Friday, April 27, 2007 11:44 AM To: POI Users List Subject: RE: how to find style in existing workbook for cell position with no cell I believe it can be mapped to a BlankRecord because the cell itself still contains cell formatting. -----Original Message----- From: Haggerty, Michael [mailto:[EMAIL PROTECTED] Sent: Friday, April 27, 2007 10:28 AM To: [email protected] Subject: how to find style in existing workbook for cell position with no cell When a cell position (some row/column position such as 0,0) in an existing workbook contains a cell, then its style can be found with HSSFCell.getCellStyle(). When a cell position does not contain a cell (HSSFRow.getCell() returns null), how can I find the style that would be applied by Excel when a value is set into that cell position? For example, a column can be formatted to have a specified fill color. When working in Excel manually, a value typed into a cell in that column will retain that fill color. I want to use HSSF to find that column's style, create a new style based on it, and make some changes to it. I cannot simply create a new style, because the default style does not represent the column formatting, and the fill color is lost. This question was asked by [EMAIL PROTECTED] on 22 Feb 2006 in this mailing list, with the subject of "[Q] Excel -> HSFFCell, loosing style" but no response was made. Possible lead: Will the org.apache.poi.hssf.record.BlankRecord class help in this case? An extended format record can be retrieved from this, but how can a cell position be mapped to a BlankRecord? Thank you. --Michael --------------------------------------------------------------------- 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/ --------------------------------------------------------------------- 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/ --------------------------------------------------------------------- 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/
