作者:乔山办公网日期:
返回目录:excel表格制作
//判断表中是否含有合并单元格
public boolean hasMerged() {
return sheet.getNumMergedRegions() > 0 ? true : false;
}
// 判断指定636f7079e79fa5e98193364区域内是否含有合并单元格
public boolean hasMerged(Region region) {
for (int row = region.getRowFrom(); row < region.getRowTo(); row++) {
for (short col = region.getColumnFrom(); col < region.getColumnTo(); col++){
for (int i = 0; i < sheet.getNumMergedRegions(); i++) {
Region r = sheet.getMergedRegionAt(i);
if (r.contains(row, col)) {
return true;
}
}
}
}
return false;
}
HSSFWorkbook wb = new HSSFWorkbook();
道 HSSFSheet sheet = wb.createSheet("new sheet");
HSSFRow row = sheet.createRow((short) 1);
HSSFCell cell = row.createCell((short) 1);
HSSFRichTextString content = new HSSFRichTextString("This is a test of message");
cell.setCellValue(content);
sheet.addMergedRegion(new Region(1,(short)1,1,(short)2));
FileOutputStream fileOut = new FileOutputStream("d:/Demo_02_05.xls");
wb.write(fileOut);
fileOut.close();
你问的有点含糊,合并的单元格就是一个单元格了 如果要读zhidao取合并以后单元格中的内容,可以先读取这个文件中有多少个MergedRegion,然后版再通过判断要读取的单元格的行和列号是否是这个MergedRegion的起始位置来权读取内容。