poiexcel 读取引用列_java – 使用Apache POI如何读取特定的excel列

heikkim是对的,这里是一些从我的一些代码改编的示例代码：

import org.apache.poi.ss.usermodel.Cell;

import org.apache.poi.ss.usermodel.Sheet;

import org.apache.poi.ss.usermodel.Row;

...

for (int rowIndex = 0; rowIndex <= sheet.getLastRowNum(); rowIndex++) {

row = sheet.getRow(rowIndex);

if (row != null) {

String cellValueMay = null;

for (int colIndex = 0; colIndex < colCount; colIndex++) {

if (colIndex == theColIndexYouWant) {

cell = row.getCell(colIndex);

if (cell != null) {

// Found column and there is value in the cell.

cellValueMaybeNull = cell.getStringCellValue();

break;

}

}

// Do something with the cellValueMaybeNull here ...

}

}

对于colCount,使用像row.getPhysicalNumberOfCells()