import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
String fileinfo = "E:\\111\\111.xlsx";
FileInputStream fileInputStream = null;
try {
fileInputStream = new FileInputStream(fileinfo);
XSSFWorkbook sheets = new XSSFWorkbook(fileInputStream);
//获取sheet
XSSFSheet sheet = sheets.getSheet("Sheet1");
// 获取行数
int rows = sheet.getPhysicalNumberOfRows();
// 遍历行数 行数是从 第一行开始
for (int i = 1; i < rows; i++) {
//获取 每一行
XSSFRow row = sheet.getRow(i);
// 获取第五列 从第0列开始
XSSFCell cell1 = row.getCell(5);
XSSFCell cell2 = row.getCell(8);
System.out.println(cell1.toString().split("\\.")[0]);
System.out.println( cell2.toString());
}
} catch (Exception e) {
e.printStackTrace();
}
读取到的数字有可能excle里面是1111,但是读取出来是1111.0 那么我们就可以使用
cell1.toString().split("\\.")[0]