File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Java in General and the fly likes Conditional Formatting in POI Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Java in General
Bookmark "Conditional Formatting in POI" Watch "Conditional Formatting in POI" New topic
Author

Conditional Formatting in POI

Vaman Kulkarni
Greenhorn

Joined: Nov 06, 2009
Posts: 7
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: 14687
    
  16

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: 7
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: 14687
    
  16

XSSF ? Sorry, I don't think it's supported yet.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Conditional Formatting in POI