java读取复杂Excel_读取Excel复杂的数据

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