JAVA-读取excel转成html 将excel表格转换为HTML文件格式 转成前端表格样式

太过爱你忘了你带给我的痛 2024-03-31 14:59 179阅读 0赞

文章目录

    • 1、调用函数
    • 2、excel转html工具类
    • 3、html样式解析
        • 3.1 加载图片-URL链接
        • 3.2 设置图片大小
        • 3.3 设置标题-底色&加粗
        • 3.4 圆点样式
        • 3.5 url链接显示为设置内容
        • 3.6 表格 — 一行三列
        • 3.6 表格 — 两行三列
        • 3.7 段落
    • 4、时间工具类

博客背景：JAVA项目，将Excel转换为HTML的便捷工具类。可快速上手使用~

1、调用函数

excelPositon为存放excel的位置；htmlPositon为将要存放html的位置。
可以直接设置位置为磁盘中指定位置；如下默认为项目运行的上一级目录

  1. public void excel2Html() {
  3.         String excelPositon = "../test.xlsx";
  4.         String htmlPositon =  "../test.html";
  5.         //excel转html；src为excel位置，htmlPositon为存放html文件位置
  6.         Excel2HtmlUtil.readExcelToHtml(excelPositon, htmlPositon, true, "xlsx", "test");
  7.     }

2、excel转html工具类

