how to change the tab color of a worksheet with Apache Poi
I am trying to set the background color of a wo开发者_如何转开发rksheet tab using Apache POI. I can't seem to figure out how to set the style on the tabs themselves though.
Thanks for the help!
As commented by Alfabravo... it's possible now to change the XSSFSheet
tab color.
sheet.setTabColor(int colorIndex)
is used for that, and so if we use
sheet.setTabColor(num);
num = 0
: set Black Color in tab.num = 1
: set White Color in tab.num = 2
: set Red Color in tab.num = 3
: set Green Color in tab.num = 4
: set Blue Color in tab.num = 5
: set Yellow Color in tab.
and so on.
As commented by Piotr,
to color tabs in POI 3.11 i had to use:
import org.apache.poi.ss.usermodel.IndexedColors;
sheet.setTabColor(IndexedColors.BLACK.getIndex());
(Note that it is "IndexedColors", not "IndexedColor" like showed by Piotr.)
here is a list showing the colors: http://jlcon.iteye.com/blog/1122538
It would appear that it is not possible. boo. This was the best explanation of why:
http://osdir.com/ml/user-poi.apache.org/2009-03/msg00034.html
精彩评论