1XSSFWorkbook workbook = new XSSFWorkbook(new File(result));
2 XSSFSheet sheet = workbook.getSheetAt(0);
3
4 // Iterate through each rows one by one
5 Iterator<Row> rowIterator = sheet.iterator();
6 while (rowIterator.hasNext()) {
7 Row row = rowIterator.next();
8 // For each row, iterate through all the columns
9 Iterator<Cell> cellIterator = row.cellIterator();
10
11 while (cellIterator.hasNext()) {
12 Cell cell = cellIterator.next();
13 switch (cell.getCellType()) {
14 case Cell.CELL_TYPE_NUMERIC:
15 if (cell.getNumericCellValue() != 0) {
16 //Get date
17 Date date = row.getCell(0).getDateCellValue();
18
19
20
21 //Get datetime
22 cell.getDateCellValue()
23
24
25 System.out.println(date.getTime());
26 }
27 break;
28 }
29 }
30 }