创建相应工具类Excel2HtmlUtil
改编了一些表头、第一列的样式；还有链接时的样式。如无需可以在对应位置去掉即可~
调用函数readExcelToHtml()可直接使用转换~

  1. //excel转html工具类
  2. package com.xx.util;
  4. import org.apache.commons.io.FileUtils;
  5. import org.apache.poi.hssf.usermodel.*;
  6. import org.apache.poi.hssf.util.HSSFColor;
  7. import org.apache.poi.ss.usermodel.*;
  8. import org.apache.poi.ss.util.CellRangeAddress;
  9. import org.apache.poi.xssf.usermodel.XSSFCellStyle;
  10. import org.apache.poi.xssf.usermodel.XSSFColor;
  11. import org.apache.poi.xssf.usermodel.XSSFFont;
  12. import org.apache.poi.xssf.usermodel.XSSFWorkbook;
  14. import java.io.*;
  15. import java.text.DecimalFormat;
  16. import java.text.SimpleDateFormat;
  17. import java.util.*;
  18. import java.util.regex.Matcher;
  19. import java.util.regex.Pattern;
  22. public class Excel2HtmlUtil {
  24.     /**
  25.      *
  26.      * @param filePath    excel源文件文件的路径
  27.      * @param htmlPositon 生成的html文件的路径
  28.      * @param isWithStyle 是否需要表格样式 包含 字体 颜色 边框 对齐方式
  29.      * @throws Exception
  30.      *
  31.      */
  32.     public static String readExcelToHtml(String filePath, String htmlPositon, boolean isWithStyle,String type,String attname) throws Exception {
  34.         InputStream is = null;
  35.         String htmlExcel = null;
  36.         Map<String,String> stylemap = new HashMap<String,String>();
  37.         try {
  39.             if("csv".equalsIgnoreCase(type)) {
  41.                 htmlExcel = getCSVInfo(filePath,htmlPositon);
  42.                 writeFile1(htmlExcel, htmlPositon,stylemap,attname);
  43.             }else {
  45.                 File sourcefile = new File(filePath);
  46.                 is = new FileInputStream(sourcefile);
  47.                 Workbook wb = WorkbookFactory.create(is);
  48.                 if (wb instanceof XSSFWorkbook) {
  49.      // 03版excel处理方法
  50.                     XSSFWorkbook xWb = (XSSFWorkbook) wb;
  51.                     htmlExcel = getExcelInfo(xWb, isWithStyle,stylemap);
  52.                 } else if (wb instanceof HSSFWorkbook) {
  53.      // 07及10版以后的excel处理方法
  54.                     HSSFWorkbook hWb = (HSSFWorkbook) wb;
  55.                     htmlExcel = getExcelInfo(hWb, isWithStyle,stylemap);
  56.                 }
  57.                 writeFile(htmlExcel, htmlPositon,stylemap,attname);
  58.             }
  59.         } catch (Exception e) {
  61.             System.out.println("文件被损坏或不能打开，无法预览");
  62.             //throw new Exception("文件被损坏或不能打开，无法预览");
  63.         } finally {
  65.             try {
  67.                 if(is!=null){
  69.                     is.close();
  70.                 }
  71.             } catch (IOException e) {
  73.                 e.printStackTrace();
  74.             }
  75.         }
  76.         return htmlPositon;
  77.     }
  79.     private static void getcscvvalue(BufferedReader reader,List col,String oldvalue,List list) {
  81.         String line = null;
  82.         try {
  84.             while((line=reader.readLine())!=null){
  86.                 String[] item = line.split(",",-1);
  87.                 boolean isbreak = false;
  88.                 for(int i=0;i<item.length;i++) {
  90.                     String value = item[i];
  91.                     if(value.endsWith("\"")) {
  93.                         value = oldvalue+value;
  94.                         col.add(value);
  95.                     }else if(item.length==1) {
  97.                         value = oldvalue+value;
  98.                         getcscvvalue(reader,col,value,list);
  99.                         isbreak = true;
  100.                     }else if(value.startsWith("\"")){
  102.                         getcscvvalue(reader,col,value,list);
  103.                         isbreak = true;
  104.                     }else {
  106.                         col.add(value);
  107.                     }
  108.                 }
  109.                 if(!isbreak) {
  111.                     list.add(col);
  112.                     col = new ArrayList();
  113.                 }
  114.             }
  115.         } catch (IOException e) {
  117.         }
  118.     }
  120.     private static String getCSVInfo(String filePath,String htmlPositon) {
  122.         StringBuffer sb = new StringBuffer();
  123.         DataInputStream in = null;
  124.         try {
  126.             in=new DataInputStream(new FileInputStream(filePath));
  127.             BufferedReader reader=new BufferedReader(new InputStreamReader(in));
  128.             //reader.readLine();
  129.             String line = null;
  130.             List list = new ArrayList();
  131.             while((line=reader.readLine())!=null){
  133.                 String[] item = line.split(",");
  134.                 List col = new ArrayList();
  135.                 for(int i=0;i<item.length;i++) {
  137.                     String value = item[i];
  138.                     if(value.startsWith("\"")) {
  140.                         getcscvvalue(reader,col,value,list);
  141.                     }else {
  143.                         col.add(value);
  144.                     }
  145.                 }
  146.                 list.add(col);
  147.             }
  148.             sb.append("<table>");
  149.             for(int i=0;i<list.size();i++) {
  151.                 List col = (List) list.get(i);
  152.                 if(col==null||col.size()==0) {
  154.                     sb.append("<tr><td ></td></tr>");
  155.                 }
  156.                 sb.append("<tr>");
  157.                 for(int j=0;j<col.size();j++) {
  159.                     String value = (String) col.get(j);
  160.                     if (value == null||"".equals(value)) {
  162.                         sb.append("<td> </td>");
  163.                         continue;
  164.                     }else {
  166.                         sb.append("<td>"+value+"</td>");
  167.                     }
  168.                 }
  169.                 sb.append("</tr>");
  170.             }
  171.             sb.append("</table>");
  172.         } catch (IOException e) {
  174.             // TODO Auto-generated catch block
  175.             e.printStackTrace();
  176.         } finally {
  178.             try {
  180.                 in.close();
  181.             } catch (IOException e) {
  183.                 e.printStackTrace();
  184.             }
  185.         }
  186.         return sb.toString();
  187.     }
  189.     //读取excel文件，返回转换后的html字符串
  190.     private static String getExcelInfo(Workbook wb, boolean isWithStyle, Map<String,String> stylemap) {
  192.         StringBuffer sb = new StringBuffer();
  193.         StringBuffer ulsb = new StringBuffer();
  194.         ulsb.append("<ul>");
  195.         int num = wb.getNumberOfSheets();
  196.         //遍历excel文件里的每一个sheet
  197.         for(int i=0;i<num;i++) {
  199.             Sheet sheet = wb.getSheetAt(i);// 获取第i个Sheet的内容
  200.             String sheetName = sheet.getSheetName();
  201.             if(i==0) {
  203.                 //ulsb.append("<li id='li_"+i+"' class='cur' οnclick='changetab("+i+")'>"+sheetName+"</li>");
  204.                 ulsb.append("<h3 style=\"background-color:LightSkyBlue ;\">" + sheetName + "</h3>");
  205.             }else {
  207.                 //sheet名字 加上了蓝色底色
  208.                 //ulsb.append("<li id='li_"+i+"' οnclick='changetab("+i+")'>"+sheetName+"</li>");
  209.                 ulsb.append("<h3 style=\"background-color:LightSkyBlue ;\">" + sheetName + "</h3>");
  210.             }
  211.             int lastRowNum = sheet.getLastRowNum();
  212.             Map<String, String> map[] = getRowSpanColSpanMap(sheet);
  213.             Map<String, String> map1[] = getRowSpanColSpanMap(sheet);
  214.             sb.append("<table id='table_"+i+"' ");
  215.             if(i==0) {
  217.                 sb.append("class='block'");
  218.             }
  219.             sb.append(">");
  220.             Row row = null; // 兼容
  221.             Cell cell = null; // 兼容
  223.             int maxRowNum = 0;
  224.             int maxColNum = 0;
  225.             //遍历每一行
  226.             for (int rowNum = sheet.getFirstRowNum(); rowNum <= lastRowNum; rowNum++) {
  228.                 row = sheet.getRow(rowNum);
  229.                 if (row == null) {
  231.                     continue;
  232.                 }
  233.                 int lastColNum = row.getLastCellNum();
  234.                 for (int colNum = 0; colNum < lastColNum; colNum++) {
  236.                     cell = row.getCell(colNum);
  237.                     if (cell == null) {
  238.      // 特殊情况 空白的单元格会返回null
  239.                         continue;
  240.                     }
  241.                     String stringValue = getCellValue1(cell);
  242.                     if (map1[0].containsKey(rowNum + "," + colNum)) {
  244.                         map1[0].remove(rowNum + "," + colNum);
  245.                         if(maxRowNum<rowNum) {
  247.                             maxRowNum = rowNum;
  248.                         }
  249.                         if(maxColNum<colNum) {
  251.                             maxColNum = colNum;
  252.                         }
  253.                     } else if (map1[1].containsKey(rowNum + "," + colNum)) {
  255.                         map1[1].remove(rowNum + "," + colNum);
  256.                         if(maxRowNum<rowNum) {
  258.                             maxRowNum = rowNum;
  259.                         }
  260.                         if(maxColNum<colNum) {
  262.                             maxColNum = colNum;
  263.                         }
  264.                         continue;
  265.                     }
  266.                     if (stringValue == null || "".equals(stringValue.trim())) {
  268.                         continue;
  269.                     }else {
  271.                         if(maxRowNum<rowNum) {
  273.                             maxRowNum = rowNum;
  274.                         }
  275.                         if(maxColNum<colNum) {
  277.                             maxColNum = colNum;
  278.                         }
  279.                     }
  280.                 }
  281.             }
  282.             for (int rowNum = sheet.getFirstRowNum(); rowNum <= maxRowNum; rowNum++) {
  284.                 row = sheet.getRow(rowNum);
  285.                 if (row == null) {
  287.                     sb.append("<tr><td ></td></tr>");
  288.                     continue;
  289.                 }
  290.                 sb.append("<tr>");
  291.                 int lastColNum = row.getLastCellNum();
  292.                 for (int colNum = 0; colNum <= maxColNum; colNum++) {
  294.                     cell = row.getCell(colNum);
  295.                     if (cell == null) {
  296.      // 特殊情况 空白的单元格会返回null
  297.                         sb.append("<td> </td>");
  298.                         continue;
  299.                     }
  300.                     String stringValue = getCellValue(cell);
  301.                     if (stringValue.equals("")) {
  302.      // 空字符串返空
  303.                         sb.append(stringValue.replace(String.valueOf((char) 160), " "));
  304.                     }
  305.                     String pattrenStr = "[a-zA-z]+://[^\\s]*";
  306.                     Pattern pattern = Pattern.compile(pattrenStr);
  307.                     Matcher matcher = pattern.matcher(stringValue);
  308.                     if (map[0].containsKey(rowNum + "," + colNum)) {
  310.                         String pointString = map[0].get(rowNum + "," + colNum);
  311.                         map[0].remove(rowNum + "," + colNum);
  312.                         int bottomeRow = Integer.valueOf(pointString.split(",")[0]);
  313.                         int bottomeCol = Integer.valueOf(pointString.split(",")[1]);
  314.                         int rowSpan = bottomeRow - rowNum + 1;
  315.                         int colSpan = bottomeCol - colNum + 1;
  316.                         if(rowNum == 0){
  318.                             sb.append("<td style=\"background-color:WhiteSmoke;font-weight:bold;\",rowspan= '" + rowSpan + "' colspan= '" + colSpan + "' ");
  319.                         }else{
  321.                             sb.append("<td rowspan= '" + rowSpan + "' colspan= '" + colSpan + "' ");
  322.                         }
  323.                     } else if (map[1].containsKey(rowNum + "," + colNum)) {
  325.                         map[1].remove(rowNum + "," + colNum);
  326.                         continue;
  327.                     } else {
  329.                         if(rowNum == 0 || colNum == 0){
  331.                             //列表头加粗&底色
  332.                             sb.append("<td style=\"background-color:WhiteSmoke;font-weight:bold;\"");
  333.                         }else{
  335.                             sb.append("<td ");
  336.                         }
  337.                     }
  338.                     if (isWithStyle) {
  340.                         dealExcelStyle(wb, sheet, cell, sb,stylemap);// 处理单元格样式
  341.                     }
  344.                     sb.append("><nobr>");
  345.                     //如果单元格为空要判断该单元格是不是通过其他单元格计算得到的
  346.                     if (stringValue == null) {
  348. //                    if (stringValue == null || "".equals(stringValue.trim())) {
  350.                         FormulaEvaluator evaluator = wb.getCreationHelper().createFormulaEvaluator();
  351.                         if (evaluator.evaluate(cell) != null) {
  353.                             //如果单元格的值是通过其他单元格计算来的，则通过单元格计算获取
  354.                             String cellnumber = evaluator.evaluate(cell).getNumberValue() + "";
  355.                             //如果单元格的值是小数，保留两位
  356.                             if (null != cellnumber && cellnumber.contains(".")) {
  358.                                 String[] decimal = cellnumber.split("\\.");
  359.                                 if (decimal[1].length() > 2) {
  361.                                     int num1 = decimal[1].charAt(0) - '0';
  362.                                     int num2 = decimal[1].charAt(1) - '0';
  363.                                     int num3 = decimal[1].charAt(2) - '0';
  364.                                     if (num3 == 9) {
  366.                                         num2 = 0;
  367.                                     } else if (num3 >= 5) {
  369.                                         num2 = num2 + 1;
  370.                                     }
  371.                                     cellnumber = decimal[0] + "." + num1 + num2;
  372.                                 }
  373.                             }
  374.                             stringValue = cellnumber;
  375.                         }
  376.                         sb.append(stringValue.replace(String.valueOf((char) 160), " "));
  377.                     } else {
  379.                         //如果是链接则使用该语句
  380.                         if(matcher.matches()){
  382.                             sb.append("<a href=\""+ stringValue + "\">点击查看内容</a>");
  383.                         }else{
  385.                             // 将ascii码为160的空格转换为html下的空格（ ）
  386.                             sb.append(stringValue.replace(String.valueOf((char) 160), " "));
  387.                         }
  388.                     }
  389.                     sb.append("</nobr></td>");
  390.                 }
  391.                 sb.append("</tr>");
  392.             }
  393.             sb.append("</table>");
  394.         }
  395.         ulsb.append("</ul>");
  396.         return ulsb.toString()+sb.toString();
  397.     }
  400.     private static Map<String, String>[] getRowSpanColSpanMap(Sheet sheet) {
  402.         Map<String, String> map0 = new HashMap<String, String>();
  403.         Map<String, String> map1 = new HashMap<String, String>();
  404.         int mergedNum = sheet.getNumMergedRegions();
  405.         CellRangeAddress range = null;
  406.         for (int i = 0; i < mergedNum; i++) {
  408.             range = sheet.getMergedRegion(i);
  409.             int topRow = range.getFirstRow();
  410.             int topCol = range.getFirstColumn();
  411.             int bottomRow = range.getLastRow();
  412.             int bottomCol = range.getLastColumn();
  413.             map0.put(topRow + "," + topCol, bottomRow + "," + bottomCol);
  414.             // System.out.println(topRow + "," + topCol + "," + bottomRow + "," +
  415.             // bottomCol);
  416.             int tempRow = topRow;
  417.             while (tempRow <= bottomRow) {
  419.                 int tempCol = topCol;
  420.                 while (tempCol <= bottomCol) {
  422.                     map1.put(tempRow + "," + tempCol, "");
  423.                     tempCol++;
  424.                 }
  425.                 tempRow++;
  426.             }
  427.             map1.remove(topRow + "," + topCol);
  428.         }
  429.         Map[] map = {
  430.      map0, map1 };
  431.         return map;
  432.     }
  434.     private static String getCellValue1(Cell cell) {
  436.         String result = new String();
  437.         switch (cell.getCellType()) {
  439.             case NUMERIC:// 数字类型
  440.                 result = "1";
  441.                 break;
  442.             case STRING:// String类型
  443.                 result = "1";
  444.                 break;
  445.             case BLANK:
  446.                 result = "";
  447.                 break;
  448.             default:
  449.                 result = "";
  450.                 break;
  451.         }
  452.         return result;
  453.     }
  455.     /**
  456.      * 获取表格单元格Cell内容
  457.      *
  458.      * @param cell
  459.      * @return
  460.      */
  461.     private static String getCellValue(Cell cell) {
  463.         String result = new String();
  464.         switch (cell.getCellType()) {
  466.             case NUMERIC:// 数字类型
  467.                 if (DateUtil.isCellDateFormatted(cell)) {
  468.     // 处理日期格式、时间格式
  469.                     SimpleDateFormat sdf = null;
  470.                     if (cell.getCellStyle().getDataFormat() == HSSFDataFormat.getBuiltinFormat("h:mm")) {
  472.                         sdf = new SimpleDateFormat("HH:mm");
  473.                     } else {
  474.     // 日期
  475.                         sdf = new SimpleDateFormat("yyyy-MM-dd");
  476.                     }
  477.                     Date date = cell.getDateCellValue();
  478.                     result = sdf.format(date);
  479.                 } else if (cell.getCellStyle().getDataFormat() == 58) {
  481.                     // 处理自定义日期格式：m月d日(通过判断单元格的格式id解决，id的值是58)
  482.                     SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
  483.                     double value = cell.getNumericCellValue();
  484.                     Date date = org.apache.poi.ss.usermodel.DateUtil.getJavaDate(value);
  485.                     result = sdf.format(date);
  486.                 } else {
  488.                     double value = cell.getNumericCellValue();
  489.                     CellStyle style = cell.getCellStyle();
  490.                     DecimalFormat format = new DecimalFormat();
  491.                     String temp = style.getDataFormatString();
  492.                     // 单元格设置成常规
  493.                     if (temp.equals("General")) {
  495.                         format.applyPattern("#");
  496.                     }
  497.                     result = format.format(value);
  498.                 }
  499.                 break;
  500.             case STRING:// String类型
  501.                 result = cell.getRichStringCellValue().toString();
  502.                 break;
  503.             case BLANK:
  504.                 result = "";
  505.                 break;
  506.             default:
  507.                 result = "";
  508.                 break;
  509.         }
  510.         return result;
  511.     }
  513.     /**
  514.      * 处理表格样式
  515.      *
  516.      * @param wb
  517.      * @param sheet
  518.      * @param sb
  519.      */
  520.     private static void dealExcelStyle(Workbook wb, Sheet sheet, Cell cell, StringBuffer sb,Map<String,String> stylemap) {
  522.         CellStyle cellStyle = cell.getCellStyle();
  523.         if (cellStyle != null) {
  525.             HorizontalAlignment alignment = cellStyle.getAlignment();
  526.             // sb.append("align='" + convertAlignToHtml(alignment) + "' ");//单元格内容的水平对齐方式
  527.             VerticalAlignment verticalAlignment = cellStyle.getVerticalAlignment();
  528.             String _style = "vertical-align:"+convertVerticalAlignToHtml(verticalAlignment)+";";
  529.             if (wb instanceof XSSFWorkbook) {
  531.                 XSSFFont xf = ((XSSFCellStyle) cellStyle).getFont();
  532.                 //short boldWeight = xf.getBoldweight();
  533.                 short boldWeight = 400;
  534.                 String align = convertAlignToHtml(alignment);
  535.                 int columnWidth = sheet.getColumnWidth(cell.getColumnIndex());
  536.                 _style +="font-weight:" + boldWeight + ";font-size: " + xf.getFontHeight() / 2 + "%;width:" + columnWidth + "px;text-align:" + align + ";";
  538.                 XSSFColor xc = xf.getXSSFColor();
  539.                 if (xc != null && !"".equals(xc)) {
  541.                     _style +="color:#" + xc.getARGBHex().substring(2) + ";";
  542.                 }
  544.                 XSSFColor bgColor = (XSSFColor) cellStyle.getFillForegroundColorColor();
  545.                 if (bgColor != null && !"".equals(bgColor)) {
  547.                     _style +="background-color:#" + bgColor.getARGBHex().substring(2) + ";"; // 背景颜色
  548.                 }
  549.                 _style +=getBorderStyle(0, cellStyle.getBorderTop().getCode(),((XSSFCellStyle) cellStyle).getTopBorderXSSFColor());
  550.                 _style +=getBorderStyle(1, cellStyle.getBorderRight().getCode(),((XSSFCellStyle) cellStyle).getRightBorderXSSFColor());
  551.                 _style +=getBorderStyle(2, cellStyle.getBorderBottom().getCode(),((XSSFCellStyle) cellStyle).getBottomBorderXSSFColor());
  552.                 _style +=getBorderStyle(3, cellStyle.getBorderLeft().getCode(),((XSSFCellStyle) cellStyle).getLeftBorderXSSFColor());
  553.             } else if (wb instanceof HSSFWorkbook) {
  555.                 HSSFFont hf = ((HSSFCellStyle) cellStyle).getFont(wb);
  556.                 short boldWeight = hf.getFontHeight();
  557.                 short fontColor = hf.getColor();
  558.                 HSSFPalette palette = ((HSSFWorkbook) wb).getCustomPalette(); // 类HSSFPalette用于求的颜色的国际标准形式
  559.                 HSSFColor hc = palette.getColor(fontColor);
  560.                 String align = convertAlignToHtml(alignment);
  561.                 int columnWidth = sheet.getColumnWidth(cell.getColumnIndex());
  562.                 _style +="font-weight:" + boldWeight + ";font-size: " + hf.getFontHeight() / 2 + "%;text-align:" + align + ";width:" + columnWidth + "px;";
  563.                 String fontColorStr = convertToStardColor(hc);
  564.                 if (fontColorStr != null && !"".equals(fontColorStr.trim())) {
  566.                     _style +="color:" + fontColorStr + ";"; // 字体颜色
  567.                 }
  568.                 short bgColor = cellStyle.getFillForegroundColor();
  569.                 hc = palette.getColor(bgColor);
  570.                 String bgColorStr = convertToStardColor(hc);
  571.                 if (bgColorStr != null && !"".equals(bgColorStr.trim())) {
  573.                     _style +="background-color:" + bgColorStr + ";"; // 背景颜色
  574.                 }
  575.                 _style +=getBorderStyle(palette, 0, cellStyle.getBorderTop().getCode(), cellStyle.getTopBorderColor());
  576.                 _style +=getBorderStyle(palette, 1, cellStyle.getBorderRight().getCode(), cellStyle.getRightBorderColor());
  577.                 _style +=getBorderStyle(palette, 3, cellStyle.getBorderLeft().getCode(), cellStyle.getLeftBorderColor());
  578.                 _style +=getBorderStyle(palette, 2, cellStyle.getBorderBottom().getCode(), cellStyle.getBottomBorderColor());
  579.             }
  580.             String calssname="";
  581.             if(!stylemap.containsKey(_style)) {
  583.                 int count = stylemap.size();
  584.                 calssname = "td"+count;
  585.                 stylemap.put(_style, calssname);
  586.             }else {
  588.                 calssname = stylemap.get(_style);
  589.             }
  590.             if(!"".equals(calssname)) {
  592.                 sb.append("class='"+calssname+"'");
  593.             }
  594.         }
  595.     }
  597.     /**
  598.      * 单元格内容的水平对齐方式
  599.      *
  600.      * @param alignment
  601.      * @return
  602.      */
  603.     private static String convertAlignToHtml(HorizontalAlignment alignment) {
  605.         String align = "center";
  606.         switch (alignment) {
  608.             case LEFT:
  609.                 align = "left";
  610.                 break;
  611.             case CENTER:
  612.                 align = "center";
  613.                 break;
  614.             case RIGHT:
  615.                 align = "right";
  616.                 break;
  617.             default:
  618.                 break;
  619.         }
  620.         return align;
  621.     }
  623.     /**
  624.      * 单元格中内容的垂直排列方式
  625.      *
  626.      * @param verticalAlignment
  627.      * @return
  628.      */
  629.     private static String convertVerticalAlignToHtml(VerticalAlignment verticalAlignment) {
  632.         String valign = "middle";
  633.         switch (verticalAlignment) {
  635.             case BOTTOM:
  636.                 valign = "bottom";
  637.                 break;
  638.             case CENTER:
  639.                 valign = "middle";
  640.                 break;
  641.             case TOP:
  642.                 valign = "top";
  643.                 break;
  644.             default:
  645.                 break;
  646.         }
  647.         return valign;
  648.     }
  650.     private static String convertToStardColor(HSSFColor hc) {
  652.         StringBuffer sb = new StringBuffer("");
  653.         if (hc != null) {
  655.             if (HSSFColor.HSSFColorPredefined.AUTOMATIC.getIndex() == hc.getIndex()) {
  657.                 return null;
  658.             }
  659.             sb.append("#");
  660.             for (int i = 0; i < hc.getTriplet().length; i++) {
  662.                 sb.append(fillWithZero(Integer.toHexString(hc.getTriplet()[i])));
  663.             }
  664.         }
  665.         return sb.toString();
  666.     }
  668.     private static String fillWithZero(String str) {
  670.         if (str != null && str.length() < 2) {
  672.             return "0" + str;
  673.         }
  674.         return str;
  675.     }
  677.     static String[] bordesr = {
  678.      "border-top:", "border-right:", "border-bottom:", "border-left:" };
  679.     static String[] borderStyles = {
  680.      "solid ", "solid ", "solid ", "solid ", "solid ", "solid ", "solid ", "solid ",
  681.             "solid ", "solid", "solid", "solid", "solid", "solid" };
  683.     private static String getBorderStyle(HSSFPalette palette, int b, short s, short t) {
  685.         if (s == 0)
  686.             return bordesr[b] + borderStyles[s] + "#d0d7e5 1px;";
  687.         String borderColorStr = convertToStardColor(palette.getColor(t));
  688.         borderColorStr = borderColorStr == null || borderColorStr.length() < 1 ? "#000000" : borderColorStr;
  689.         return bordesr[b] + borderStyles[s] + borderColorStr + " 1px;";
  690.     }
  692.     private static String getBorderStyle(int b, short s, XSSFColor xc) {
  694.         if (s == 0)
  695.             return bordesr[b] + borderStyles[s] + "#d0d7e5 1px;";
  696.         if (xc != null && !"".equals(xc)) {
  698.             String borderColorStr = xc.getARGBHex();// t.getARGBHex();
  699.             borderColorStr = borderColorStr == null || borderColorStr.length() < 1 ? "#000000"
  700.                     : borderColorStr.substring(2);
  701.             return bordesr[b] + borderStyles[s] + borderColorStr + " 1px;";
  702.         }
  703.         return "";
  704.     }
  706.     /*
  707.      * @param content 生成的excel表格标签
  708.      *
  709.      * @param htmlPath 生成的html文件地址
  710.      */
  711.     private static void writeFile(String content, String htmlPath, Map<String,String> stylemap,String name) {
  713.         File file2 = new File(htmlPath);
  714.         StringBuilder sb = new StringBuilder();
  715.         try {
  717.             file2.createNewFile();// 创建文件
  718.             sb.append("<html><head><meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\"><title>"+name+"</title><style type=\"text/css\">");
  719.             sb.append("ul{list-style: none;max-width: calc(100%);padding: 0px;margin: 0px;overflow-x: scroll;white-space: nowrap;} ul li{padding: 3px 5px;display: inline-block;border-right: 1px solid #768893;} ul li.cur{color: #F59C25;} table{border-collapse:collapse;display:none;width:100%;} table.block{display: block;}");
  720.             for(Map.Entry<String, String> entry : stylemap.entrySet()){
  722.                 String mapKey = entry.getKey();
  723.                 String mapValue = entry.getValue();
  724.                 sb.append(" ."+mapValue+"{"+mapKey+"}");
  725.             }
  726.             sb.append("</style><script>");
  727.             sb.append("function changetab(i){var block = document.getElementsByClassName(\"block\");block[0].className = block[0].className.replace(\"block\",\"\");var cur = document.getElementsByClassName(\"cur\");cur[0].className = cur[0].className.replace(\"cur\",\"\");var curli = document.getElementById(\"li_\"+i);curli.className += ' cur';var curtable = document.getElementById(\"table_\"+i);curtable.className=' block';}");
  728.             sb.append("</script></head><body>");
  729.             sb.append("<div>");
  730.             sb.append(content);
  731.             sb.append("</div>");
  732.             sb.append("</body></html>");
  733.             FileUtils.write(file2, sb.toString(),"UTF-8");
  734.         } catch (IOException e) {
  736.             e.printStackTrace();
  737.         }
  738.     }
  740.     private static void writeFile1(String content, String htmlPath, Map<String,String> stylemap,String name) {
  742.         File file2 = new File(htmlPath);
  743.         StringBuilder sb = new StringBuilder();
  744.         try {
  746.             file2.createNewFile();// 创建文件
  747.             sb.append("<html><head><meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\"><title>"+name+"</title><style type=\"text/css\">");
  748.             sb.append("ul{list-style: none;max-width: calc(100%);padding: 0px;margin: 0px;overflow-x: scroll;white-space: nowrap;} ul li{padding: 3px 5px;display: inline-block;border-right: 1px solid #768893;} ul li.cur{color: #F59C25;} table{border-collapse:collapse;width:100%;} td{border: solid #000000 1px; min-width: 200px;}");
  749.             sb.append("</style></head><body>");
  750.             sb.append("<div>");
  751.             sb.append(content);
  752.             sb.append("</div>");
  753.             sb.append("</body></html>");
  754.             FileUtils.write(file2, sb.toString(),"UTF-8");
  755.         } catch (IOException e) {
  757.             e.printStackTrace();
  758.         }
  759.     }
  761. }

