java poi excel 单元格样式,如何在Java，Apache POI中获取Excel单元格字段的字体样式？...

I would like to capture the font of a cell field in excel in Java. I am using Apache POI. If possible, I would like to capture font-color, font-family, font-weight, font-size, etc.

How can I achieve this?

解决方案

Edited based on comment

Based on example cell that I've used:

XSSFCellStyle cs = cell.getCellStyle();

XSSFFont font = cs.getFont();

//Getting Font color

XSSFColor color = font.getXSSFColor();

System.out.println("Font color : " + color.getARGBHex());

//==> FF00B0F0

//Getting Font name

System.out.println("Font name : " + font.getFontName());

//==> Arial

//Getting Font family name

FontFamily family = FontFamily.valueOf(((XSSFFont) font).getFamily());

System.out.println("Font family : " + family);

//==> SWISS

//Getting Font family int

System.out.println("Font family in int : " + font.getFamily());

//==> 2

//Getting Font height

System.out.println("Font FontHeight : " + font.getFontHeight());

//==> 280

//Getting Font height in point

System.out.println("Font height in point : " + font.getFontHeightInPoints());

//==> 14

//Getting Font bold weight

System.out.println("Font BoldWeight : " + font.getBoldweight());

//==> 700

本文来自互联网用户投稿，文章观点仅代表作者本人，不代表本站立场，不承担相关法律责任。如若转载，请注明出处。 如若内容造成侵权/违法违规/事实不符，请点击【内容举报】进行投诉反馈！