POI excel 单元个的内容 自适应行高
?
class="java" name="code">public static void main(String[] args) { InputStream is = null; Workbook book = null; try { is = new FileInputStream("D:\\test.xls"); book = new HSSFWorkbook(is); Sheet sheet = book.getSheetAt(0); for(int i = 0; i <= 10; i ++) { Row row = sheet.getRow(i); int enterCnt = 0; int colIdxOfMaxCnt = 1; for(int j = 0; j <= 10; j ++) { int rwsTemp = row.getCell(j).toString().split("\n").length; if (rwsTemp > enterCnt) { enterCnt = rwsTemp; colIdxOfMaxCnt = j; } } System.out.println(colIdxOfMaxCnt + "列的行数:" + enterCnt); row.setHeight((short)(enterCnt * 228)); } File f = new File("D:\\test.xls"); FileOutputStream out = new FileOutputStream(f); book.write(out); out.close(); is.close(); } catch (IOException e) { return; } }
?
?
?
?
?