Apache POI：找出溢出到下一列的文本的 colspan

Apache poi能够根据内容自动调整列的大小。所以它需要能够计算特殊内容需要的列宽。这就是SheetUtil.getCellWidth正在做的事情。此外，还需要了解Microsoft在Excel. 例如，在ExcelsGUI中，列宽为 10 意味着默认字符宽度的 10 个字符适合单元格宽度。但在内部，宽度是以默认字符宽度的 1/256 为单位计算的。这就是为什么apache poi决定以字符宽度的 1/256 为单位获取Sheet.getColumnWidth的原因。所以如果你有一个Cell cell单元格索引c和一个特殊的内容，那么使用Workbook workbook......DataFormatter dataFormatter = new DataFormatter();...int defaultCharWidth = SheetUtil.getDefaultCharWidth(workbook);...double cellValueWidth = SheetUtil.getCellWidth(cell, defaultCharWidth, dataFormatter, false);int neededColunmnWidth = (int)cellValueWidth*256;int columnWidth = sheet.getColumnWidth(c);...您可以确定内容是否适合单元格。它适合 if columnWidth >= neededColunmnWidth，否则它不适合并且colspan必须使用。让我们有一个完整的例子来说明原理：床单：代码：import org.apache.poi.ss.usermodel.*;import org.apache.poi.ss.util.SheetUtil;import java.io.*;class ExcelToHTMLColspan { public static void main(String[] args) throws Exception{  Workbook workbook = WorkbookFactory.create(new FileInputStream("Test.xlsx"));  DataFormatter dataFormatter = new DataFormatter();  int defaultCharWidth = SheetUtil.getDefaultCharWidth(workbook);  int lastColumnToExport = 5; // column E  Sheet sheet = workbook.getSheetAt(0);  Row row;  Cell cell;  String cellValue;  StringBuilder tableHTML = new StringBuilder();  tableHTML.append("<TABLE>");  tableHTML.append("<COLGROUP>");  for (int c = 0; c < lastColumnToExport; c++) {   long columnWidthPx = Math.round(sheet.getColumnWidthInPixels(c));   tableHTML.append("<COL width=\"" + columnWidthPx + "\"/>");  }  tableHTML.append("</COLGROUP>");  for (int r = 0; r <= sheet.getLastRowNum(); r++) {   row = sheet.getRow(r); if (row == null) row = sheet.createRow(r);   long rowHeightPx = Math.round(row.getHeightInPoints() * 92f / 72f);   tableHTML.append("<TR height=\"" + rowHeightPx + "\">");   int c = 0;   while(c < lastColumnToExport) {    tableHTML.append("<TD");    cell = row.getCell(c); if (cell == null) cell = row.createCell(c);    cellValue = dataFormatter.formatCellValue(cell);    double cellValueWidth = SheetUtil.getCellWidth(cell, defaultCharWidth, dataFormatter, false);    int neededColunmnWidth = (int)cellValueWidth*256;    int columnWidth = sheet.getColumnWidth(c);    if (columnWidth < neededColunmnWidth) {     int colSpan = 1;     while(columnWidth < neededColunmnWidth) {      colSpan++;      c++;      columnWidth += sheet.getColumnWidth(c);     }      tableHTML.append(" colspan=\"" + colSpan + "\""  + ">" + cellValue);     c++;    } else {     tableHTML.append(">" + cellValue);     c++;    }    tableHTML.append("</TD>");   }   tableHTML.append("</TR>");  }  tableHTML.append("</TABLE>");  workbook.close();System.out.println(tableHTML.toString());  //creating a sample HTML file   String encoding = "UTF-8";  FileOutputStream fos = new FileOutputStream("result.html");  OutputStreamWriter writer = new OutputStreamWriter(fos, encoding);  writer.write("<!DOCTYPE html>\n");  writer.write("<html lang=\"en\">");  writer.write("<head>");  writer.write("<meta charset=\"utf-8\"/>");  writer.write("<style>");  writer.write("table {border-collapse: collapse; table-layout: fixed;}");  writer.write("table, tr, td {border: 1px solid black;}");  writer.write("td {font: 11pt Calibri, arial, sans-serif;}");  writer.write("</style>");  writer.write("</head>");  writer.write("<body>");  writer.write(tableHTML.toString());  writer.write("</body>");  writer.write("</html>");  writer.close();  java.awt.Desktop.getDesktop().browse(new File("result.html").toURI()); }}结果：

Apache POI：找出溢出到下一列的文本的 colspan

1回答