- 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;
- }
- }
posted @
2017-07-14 13:30
爱学习的陈工
阅读(
16139)
评论()
编辑
收藏
举报