当前位置:知识百问>百科问答>java excel a则次盐结宜pi

java excel a则次盐结宜pi

2024-06-06 07:58:23 编辑:join 浏览量:533

java excel a则次盐结宜pi

不知道这是不是你想要的:

importjava.io.FileInputStream;

imp居航ortjava.io.FileNotFoundE类维解秋xception;

importjava.io.IOException;

importjava.io.InputStream取主倍犯固文顾;

importjxl.来自Range;

importjxl.Sheet;

importjxl.Workb英物富振宁灯苗攻粉销香ook;

importjxl.read.biff.BiffException;

publicclassR360问答eadExcel{

p采刻训肉执维ublicReadExcel(){

}

publicvoidreadExcel(Stringfilepath){

try{

I蒸宜nputStreamis=newFileInputStr秋存训职聚历领eam(filepath);

Workbookwb=Workbook.get尔Workbook(is);

intsheet_size=wb.getNumberOfSheets(抗危族到在亮);

for(intindex=岩来严穿问同温价使座护0;index<sheet_size;index美己两且声介比++){

Sheetsheet=wb.getSheet(index);

Range[]r口告晚完是anges=sheet.getMergedCe某般名lls();

System.out.println("sheet"+index+"包含"+ranges.length+"个区域");

for(Rangespace:ranges){

System.out.print(space.getTopLeft().getRow()+1+"行,")胶括包实;

System.out.print(space.getTopLeft().getColumn()+1+"列\t");

System.out.pri哪价执展没nt(space.getBottomRight().getRow()+1+"行,"比部厚众);

System.out.print(space.getBottomRight().getColumn()+1+"列\n");

}

}

}catch(FileNotFoundExceptione){

e.printStackTrace();

}catch(BiffExceptione){

e.printStackTrace();

}catch(IOExceptione){

e.printStackTrace();

}

}

}

标签:java,excel,结宜

版权声明:文章由 知识百问 整理收集,来源于互联网或者用户投稿,如有侵权,请联系我们,我们会立即处理。如转载请保留本文链接:https://www.zhshbaiwen.com/answer/339747.html
热门文章