packagecom.util;import org.apache.poi.ss.usermodel.*;importorg.apache.poi.ss.util.CellRangeAddress;importjava.io.File;importjava.io.FileInputStream;importjava.io.FileNotFoundException;importjava.io.InputStream;importjava.util.ArrayList;importjava.util.List;public classExcelUtil {/*** 判断指定的单元格是否是合并单元格
*
*@paramsheet
*@paramrow 行下标
*@paramcolumn 列下标
*@return
*/
public static boolean isMergedRegion(Sheet sheet, int row, intcolumn) {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