poiexcel 读取引用列_java怎么导入excel-Java POI读取Excel的时候怎么按列读取

Java POI读取Excel的时候怎么按列读取

按列读取的方法：

String pathname = "E:\\files\\title.xlsx";

File file = new File(pathname);

InputStream in = new FileInputStream(file);

//得到整个excel对象

XSSFWorkbook excel = new XSSFWorkbook(in);

//获取整个excel有多少个sheet

int sheets = excel.getNumberOfSheets();

//便利个sheet

Map colMap = new HashMap();

for(int i = 0 ; i < sheets ; i ){

XSSFSheet sheet = excel.getSheetAt(i);

if(sheet == null){

continue;

}

int mergedRegions = sheet.getNumMergedRegions();

XSSFRow row2 = sheet.getRow(0);

Map category = new HashMap();

for(int j = 0 ; j < mergedRegions; j ){

CellRangeAddress rangeAddress = sheet.getMergedRegion(j);

int firstRow = rangeAddress.getFirstColumn();

int lastRow = rangeAddress.getLastColumn();

category.put(rangeAddress.getFirstColumn(), rangeAddress.getLastColumn() "-" row2.getCell(firstRow).toString());

}

//便利每一行

for( int rowNum = 1 ; rowNum <= sheet.getLastRowNum() ; rowNum ){

System.out.println();

XSSFRow row = sheet.getRow(rowNum);

if(row == null){

continue;

}

short lastCellNum = row.getLastCellNum();

String cate = "";

Integer maxIndex = 0;

for( int col = row.getFirstCellNum() ; col < lastCellNum ; col ){

XSSFCell cell = row.getCell(col);

if(cell == null ){

continue;

}

if("".equals(cell.toString())){

continue;

}

int columnIndex = cell.getColumnIndex();

String string = category.get(columnIndex);

if(string != null