代码
String filePath = "";
List<DetectWaterData> list = new ArrayList<>();
try {
XSSFWorkbook workbook = new XSSFWorkbook(filePath);
XSSFSheet sheet = workbook.getSheetAt(0);
int row_num = sheet.getPhysicalNumberOfRows();
int column_num = sheet.getRow(0).getPhysicalNumberOfCells();
System.out.println(row_num);
System.out.println(column_num);
for(int i =1;i <= row_num;i++) {
XSSFRow row = (XSSFRow) sheet.getRow(i);
if(row!=null) {
DetectWaterData detectwaterData = new DetectWaterData();
List<String> str = new ArrayList<>();
for (int j = 0; j < column_num; j++) {
Cell cell = row.getCell(j);
if(cell == null) {
str.add("");
}else {
str.add(cell.toString().trim());
}
}
detectwaterData.setDetect_positon(str.get(0));
detectwaterData.setDistance_of_water(str.get(1));
detectwaterData.setOrientation(str.get(2));
detectwaterData.setArea(str.get(3));
detectwaterData.setExplanation(str.get(4));
detectwaterData.setValidaton(str.get(5));
detectwaterData.setMemo(str.get(6));
list.add(detectwaterData);
}
}
workbook.close();