java poi自适应宽度（中文支持 HSSFSheet 和Sheet的）

最新推荐文章于 2021-02-24 05:41:59 发布

都昌小码农

最新推荐文章于 2021-02-24 05:41:59 发布

阅读量4.6k

点赞数 5

分类专栏： java 文章标签： java

本文链接：https://blog.youkuaiyun.com/taisuiyu6397/article/details/107490858

版权

java 专栏收录该内容

20 篇文章

订阅专栏

java poi自适应宽度（中文支持 HSSFSheet 和Sheet的）

1.HSSFSheet 的

    /**
     *  自适应列宽
     * @param sheet
     * @param columnLength 列数
     */
private static void setSizeColumn(HSSFSheet sheet, int columnLength) {
         for (int columnNum = 0; columnNum <= columnLength; columnNum++) {
             int columnWidth = sheet.getColumnWidth(columnNum) / 256;
             for (int rowNum = 0; rowNum < sheet.getLastRowNum(); rowNum++) {
                 HSSFRow currentRow; // 当前行未被使用过
                 if (sheet.getRow(rowNum) == null) {
                     currentRow = sheet.createRow(rowNum);
                 } else {
                     currentRow = sheet.getRow(rowNum);
                 }
                 if (currentRow.getCell(columnNum) != null) {
                     HSSFCell currentCell = currentRow.getCell(columnNum);
                     if (currentCell.getCellType() == HSSFCell.CELL_TYPE_STRING) {
                         int length = currentCell.getStringCellValue().getBytes().length;
                         if (columnWidth < length) {
                             columnWidth = length;
                         }
                     }
                 }
             }
             sheet.setColumnWidth(columnNum, columnWidth * 256);
         }
     }

2.Sheet的

   /**
     *  自适应列宽
     * @param sheet
     * @param columnLength 列数
     */
    private static void setSizeColumn(Sheet sheet, int columnLength) {
        for (int columnNum = 0; columnNum <= columnLength; columnNum++) {
            int columnWidth = sheet.getColumnWidth(columnNum) / 256;
            for (int rowNum = 0; rowNum < sheet.getLastRowNum(); rowNum++) {
                Row currentRow; // 当前行未被使用过
                if (sheet.getRow(rowNum) == null) {
                    currentRow =  sheet.createRow(rowNum);
                } else {
                    currentRow =  sheet.getRow(rowNum);
                }
                if (currentRow.getCell(columnNum) != null) {
                    Cell currentCell = currentRow.getCell(columnNum);
                    if (currentCell.getCellType() == HSSFCell.CELL_TYPE_STRING) {
                        int length = currentCell.getStringCellValue().getBytes().length;
                        if (columnWidth < length) {
                            columnWidth = length;
                        }
                    }
                }
            }
            sheet.setColumnWidth(columnNum, columnWidth * 256);
        }
    }