java - 数据驱动 Selenium 获取异常 java.lang.NumberFormatException:对于输入字符串:“3.0”
问题描述
下面是我在 selenium 中使用 excel 驱动的数据的代码。使用此代码,我得到异常 java.lang.NumberFormatException: For input string: "3.0"
public String[][] getDataFromSheet(String excelfilename,String sheetName) {
String datasets[][] = null;
try {
XSSFSheet sheet = workbook.getSheet(sheetName);
int totalRow = sheet.getLastRowNum() + 1;
int totalCol = sheet.getRow(0).getLastCellNum();
datasets = new String[totalRow - 1][totalCol];
for (int i = 1; i < totalRow; i++) {
XSSFRow rows = sheet.getRow(i);
for (int j = 0; j < totalCol; j++) {
XSSFCell cell = rows.getCell(j);
if (cell.getCellTypeEnum() == CellType.STRING) {
datasets[i - 1][j] = cell.getStringCellValue();
}
else if (cell.getCellTypeEnum() == CellType.NUMERIC) {
String cellText = String.valueOf(cell.getNumericCellValue());
datasets[i - 1][j] = cellText;
} else {
datasets[i - 1][j] = String.valueOf(cell.getBooleanCellValue());
}
}
}
return datasets;
} catch (Exception e) {
return datasets;
}
}
解决方案
测试此代码以读取 excel 文件并根据您的要求进行设置。
public class Test {
public static void main(String[] args) {
try {
//Path Of your File Enter here
InputStream ExcelFileToRead = new FileInputStream("/home/chavdaan01/Desktop/Aniruddh.xlsx");
XSSFWorkbook workbook = new XSSFWorkbook(ExcelFileToRead);
XSSFSheet sheet = workbook.getSheetAt(0);
XSSFRow row;
XSSFCell cell;
//int break_down=sheet.getPhysicalNumberOfRows();
Iterator rows = sheet.rowIterator();
int i = 0;
while (rows.hasNext())
{
row=(XSSFRow) rows.next();
Iterator cells = row.cellIterator();
int j = 1;
while (cells.hasNext())
{
cell=(XSSFCell) cells.next();
if (cell.getCellType() == XSSFCell.CELL_TYPE_STRING) {
System.out.println(cell.getStringCellValue());
} else if (cell.getCellType() == XSSFCell.CELL_TYPE_NUMERIC) {
System.out.println(cell.getNumericCellValue());
}else if(cell.getCellType() == XSSFCell.CELL_TYPE_BOOLEAN) {
System.out.println(cell.getBooleanCellValue());
}
}
}
} catch (Exception e) {
}
}
}
推荐阅读
- spring-boot - ErrorWebFluxAutoConfiguration 不尊重 ErrorWebExceptionHandler 类型的 Application 中的 bean
- javascript - Moment js 跨时区的日期值比较
- typescript - 是否可以使用联合 @Field 创建 @ArgType
- game-maker - 跳转缓冲区不能很好地与变量跳转
- javascript - 用户登录后如何在passport.authenticate(本地)中返回用户对象?
- c# - 在一个线程中发送数据是错误的吗?
- vue.js - 我们是否应该将 mixin 转换为 Vue 3 中基于类的组件定义语法?
- wordpress - 如何获取角色等于无的所有用户的列表
- python-3.x - 嵌套 FOR 循环为大字符串值提供超时错误 - Python
- mongodb - MongoDB select distinct where not in select distinct