You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Jonathan Cowherd <jp...@gmail.com> on 2004/12/18 00:11:55 UTC

Good examples of reading cell color information

I've been searching a bit for examples on reading cell colors in
excel, and I haven't found a way to get data from the "default excel"
palatte and find the cell background from
ExtendedFormatRecord.getFillBackground() (which I've created an array
of the classes from HSSFColor, but it doesn't line up with the short
values).  I've also looked to see if there was a palette record
created in the file, but the eventusermodel doesn't detect one.

Has anyone attempted this or can you point me in a general direction?  

I've tried to do the following with no luck:

HSSFPalette palette = new HSSFPalette(new
PaletteRecord(PaletteRecord.FIRST_COLOR_INDEX));

Thanks,

Jonathan

---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org