不知道这是不是你想要的:
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,结宜