java - 使用Java从Excel读取数据时如何仅提取整数值而不是Double值

Question

我需要一个代码，它应该从 Excel 获取数据作为 int 值而不是 String 值。

它显示的值2.0最初在工作表中保存为2`

尝试1:

HSSFCell number = sheet.getRow(1).getCell(26);
Integer result =Integer.valueOf(number);                
System.out.println(result);

尝试 2:

int L = Integer.parseInt(getRow(1).getCell(26));

Error:The method parseInt(String) in the type Integer is not applicable for the arguments (Cell)

代码:

System.out.println(+sheet.getRow(1).getCell(26));

输出:2.0

预期输出:2

Answer 1

我推荐以下方法，它不会尝试将 HSSFCell 转换为 Integer/int:

// get the cell as object (this is NOT a number, instead, it contains one)
HSSFCell numberCell = sheet.getRow(1).getCell(26);
// get the cell value as double (there is no direct integer version)
double cellValue = numberCell.getNumericCellValue();
// cast the value to an int
int number = (int) cellValue;