这种的EXCEL表格 怎么来解析？？

Question

[img]http://dl.iteye.com/upload/attachment/588017/62a4f146-2ddc-3bc0-9364-74045f917346.jpg[/img]

如图的EXCEL表格 怎么来解析？？

Answer 1

比如合并单元格是这样
[code="java"]// Merge first row and column from 0 to maxColumnNum:
sheet.addMergedRegion(new Region(0, (short)0, 0, (short)maxColumnNum)); [/code]

获取合并单元格内容
[code="java"]Region r =sheet.getMergedRegionAt(0);
HSSFCell cell = sheet.getRow(r.getRowFrom()).getCell(r.getColumnFrom());
System.out.println(""+cell.getStringCellValue());[/code]