java cellvalue_Java Cell.getCellFormula方法代码示例

import org.apache.poi.ss.usermodel.Cell; //导入方法依赖的package包/类

private List> read(Workbook wb, int sheetIndex) {

List> dataLst = Lists.newArrayList();

Sheet sheet = wb.getSheetAt(sheetIndex);

this.totalRows = sheet.getPhysicalNumberOfRows();

if ((this.totalRows >= 1) && (sheet.getRow(0) != null)) {

this.totalCells = sheet.getRow(0).getLastCellNum(); // 获取最后一个不为空的列是第几个

}

for (int r = 0; r < this.totalRows; r++) {

Row row = sheet.getRow(r);

if (row != null) {

List rowLst = Lists.newArrayList();

for (int c = 0; c < getTotalCells(); c++) {

Cell cell = row.getCell(c);

String cellValue = "";

if (cell != null) {

switch (cell.getCellType()) {

case 0:

if (HSSFDateUtil.isCellDateFormatted(cell)) {

Date date = cell.getDateCellValue();

cellValue = DateUtils.dateToStr(date,

"yyyy-MM-dd HH:mm:ss");

} else {

Integer num = (int) cell.getNumericCellValue();

cellValue = String.valueOf(num);

}

break;

case 1:

cellValue = cell.getStringCellValue().trim();

break;

case 4:

cellValue = String.valueOf(cell.getBooleanCellValue());

break;

case 2:

cellValue = cell.getCellFormula();

break;

case 3:

cellValue = "";

break;

case 5:

cellValue = "非法字符";

break;

default:

cellValue = "未知类型";

}

}

rowLst.add(cellValue);

}

dataLst.add(rowLst);

}

}

return dataLst;

}