| Author |
Conditional Formatting in POI
|
Vaman Kulkarni
Greenhorn
Joined: Nov 06, 2009
Posts: 6
|
|
Hi all,
I need to make a column conditional formatted in excel 2007 sheet. I am using POI library for this. But I am unable to find Conditional Formatting APIs in XSSF.
Does anyone have any idea how to accomplish this using POI XSSF APIs?
Thanks in advance,
--Varun
|
 |
Christophe Verré
Sheriff
Joined: Nov 24, 2005
Posts: 14685
|
|
|
It's explained in the org.apache.poi.hssf.usermodel.HSSFConditionalFormatting class.
|
[My Blog]
All roads lead to JavaRanch
|
 |
Vaman Kulkarni
Greenhorn
Joined: Nov 06, 2009
Posts: 6
|
|
Thats true. But I guess it does not work with excel 2007.
HSSF APIs are for 97-2003 format (xls) documents. Again the question remains how to accomplish this in excel 2007 ?
Thanks,
--Varun
|
 |
Christophe Verré
Sheriff
Joined: Nov 24, 2005
Posts: 14685
|
|
|
XSSF ? Sorry, I don't think it's supported yet.
|
 |
 |
|
|
subject: Conditional Formatting in POI
|
|
|