poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nick Burch <n...@torchbox.com>
Subject Re: Conditional Formatting
Date Tue, 22 Jan 2008 10:46:35 GMT
On Tue, 22 Jan 2008, rosa-leah.vogt@ph.michelin.com wrote:
> Hello, is it possible to make Conditional Formatting (example, if the 
> value in a cell is >90 the font color should be changed to red) in Excel 
> files using Apache POI? Thanks!

Not sure quite what you're after. Couldn't you just walk through all the 
cells until you find one that matches your rules (eg >90), then just set 
the cell formatting to be red?

sheet.rowIterator and row.cellIterator will let you easily walk through 
all the cells

Nick

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


Mime
View raw message