使用Apache 的poi 对excel中的数据行和danyuange进行判断
/**
* 判断指定的单元格是否是合并单元格
*
* @param sheet
* @param row 行下标
* @param column 列下标
* @return
*/
public Map<String, String> isMergedRegion(Sheet sheet, int row, int column) {
Map<String, String> map = new HashMap<String, String>();
//判断结果
String flag = "false";
//当前行
String r = "-1";
//当前列
String c = "-1";
//最大row
String mr = row + "";
map.put("Row", r);
map.put("Col", c);
map.put("Result", flag);
map.put("MaxRow", mr);
// 得到一个sheet中有多少个合并单元格
int sheetMergeCount = sheet.getNumMergedRegions();
for (int i = 0; i < sheetMergeCount; i++) {
// 获取合并后的单元格
CellRangeAddress range = sheet.getMergedRegion(i);
int firstColumn = range.getFirstColumn();
int lastColumn = range.getLastColumn();
int firstRow = range.getFirstRow();
int lastRow = range.getLastRow();
if (row >= firstRow && row <= lastRow) {
if (column >= firstColumn && column <= lastColumn) {
flag = "true";
map.put("Row", firstRow + "");
map.put("Col", firstColumn + "");
map.put("Result", flag);
map.put("MaxRow", lastRow + "");
return map;
}
}
}
return map;
}
/**
* 判断指定的行是否是合并行以及最大行值
*
* @param sheet
* @param row 行下标
* @param column 列下标
* @return
*/
public Map<String, String> isMergedRow(Sheet sheet, int row, int column) {
Map<String, String> map = new HashMap<String, String>();
//判断结果
String flag = "false";
//最大row
String mr = row + "";
map.put("Results", flag);
map.put("MaxRow", mr);
// 得到一个sheet中有多少个合并单元格
int sheetMergeCount = sheet.getNumMergedRegions();
for (int i = 0; i < sheetMergeCount; i++) {
// 获取合并后的单元格
CellRangeAddress range = sheet.getMergedRegion(i);
int firstColumn = range.getFirstColumn();
int lastColumn = range.getLastColumn();
int firstRow = range.getFirstRow();
int lastRow = range.getLastRow();
if (row >= firstRow && row <= lastRow) {
if (column >= firstColumn && column <= lastColumn) {
flag = "true";
map.put("Results", flag);
map.put("MaxRow", lastRow + "");
return map;
}
}
}
return map;
}
/*********************************************************/
所需依赖
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi</artifactId>
<version>3.9</version>
</dependency>
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml</artifactId>
<version>3.9</version>
</dependency>
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml-schemas</artifactId>
<version>3.9</version>
</dependency>