-
java 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("
").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;
- }
- }
-
相关阅读:
【WinHec启示录】透过Windows 10技术布局,谈微软王者归来
管中窥豹,物联网之我见
微软借力.NET开源跨平台支持,布局物联网平台开发
面向对象开发方式的开源硬件--.NET Gadgeteer
【物联网智能网关-18】多通道远程安全升级
vim 多文件编辑【超实用】
debian下samba配置
制作根文件系统的经验
c语言: inline(gcc)
Cramfs、JFFS2、YAFFS2的全面对比
-
原文地址:https://www.cnblogs.com/chenlin1990/p/7169730.html
Copyright © 2020-2023
润新知