使用JXL 读取Excel合并单元格方法

import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.io.InputStream;

import jxl.Range;
import jxl.Sheet;
import jxl.Workbook;
import jxl.read.biff.BiffException;

public class ReadExcel {
public ReadExcel(){

}
public void readExcel(String filepath){
try {
InputStream is = new FileInputStream(filepath);
Workbook wb = Workbook.getWorkbook(is);
int sheet_size = wb.getNumberOfSheets();
for(int index = 0; index < sheet_size ; index++){
Sheet sheet = wb.getSheet(index);
Range[] ranges = sheet.getMergedCells();
    System.out.println("sheet" + index + "包含" + ranges.length + "个区域");
    for(Range space:ranges){
    System.out.print(space.getTopLeft().getRow()+1+"行,");
    System.out.print(space.getTopLeft().getColumn()+1+"列\t");
    System.out.print(space.getBottomRight().getRow()+1+"行,");
    System.out.print(space.getBottomRight().getColumn()+1+"列\n");
    }
}
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (BiffException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
}
}

评论

3 楼 hw1287789687 2013-07-25  

怎么读取合并单元格中的内容呢？

2 楼 yu165683 2011-11-29  

thank you very much!

1 楼 ruvuoai 2009-05-11  

送你一张好人卡,正需要,你就出现在了google上,太善解人意了!!