3、html样式解析

3.1 加载图片-URL链接

src设置需要加载的图片地址，alt是未加载到链接内容时展示的提示语

  1. <img src="http://www.baidu.com/images/xx.jpg" alt="暂未加载图像">
3.2 设置图片大小

可以直接按比例设置100%；也可以直接按100px等比例设置

  1. width="图片宽度" height="图片高度"
  2. width=100%
3.3 设置标题-底色&加粗

hX是标题设置；background-color设置底色；font-weight:bold是加粗

  1. <h4 style="background-color:LightSkyBlue;font-weight:bold;">标题</h4>
3.4 圆点样式

设置为带圆点样式的语句

  1. <li id='li_1' οnclick='changetab(1)'>第一张</li>
3.5 url链接显示为设置内容

不直接展示该链接，显示为“点击查看内容”可点击跳转
点击查看内容

3.6 表格 – 一行三列
  1. <table border="1">
  2. <tr>
  3.   <td>100</td>
  4.   <td>200</td>
  5.   <td>300</td>
  6. </tr>
  7. </table>
3.6 表格 – 两行三列
  1. <table border="1">
  2. <tr>
  3.   <td> 1 </td>
  4.   <td> 2 </td>
  5.   <td> 3 </td>
  6. </tr>
  7. <tr>
  8.   <td>400</td>
  9.   <td>500</td>
  10.   <td>600</td>
  11. </tr>
