开发者

how to change the tab color of a worksheet with Apache Poi

开发者 https://www.devze.com 2022-12-17 00:55 出处:网络
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.

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

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号