File file = new File("E:\\b.xlsx");//需要读取的xlsx文件
InputStream is;
try {
is = new FileInputStream(file);
XSSFWorkbook xssfWorkbook = new XSSFWorkbook(is);
// 获取每一个工作薄
for (int numSheet = 0; numSheet < xssfWorkbook.getNumberOfSheets(); numSheet++) {
XSSFSheet xssfSheet = xssfWorkbook.getSheetAt(numSheet);
if (xssfSheet == null) {//为空不执行下面
continue;
}
// 获取当前工作薄的每一行
for (int rowNum = 1; rowNum <= xssfSheet.getLastRowNum(); rowNum++) {
XSSFRow xssfRow = xssfSheet.getRow(rowNum);
if (xssfRow != null) {
//读取第一列数据
XSSFCell one = xssfRow.getCell(0);
//读取第二列数据
XSSFCell two = xssfRow.getCell(1);
//读取第三列数据
XSSFCell three = xssfRow.getCell(2);
//这里就是转换的函数,new DecimalFormat对象
DecimalFormat format = new DecimalFormat("#");
//数字
String num = format.format(three.getNumericCellValue());
}
}
}
is.close();
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
读取xlsx文件
最新推荐文章于 2024-07-17 19:57:19 发布