3.7 段落

段落正文中的具体内容

  1. <p>段落段落段落段落段落段落段落</p>

4、时间工具类

专供表格使用相关的时间工具类，解决格式转换的问题。

  1. //DateUtil
  2. public class DateUtil {
  4.     public static boolean isCellDateFormatted(Cell cell)
  5.     {
  7.         if (cell == null) {
  9.             return false;
  10.         }
  11.         boolean bDate = false;
  13.         double d = cell.getNumericCellValue();
  14.         if (isValidExcelDate(d)) {
  16.             CellStyle style = cell.getCellStyle();
  17.             if (style == null) {
  19.                 return false;
  20.             }
  21.             int i = style.getDataFormat();
  22.             String f = style.getDataFormatString();
  23.             bDate = isADateFormat(i, f);
  24.         }
  25.         return bDate;
  26.     }
  28.     public static boolean isADateFormat(int formatIndex, String formatString)
  29.     {
  31.         if (isInternalDateFormat(formatIndex)) {
  33.             return true;
  34.         }
  36.         if ((formatString == null) || (formatString.length() == 0)) {
  38.             return false;
  39.         }
  41.         String fs = formatString;
  42.         //添加以支持汉字格式wingzing
  43.         fs = fs.replaceAll("[\"|\']","").replaceAll("[年|月|日|时|分|秒|毫秒|微秒]", "");
  45.         fs = fs.replaceAll("\\\\-", "-");
  47.         fs = fs.replaceAll("\\\\,", ",");
  49.         fs = fs.replaceAll("\\\\.", ".");
  51.         fs = fs.replaceAll("\\\\ ", " ");
  53.         fs = fs.replaceAll(";@", "");
  55.         fs = fs.replaceAll("^\\[\\$\\-.*?\\]", "");
  57.         fs = fs.replaceAll("^\\[[a-zA-Z]+\\]", "");
  59.         return (fs.matches("^[yYmMdDhHsS\\-/,. :]+[ampAMP/]*$"));
  60.     }
  62.     public static boolean isInternalDateFormat(int format)
  63.     {
  65.         switch (format) {
  66.      case 14:
  67.             case 15:
  68.             case 16:
  69.             case 17:
  70.             case 18:
  71.             case 19:
  72.             case 20:
  73.             case 21:
  74.             case 22:
  75.             case 45:
  76.             case 46:
  77.             case 47:
  78.                 return true;
  79.             case 23:
  80.             case 24:
  81.             case 25:
  82.             case 26:
  83.             case 27:
  84.             case 28:
  85.             case 29:
  86.             case 30:
  87.             case 31:
  88.             case 32:
  89.             case 33:
  90.             case 34:
  91.             case 35:
  92.             case 36:
  93.             case 37:
  94.             case 38:
  95.             case 39:
  96.             case 40:
  97.             case 41:
  98.             case 42:
  99.             case 43:
  100.             case 44: } return false;
  101.     }
  103.     public static boolean isValidExcelDate(double value)
  104.     {
  106.         return (value > -4.940656458412465E-324D);
  107.     }
  108. }

参考：
https://www.runoob.com/html/html-colornames.html
https://www.cnblogs.com/mythz/p/14177739.html
https://blog.csdn.net/qq\_33697094/article/details/122736603

发表评论

表情：
评论列表 （有 0 条评论，179人围观）

还没有评论，来说两句吧...

相关阅读

    相关 将Excel文件转换为Html

    背景 我的工作有时会涉及到财务数据的处理。我们大家都知道，Excel文件在处理数据中很流行并且被广泛使用。Excel让我们可以将存储在里面的数据进行数学计算。我在工作中使

    布满荆棘的人生布满荆棘的人生/ 0 赞/ 151 阅读

    相关 poi将word,excel转成html

    最近在做的项目中客户有要求,希望能够在线预览自己上传的附件,本想使用第三方插件,但是由于一些不可描述的原因,最后只能选择poi,手工实现用户的需求.本人在查了不少网上资料后,最

    梦里梦外;梦里梦外;/ 0 赞/ 583 阅读