POI解析EXCEL

Java代码

1. /**
2. * 获取合并单元格的值
3. * @param sheet
4. * @param row
5. * @param column
6. * @return
7. */
8. public String getMergedRegionValue(Sheet sheet ,int row , int column){
9. int sheetMergeCount = sheet.getNumMergedRegions();
11. for(int i = 0 ; i < sheetMergeCount ; i++){
12. CellRangeAddress ca = sheet.getMergedRegion(i);
13. int firstColumn = ca.getFirstColumn();
14. int lastColumn = ca.getLastColumn();
15. int firstRow = ca.getFirstRow();
16. int lastRow = ca.getLastRow();
18. if(row >= firstRow && row <= lastRow){
20. if(column >= firstColumn && column <= lastColumn){
21. Row fRow = sheet.getRow(firstRow);
22. Cell fCell = fRow.getCell(firstColumn);
24. return getCellValue(fCell) ;
25. }
26. }
27. }
29. return null ;
30. }
32. /**
33. * 判断指定的单元格是否是合并单元格
34. * @param sheet
35. * @param row
36. * @param column
37. * @return
38. */
39. public boolean isMergedRegion(Sheet sheet , int row , int column){
40. int sheetMergeCount = sheet.getNumMergedRegions();
42. for(int i = 0 ; i < sheetMergeCount ; i++ ){
43. CellRangeAddress ca = sheet.getMergedRegion(i);
44. int firstColumn = ca.getFirstColumn();
45. int lastColumn = ca.getLastColumn();
46. int firstRow = ca.getFirstRow();
47. int lastRow = ca.getLastRow();
49. if(row >= firstRow && row <= lastRow){
50. if(column >= firstColumn && column <= lastColumn){
52. return true ;
53. }
54. }
55. }
57. return false ;
58. }
60. /**
61. * 获取单元格的值
62. * @param cell
63. * @return
64. */
65. public String getCellValue(Cell cell){
67. if(cell == null) return "";
69. if(cell.getCellType() == Cell.CELL_TYPE_STRING){
71. return cell.getStringCellValue();
73. }else if(cell.getCellType() == Cell.CELL_TYPE_BOOLEAN){
75. return String.valueOf(cell.getBooleanCellValue());
77. }else if(cell.getCellType() == Cell.CELL_TYPE_FORMULA){
79. return cell.getCellFormula() ;
81. }else if(cell.getCellType() == Cell.CELL_TYPE_NUMERIC){
83. return String.valueOf(cell.getNumericCellValue());
85. }
87. return "";
88. }