• 导入的JAR包

    1.  <dependency>
    2.             <groupId>org.apache.poi</groupId>
    3.             <artifactId>poi-scratchpad</artifactId>
    4.             <version>3.14-beta1</version>
    5.         </dependency>
    6.         <dependency>
    7.             <groupId>org.apache.commons</groupId>
    8.             <artifactId>commons-lang3</artifactId>
    9.             <version>3.4</version>
    10.         </dependency>
    11.         <dependency>
    12.             <groupId>org.apache.poi</groupId>
    13.             <artifactId>poi-ooxml</artifactId>
    14.             <version>3.14-beta1</version>
    15.         </dependency>
    16.         <dependency>
    17.             <groupId>org.apache.poi</groupId>
    18.             <artifactId>ooxml-schemas</artifactId>
    19.             <version>1.3</version>
    20.         </dependency>
    21.         <dependency>
    22.             <groupId>org.apache.xmlbeans</groupId>
    23.             <artifactId>xmlbeans</artifactId>
    24.             <version>2.6.0</version>
    25.         </dependency>
    26.         <dependency>
    27.             <groupId>fr.opensagres.xdocreport</groupId>
    28.             <artifactId>xdocreport</artifactId>
    29.             <version>1.0.6</version>
    30.         </dependency>

  • 启动类：

    1. import com.example.demo.util.ExcelToHTML;
    2. import com.example.demo.util.POIWordUtils;
    3. import java.io.FileNotFoundException;
    4. /**
    5.  * 文件预览
    6.  *
    7.  */
    8. public class FilePreviewController {
    9.     public static void main(String[] args) throws FileNotFoundException {
    10.         String fileName = "1102.docx";
    11.         String filePath = "E:\\";
    12.         String newfileName = "1103.html";
    13.         String fileType = fileName.substring(fileName.lastIndexOf("."));
    14.         String name = fileName.substring(0, fileName.lastIndexOf("."));
    15.         //转换 word 文件
    16.         if (fileType != null && (".doc".equals(fileType.toLowerCase()) || ".docx".equals(fileType.toLowerCase() ))){
    17.             POIWordUtils.docConversionToHtml( newfileName, fileName, filePath);
    18.         }
    19.         //转换 excel 文件
    20.         if (fileType!= null && (".xlsx".equals(fileType.toLowerCase()) || ".xls".equals(fileType.toLowerCase() ))){
    21.             ExcelToHTML.readExcelToHtml( filePath+fileName,filePath+newfileName, true);
    22.         }
    23.     }
    24. }

  • word 转换HTML类

    1. package com.example.demo.util;
    3. import org.apache.commons.lang3.StringUtils;
    4. import org.apache.poi.hwpf.HWPFDocument;
    5. import org.apache.poi.hwpf.converter.WordToHtmlConverter;
    6. import org.apache.poi.xwpf.converter.core.BasicURIResolver;
    7. import org.apache.poi.xwpf.converter.core.FileImageExtractor;
    8. import org.apache.poi.xwpf.converter.xhtml.XHTMLConverter;
    9. import org.apache.poi.xwpf.converter.xhtml.XHTMLOptions;
    10. import org.apache.poi.xwpf.usermodel.XWPFDocument;
    11. import org.slf4j.Logger;
    12. import org.slf4j.LoggerFactory;
    13. import org.w3c.dom.Document;
    15. import javax.xml.parsers.DocumentBuilderFactory;
    16. import javax.xml.transform.OutputKeys;
    17. import javax.xml.transform.Transformer;
    18. import javax.xml.transform.TransformerFactory;
    19. import javax.xml.transform.dom.DOMSource;
    20. import javax.xml.transform.stream.StreamResult;
    21. import java.io.*;
    22. import java.util.HashMap;
    23. import java.util.Map;
    24. public class POIWordUtils {
    25.     private static final Logger log = LoggerFactory.getLogger(POIWordUtils.class.getName());
    27.     /**
    28.      * docx to html
    29.      *
    30.      * @param in 输入流
    31.      * @return
    32.      * @throws IOException
    33.      */
    34.     public static InputStream docxToHtml(InputStream in, String filePath) {
    35.         XWPFDocument document = null;
    36.         try {
    37.             document = new XWPFDocument(in);
    38.             XHTMLOptions options = XHTMLOptions.create();
    39.             options.setIgnoreStylesIfUnused(false);
    40.             options.setFragment(true);
    41.             filePath = filePath+"image"+File.separator;
    42.             options.setExtractor(new FileImageExtractor(new File(filePath)));
    43.             options.URIResolver(new BasicURIResolver("image"));
    44.             ByteArrayOutputStream out = new ByteArrayOutputStream();
    45.             XHTMLConverter.getInstance().convert(document, out, options);
    46.             return new ByteArrayInputStream(out.toByteArray());
    47.         } catch (IOException e) {
    48.             log.error(e.getMessage(), e);
    49.         }
    50.         return in;
    51.     }
    52.     /**
    53.      * doc to html
    54.      *
    55.      * @param in
    56.      * @return
    57.      * @throws Exception
    58.      */
    59.     public static InputStream docToHtml(InputStream in) {
    60.         try {
    61.             HWPFDocument wordDocument = new HWPFDocument(in);
    62.             WordToHtmlConverter wordToHtmlConverter = new WordToHtmlConverter(
    63.                     DocumentBuilderFactory.newInstance().newDocumentBuilder().newDocument());
    64.             wordToHtmlConverter.processDocument(wordDocument);
    65.             Document htmlDocument = wordToHtmlConverter.getDocument();
    66.             ByteArrayOutputStream outStream = new ByteArrayOutputStream();
    67.             DOMSource domSource = new DOMSource(htmlDocument);
    68.             StreamResult streamResult = new StreamResult(outStream);
    69.             TransformerFactory factory = TransformerFactory.newInstance();
    70.             Transformer serializer = factory.newTransformer();
    71.             serializer.setOutputProperty(OutputKeys.ENCODING, "utf-8");
    72.             serializer.setOutputProperty(OutputKeys.INDENT, "yes");
    73.             serializer.setOutputProperty(OutputKeys.METHOD, "html");
    74.             serializer.transform(domSource, streamResult);
    75.             outStream.close();
    76.             return new ByteArrayInputStream(outStream.toByteArray());
    77.         } catch (Exception e) {
    78.             log.error(e.getMessage(), e);
    79.         }
    80.         return in;
    81.     }
    82.     public static InputStream docToHtml(Map<String, Object> request, InputStream in) {
    83.         String fileName = (String) request.get("name");
    84.         if (StringUtils.isEmpty(fileName)) {
    85.             return in;
    86.         }
    87.         String extensionName = fileName.substring(fileName.lastIndexOf(".") + 1, fileName.length());
    88.         String prevName = fileName.substring(0, fileName.lastIndexOf("."));
    89.         if ("html".equalsIgnoreCase(extensionName)) {
    90.             return in;
    91.         }
    92.         if ("doc".equalsIgnoreCase(extensionName)) {
    93.             request.put("name", prevName + ".html");
    94.             return docToHtml(in);
    95.         }
    96.         if ("docx".equalsIgnoreCase(extensionName)) {
    97.             request.put("name", prevName + ".html");
    98.             return docxToHtml(in, (String)request.get("filePath"));
    99.         }
    100.         return in;
    101.     }
    103.     public static void inputStreamToFile(InputStream inputStream, String newPath) {
    104.         OutputStream outputStream = null;
    105.         try {
    106.             File file = new File(newPath);
    107.             outputStream = new FileOutputStream(file);
    109.             int bytesWritten = 0;
    110.             int byteCount = 0;
    112.             byte[] bytes = new byte[1024];
    114.             while ((byteCount = inputStream.read(bytes)) != -1) {
    115.                 outputStream.write(bytes, bytesWritten, byteCount);
    116.             }
    118.             System.out.println("Done!");
    119.         } catch (IOException e) {
    120.             e.printStackTrace();
    121.         } finally {
    122.             if (inputStream != null) {
    123.                 try {
    124.                     inputStream.close();
    125.                 } catch (IOException e) {
    126.                     e.printStackTrace();
    127.                 }
    128.             }
    129.             if (outputStream != null) {
    130.                 try {
    131.                     outputStream.close();
    132.                 } catch (IOException e) {
    133.                     e.printStackTrace();
    134.                 }
    136.             }
    137.         }
    138.     }
    139.     public static void docConversionToHtml( String newfileName, String fileName, String filePath) throws FileNotFoundException {
    140.         Map<String, Object> paramsMap = new HashMap<String, Object>();
    141.         paramsMap.put("name", fileName);
    142.         paramsMap.put("filePath", filePath);
    143.         InputStream in = new FileInputStream(filePath + fileName);// 读取文件的数据。
    144.         InputStream result = POIWordUtils.docToHtml(paramsMap, in);
    145.         POIWordUtils.inputStreamToFile(result, filePath+newfileName);
    147.     }
    148. }

  • Excel 转换成HTML

    1. package com.example.demo.util;
    3. import org.apache.poi.hssf.usermodel.*;
    4. import org.apache.poi.hssf.util.HSSFColor;
    5. import org.apache.poi.ss.usermodel.*;
    6. import org.apache.poi.ss.util.CellRangeAddress;
    7. import org.apache.poi.xssf.usermodel.XSSFCellStyle;
    8. import org.apache.poi.xssf.usermodel.XSSFColor;
    9. import org.apache.poi.xssf.usermodel.XSSFFont;
    10. import org.apache.poi.xssf.usermodel.XSSFWorkbook;
    12. import java.io.*;
    13. import java.text.DecimalFormat;
    14. import java.text.SimpleDateFormat;
    15. import java.util.Date;
    16. import java.util.HashMap;
    17. import java.util.Map;
    19. public class ExcelToHTML {
    20.     /**
    21.      * @param filePath    excel源文件文件的路径
    22.      * @param htmlPositon 生成的html文件的路径
    23.      * @param isWithStyle 是否需要表格样式 包含 字体 颜色 边框 对齐方式
    24.      */
    25.     public static String readExcelToHtml(String filePath, String htmlPositon, boolean isWithStyle) {
    27.         InputStream is = null;
    28.         String htmlExcel = null;
    29.         try {
    30.             File sourcefile = new File(filePath);
    31.             is = new FileInputStream(sourcefile);
    32.             Workbook wb = WorkbookFactory.create(is);
    33.             if (wb instanceof XSSFWorkbook) {   //03版excel处理方法
    34.                 XSSFWorkbook xWb = (XSSFWorkbook) wb;
    35.                 htmlExcel = ExcelToHTML.getExcelInfo(xWb, isWithStyle);
    36.             } else if (wb instanceof HSSFWorkbook) {  //07及10版以后的excel处理方法
    37.                 HSSFWorkbook hWb = (HSSFWorkbook) wb;
    38.                 htmlExcel = ExcelToHTML.getExcelInfo(hWb, isWithStyle);
    39.             }
    40.             writeFile(htmlExcel, htmlPositon);
    41.         } catch (Exception e) {
    42.             e.printStackTrace();
    43.         } finally {
    44.             try {
    45.                 is.close();
    46.             } catch (IOException e) {
    47.                 e.printStackTrace();
    48.             }
    49.         }
    50.         return htmlPositon;
    51.     }
    54.     private static String getExcelInfo(Workbook wb, boolean isWithStyle) {
    56.         StringBuffer sb = new StringBuffer();
    57.         Sheet sheet = wb.getSheetAt(0);//获取第一个Sheet的内容
    58.         int lastRowNum = sheet.getLastRowNum();
    59.         Map<String, String> map[] = getRowSpanColSpanMap(sheet);
    60.         sb.append("<table style=\'border-collapse:collapse;\' width=\'100%\'>");
    61.         Row row = null;        //兼容
    62.         Cell cell = null;    //兼容
    64.         for (int rowNum = sheet.getFirstRowNum(); rowNum <= lastRowNum; rowNum++) {
    65.             row = sheet.getRow(rowNum);
    66.             if (row == null) {
    67.                 sb.append("<tr><td ><nobr> </nobr></td></tr>");
    68.                 continue;
    69.             }
    70.             sb.append("<tr>");
    71.             int lastColNum = row.getLastCellNum();
    72.             for (int colNum = 0; colNum < lastColNum; colNum++) {
    73.                 cell = row.getCell(colNum);
    74.                 if (cell == null) {    //特殊情况 空白的单元格会返回null
    75.                     sb.append("<td> </td>");
    76.                     continue;
    77.                 }
    79.                 String stringValue = getCellValue(cell);
    80.                 if (map[0].containsKey(rowNum + "," + colNum)) {
    81.                     String pointString = map[0].get(rowNum + "," + colNum);
    82.                     map[0].remove(rowNum + "," + colNum);
    83.                     int bottomeRow = Integer.valueOf(pointString.split(",")[0]);
    84.                     int bottomeCol = Integer.valueOf(pointString.split(",")[1]);
    85.                     int rowSpan = bottomeRow - rowNum + 1;
    86.                     int colSpan = bottomeCol - colNum + 1;
    87.                     sb.append("<td rowspan= \'" + rowSpan + "\' colspan= \'" + colSpan + "\' ");
    88.                 } else if (map[1].containsKey(rowNum + "," + colNum)) {
    89.                     map[1].remove(rowNum + "," + colNum);
    90.                     continue;
    91.                 } else {
    92.                     sb.append("<td ");
    93.                 }
    95.                 //判断是否需要样式
    96.                 if (isWithStyle) {
    97.                     dealExcelStyle(wb, sheet, cell, sb);//处理单元格样式
    98.                 }
    100.                 sb.append("><nobr>");
    101.                 if (stringValue == null || "".equals(stringValue.trim())) {
    102.                     sb.append("   ");
    103.                 } else {
    104.                     // 将ascii码为160的空格转换为html下的空格（ ）
    105.                     String aaa = stringValue.replace(String.valueOf((char) 160), " ");
    106.                     sb.append(stringValue.replace(String.valueOf((char) 160), " "));
    107.                 }
    108.                 sb.append("</nobr></td>");
    109.             }
    110.             sb.append("</tr>");
    111.         }
    113.         sb.append("</table>");
    114.         return sb.toString();
    115.     }
    117.     private static Map<String, String>[] getRowSpanColSpanMap(Sheet sheet) {
    119.         Map<String, String> map0 = new HashMap<String, String>();
    120.         Map<String, String> map1 = new HashMap<String, String>();
    121.         int mergedNum = sheet.getNumMergedRegions();
    122.         CellRangeAddress range = null;
    123.         for (int i = 0; i < mergedNum; i++) {
    124.             range = sheet.getMergedRegion(i);
    125.             int topRow = range.getFirstRow();
    126.             int topCol = range.getFirstColumn();
    127.             int bottomRow = range.getLastRow();
    128.             int bottomCol = range.getLastColumn();
    129.             map0.put(topRow + "," + topCol, bottomRow + "," + bottomCol);
    130.             // System.out.println(topRow + "," + topCol + "," + bottomRow + "," + bottomCol);
    131.             int tempRow = topRow;
    132.             while (tempRow <= bottomRow) {
    133.                 int tempCol = topCol;
    134.                 while (tempCol <= bottomCol) {
    135.                     map1.put(tempRow + "," + tempCol, "");
    136.                     tempCol++;
    137.                 }
    138.                 tempRow++;
    139.             }
    140.             map1.remove(topRow + "," + topCol);
    141.         }
    142.         Map[] map = {map0, map1};
    143.         return map;
    144.     }
    147.     /**
    148.      * 获取表格单元格Cell内容
    149.      *
    150.      * @param cell
    151.      * @return
    152.      */
    153.     private static String getCellValue(Cell cell) {
    155.         String result = new String();
    156.         switch (cell.getCellType()) {
    157.             case Cell.CELL_TYPE_NUMERIC:// 数字类型
    158.                 if (HSSFDateUtil.isCellDateFormatted(cell)) {// 处理日期格式、时间格式
    159.                     SimpleDateFormat sdf = null;
    160.                     if (cell.getCellStyle().getDataFormat() == HSSFDataFormat.getBuiltinFormat("h:mm")) {
    161.                         sdf = new SimpleDateFormat("HH:mm");
    162.                     } else {// 日期
    163.                         sdf = new SimpleDateFormat("yyyy-MM-dd");
    164.                     }
    165.                     Date date = cell.getDateCellValue();
    166.                     result = sdf.format(date);
    167.                 } else if (cell.getCellStyle().getDataFormat() == 58) {
    168.                     // 处理自定义日期格式：m月d日(通过判断单元格的格式id解决，id的值是58)
    169.                     SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
    170.                     double value = cell.getNumericCellValue();
    171.                     Date date = DateUtil
    172.                             .getJavaDate(value);
    173.                     result = sdf.format(date);
    174.                 } else {
    175.                     double value = cell.getNumericCellValue();
    176.                     CellStyle style = cell.getCellStyle();
    177.                     DecimalFormat format = new DecimalFormat();
    178.                     String temp = style.getDataFormatString();
    179.                     // 单元格设置成常规
    180.                     if (temp.equals("General")) {
    181.                         format.applyPattern("#");
    182.                     }
    183.                     result = format.format(value);
    184.                 }
    185.                 break;
    186.             case Cell.CELL_TYPE_STRING:// String类型
    187.                 result = cell.getRichStringCellValue().toString();
    188.                 break;
    189.             case Cell.CELL_TYPE_BLANK:
    190.                 result = "";
    191.                 break;
    192.             default:
    193.                 result = "";
    194.                 break;
    195.         }
    196.         return result;
    197.     }
    199.     /**
    200.      * 处理表格样式
    201.      *
    202.      * @param wb
    203.      * @param sheet
    204.      * @param sb
    205.      */
    206.     private static void dealExcelStyle(Workbook wb, Sheet sheet, Cell cell, StringBuffer sb) {
    208.         CellStyle cellStyle = cell.getCellStyle();
    209.         if (cellStyle != null) {
    210.             short alignment = cellStyle.getAlignment();
    211.             //    sb.append("align=\'" + convertAlignToHtml(alignment) + "\' ");//单元格内容的水平对齐方式
    212.             short verticalAlignment = cellStyle.getVerticalAlignment();
    213.             sb.append("valign=\'" + convertVerticalAlignToHtml(verticalAlignment) + "\' ");//单元格中内容的垂直排列方式
    215.             if (wb instanceof XSSFWorkbook) {
    217.                 XSSFFont xf = ((XSSFCellStyle) cellStyle).getFont();
    218.                 short boldWeight = xf.getBoldweight();
    219.                 String align = convertAlignToHtml(alignment);
    220.                 sb.append("style=\'");
    221.                 sb.append("font-weight:" + boldWeight + ";"); // 字体加粗
    222.                 sb.append("font-size: " + xf.getFontHeight() / 2 + "%;"); // 字体大小
    223.                 int columnWidth = sheet.getColumnWidth(cell.getColumnIndex());
    224.                 sb.append("width:" + columnWidth + "px;");
    225.                 sb.append("text-align:" + align + ";");//表头排版样式
    226.                 XSSFColor xc = xf.getXSSFColor();
    227.                 if (xc != null && !"".equals(xc)) {
    228.                     sb.append("color:#" + xc.getARGBHex().substring(2) + ";"); // 字体颜色
    229.                 }
    231.                 XSSFColor bgColor = (XSSFColor) cellStyle.getFillForegroundColorColor();
    232.                 if (bgColor != null && !"".equals(bgColor)) {
    233.                     sb.append("background-color:#" + bgColor.getARGBHex().substring(2) + ";"); // 背景颜色
    234.                 }
    235.                 sb.append(getBorderStyle(0, cellStyle.getBorderTop(), ((XSSFCellStyle) cellStyle).getTopBorderXSSFColor()));
    236.                 sb.append(getBorderStyle(1, cellStyle.getBorderRight(), ((XSSFCellStyle) cellStyle).getRightBorderXSSFColor()));
    237.                 sb.append(getBorderStyle(2, cellStyle.getBorderBottom(), ((XSSFCellStyle) cellStyle).getBottomBorderXSSFColor()));
    238.                 sb.append(getBorderStyle(3, cellStyle.getBorderLeft(), ((XSSFCellStyle) cellStyle).getLeftBorderXSSFColor()));
    240.             } else if (wb instanceof HSSFWorkbook) {
    242.                 HSSFFont hf = ((HSSFCellStyle) cellStyle).getFont(wb);
    243.                 short boldWeight = hf.getBoldweight();
    244.                 short fontColor = hf.getColor();
    245.                 sb.append("style=\'");
    246.                 HSSFPalette palette = ((HSSFWorkbook) wb).getCustomPalette(); // 类HSSFPalette用于求的颜色的国际标准形式
    247.                 HSSFColor hc = palette.getColor(fontColor);
    248.                 sb.append("font-weight:" + boldWeight + ";"); // 字体加粗
    249.                 sb.append("font-size: " + hf.getFontHeight() / 2 + "%;"); // 字体大小
    250.                 String align = convertAlignToHtml(alignment);
    251.                 sb.append("text-align:" + align + ";");//表头排版样式
    252.                 String fontColorStr = convertToStardColor(hc);
    253.                 if (fontColorStr != null && !"".equals(fontColorStr.trim())) {
    254.                     sb.append("color:" + fontColorStr + ";"); // 字体颜色
    255.                 }
    256.                 int columnWidth = sheet.getColumnWidth(cell.getColumnIndex());
    257.                 sb.append("width:" + columnWidth + "px;");
    258.                 short bgColor = cellStyle.getFillForegroundColor();
    259.                 hc = palette.getColor(bgColor);
    260.                 String bgColorStr = convertToStardColor(hc);
    261.                 if (bgColorStr != null && !"".equals(bgColorStr.trim())) {
    262.                     sb.append("background-color:" + bgColorStr + ";"); // 背景颜色
    263.                 }
    264.                 sb.append(getBorderStyle(palette, 0, cellStyle.getBorderTop(), cellStyle.getTopBorderColor()));
    265.                 sb.append(getBorderStyle(palette, 1, cellStyle.getBorderRight(), cellStyle.getRightBorderColor()));
    266.                 sb.append(getBorderStyle(palette, 3, cellStyle.getBorderLeft(), cellStyle.getLeftBorderColor()));
    267.                 sb.append(getBorderStyle(palette, 2, cellStyle.getBorderBottom(), cellStyle.getBottomBorderColor()));
    268.             }
    270.             sb.append("\' ");
    271.         }
    272.     }
    274.     /**
    275.      * 单元格内容的水平对齐方式
    276.      *
    277.      * @param alignment
    278.      * @return
    279.      */
    280.     private static String convertAlignToHtml(short alignment) {
    282.         String align = "center";
    283.         switch (alignment) {
    284.             case CellStyle.ALIGN_LEFT:
    285.                 align = "left";
    286.                 break;
    287.             case CellStyle.ALIGN_CENTER:
    288.                 align = "center";
    289.                 break;
    290.             case CellStyle.ALIGN_RIGHT:
    291.                 align = "right";
    292.                 break;
    293.             default:
    294.                 break;
    295.         }
    296.         return align;
    297.     }
    299.     /**
    300.      * 单元格中内容的垂直排列方式
    301.      *
    302.      * @param verticalAlignment
    303.      * @return
    304.      */
    305.     private static String convertVerticalAlignToHtml(short verticalAlignment) {
    307.         String valign = "middle";
    308.         switch (verticalAlignment) {
    309.             case CellStyle.VERTICAL_BOTTOM:
    310.                 valign = "bottom";
    311.                 break;
    312.             case CellStyle.VERTICAL_CENTER:
    313.                 valign = "center";
    314.                 break;
    315.             case CellStyle.VERTICAL_TOP:
    316.                 valign = "top";
    317.                 break;
    318.             default:
    319.                 break;
    320.         }
    321.         return valign;
    322.     }
    324.     private static String convertToStardColor(HSSFColor hc) {
    326.         StringBuffer sb = new StringBuffer("");
    327.         if (hc != null) {
    328.             if (HSSFColor.AUTOMATIC.index == hc.getIndex()) {
    329.                 return null;
    330.             }
    331.             sb.append("#");
    332.             for (int i = 0; i < hc.getTriplet().length; i++) {
    333.                 sb.append(fillWithZero(Integer.toHexString(hc.getTriplet()[i])));
    334.             }
    335.         }
    337.         return sb.toString();
    338.     }
    340.     private static String fillWithZero(String str) {
    341.         if (str != null && str.length() < 2) {
    342.             return "0" + str;
    343.         }
    344.         return str;
    345.     }
    347.     static String[] bordesr = {"border-top:", "border-right:", "border-bottom:", "border-left:"};
    348.     static String[] borderStyles = {"solid ", "solid ", "solid ", "solid ", "solid ", "solid ", "solid ", "solid ", "solid ", "solid", "solid", "solid", "solid", "solid"};
    350.     private static String getBorderStyle(HSSFPalette palette, int b, short s, short t) {
    352.         if (s == 0) {
    353.             return bordesr[b] + borderStyles[s] + "#d0d7e5 1px;";
    354.         }
    355.         String borderColorStr = convertToStardColor(palette.getColor(t));
    356.         borderColorStr = borderColorStr == null || borderColorStr.length() < 1 ? "#000000" : borderColorStr;
    357.         return bordesr[b] + borderStyles[s] + borderColorStr + " 1px;";
    359.     }
    361.     private static String getBorderStyle(int b, short s, XSSFColor xc) {
    363.         if (s == 0) {
    364.             return bordesr[b] + borderStyles[s] + "#d0d7e5 1px;";
    365.         }
    366.         if (xc != null && !"".equals(xc)) {
    367.             String borderColorStr = xc.getARGBHex();//t.getARGBHex();
    368.             borderColorStr = borderColorStr == null || borderColorStr.length() < 1 ? "#000000" : borderColorStr.substring(2);
    369.             return bordesr[b] + borderStyles[s] + borderColorStr + " 1px;";
    370.         }
    372.         return "";
    373.     }
    375.     /*
    376.      * @param content 生成的excel表格标签
    377.      * @param htmlPath 生成的html文件地址
    378.      */
    379.     private static void writeFile(String content, String htmlPath) throws UnsupportedEncodingException {
    380.         File file2 = new File(htmlPath);
    381.         StringBuilder sb = new StringBuilder();
    382.         sb.append("<html><head><meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\"><title>Html Test</title></head><body>");
    383.         sb.append("<div>");
    384.         sb.append(content);
    385.         sb.append("</div>");
    386.         sb.append("</body></html>");
    387.         String fileText = sb.toString();
    389.         try {
    390.             file2.createNewFile();//创建文件
    391.             BufferedWriter out = new BufferedWriter(new OutputStreamWriter(new FileOutputStream(file2), "utf-8"));
    392. //            FileWriter fw=new FileWriter(file2);//在workspace工作空间里创建文件,文件名为hello
    393.             out.write(fileText);
    394.         } catch (IOException e) {
    395.             e.printStackTrace();
    396.         }
    397.     }
    398. }

版权声明：本文为Glc-Blog原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://www.cnblogs.com/Glc-Blog/p/14179625.html