excel 单元格动态高度

具体方法

/**
 * 根据行内容重新计算行高
 */
public static float calcAndSetRowHeight(HSSFRow contentRow, String cellContent, int cellWidth) {

    double totalRows = 0;
    String[] arr  = cellContent.split("\n");
    for (int i = 0; i < arr.length; i++) {
        String s = arr[i];

        int totalCount = 0;
        for(int j=0;j<s.length();j++){
            String b=Character.toString(s.charAt(j));
            if (b.getBytes().length == 1) {
                totalCount++;
            } else {
                totalCount = totalCount + 2;
            }
        }

        double l = totalCount * 256;

        if (l < cellWidth) {
            l = cellWidth;
        }

        // 字符串需要的行数 不做四舍五入之类的操作。
        double stringNeedsRows = Math.ceil(l / cellWidth);

        totalRows += stringNeedsRows;
    }

    return (float) ((totalRows + 2) * contentRow.getHeightInPoints());
}