欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页

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

程序员文章站 2022-06-13 08:10:27
...

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

 

 

 

 

 

相关标签: poi java excel