- 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
爱学习的陈工
阅读(
16190)
评论()
编辑
收藏
举报
点击右上角即可分享
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步