java excel 列,使用Java读取Excel工作表的单列

I have an excel sheet. I want to write a method which takes parameter as column number that to be read and return a array consist of all the data in that column.

And then to place that column element in xml sheet. How can I write a method to do that?

解决方案

Use Apache POI. You can find example in their usage page.

Sheet sheet1 = wb.getSheetAt(0);

for (Row row : sheet1) {

for (Cell cell : row) {

// Here you might have to use the cell number to limit what you want.

CellReference cellRef = new CellReference(row.getRowNum(), cell.getCellNum());

System.out.print(cellRef.formatAsString());

System.out.print(" - ");

switch(cell.getCellType()) {

case Cell.CELL_TYPE_STRING:

System.out.println(cell.getRichStringCellValue().getString());

break;

case Cell.CELL_TYPE_NUMERIC:

if(DateUtil.isCellDateFormatted(cell)) {

System.out.println(cell.getDateCellValue());

} else {

System.out.println(cell.getNumericCellValue());

}

break;

case Cell.CELL_TYPE_BOOLEAN:

System.out.println(cell.getBooleanCellValue());

break;

case Cell.CELL_TYPE_FORMULA:

System.out.println(cell.getCellFormula());

break;

default:

System.out.println();

}

}

}