POI excel 单元个的内容 自适应行高

POI excel 单元个的内容 自适应行高

 

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;
        }
}