Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Conditional Formatting in POI

 
Vaman Kulkarni
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 14691
16
Eclipse IDE Ubuntu VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
It's explained in the org.apache.poi.hssf.usermodel.HSSFConditionalFormatting class.
 
Vaman Kulkarni
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 14691
16
Eclipse IDE Ubuntu VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
XSSF ? Sorry, I don't think it's supported yet.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic