private static void getCssByStyle(XSSFCell cell, XSSFCellStyle s, XSSFWorkbook workbook) {
String uuid = UUID.randomUUID().toString();
String[] css = new String[2];
css[0] = "c" + uuid;
StringBuffer cssinfo = new StringBuffer();
// 文字对齐方式
switch (s.getAlignment()) {
case XSSFCellStyle.ALIGN_CENTER:
cssinfo.append("text-align:center;");
break;
case XSSFCellStyle.ALIGN_LEFT:
cssinfo.append("text-align:left;");
break;
case XSSFCellStyle.ALIGN_RIGHT:
cssinfo.append("text-align:right;");
break;
}
// 背景色
cssinfo.append("background-color:" + getXSSFColor(cell, "background", s.getFillForegroundXSSFColor()) + ";");
// 设置边框
cssinfo.append("border-top:" + s.getBorderTop() + "px solid "
+ getXSSFColor(cell, "border", s.getTopBorderXSSFColor()) + ";");
cssinfo.append("border-left:" + s.getBorderLeft() + "px solid "
+ getXSSFColor(cell, "border", s.getLeftBorderXSSFColor()) + ";");
cssinfo.append("border-right:" + s.getBorderRight() + "px solid "
+ getXSSFColor(cell, "border", s.getRightBorderXSSFColor()) + ";");
cssinfo.append("border-bottom:" + s.getBorderBottom() + "px solid "
+ getXSSFColor(cell, "border", s.getBottomBorderXSSFColor()) + ";");
// 设置缩进
cssinfo.append("text-indent:" + s.getIndention() + "em;");
// 设置字体
XSSFFont font = workbook.getFontAt(s.getFontIndex());
cssinfo.append("font-size:" + font.getFontHeightInPoints() + "pt;");
if (XSSFFont.BOLDWEIGHT_BOLD == font.getBoldweight()) {
cssinfo.append("font-weight: bold;");
}
cssinfo.append("font-family: " + font.getFontName() + ";");
if (font.getItalic()) {
cssinfo.append("font-style: italic;");
}
String fontcolor = getXSSFColor(cell, "font", font.getXSSFColor());
if (fontcolor.trim().length() > 0) {
cssinfo.append("color: " + fontcolor + ";");
}
css[1] = "." + css[0] + "{" + cssinfo.toString() + "}";
System.out.println(css[1]);
}
Excel转Html(三)-POI解析Excel-css转Html-css-class
最新推荐文章于 2021-12-23 15:05:11 发布