public class ReadExcelFileAndStore {

    public List getTheFileAsObject(String filePath){
        List <Employee> employeeList = new ArrayList<>();
        try {
            FileInputStream file = new FileInputStream(new File(filePath));

            // Get the workbook instance for XLS file
            HSSFWorkbook workbook = new HSSFWorkbook(file);

            int numberOfSheets = workbook.getNumberOfSheets();
            //System.out.println(numberOfSheets);
            //loop through each of the sheets
           for(int i = 0; i < numberOfSheets; i++) {

               // Get first sheet from the workbook
               HSSFSheet sheet = workbook.getSheetAt(i);
               String sheetName = workbook.getSheetName(i);

               // Iterate through each rows from first sheet
               Iterator <Row> rowIterator = sheet.rowIterator();
               Row headerRow= rowIterator.next();

               while (rowIterator.hasNext()) {

                   // Get Each Row
                   Row row = rowIterator.next();

                   // For each row, iterate through each columns
                   Iterator<Cell> cellIterator = row.cellIterator();

                   Employee employee = new Employee();

                   while (cellIterator.hasNext()) {

                       Cell cell = cellIterator.next();

                       int columnIndex = cell.getColumnIndex();

                       switch (columnIndex + 1) {

                           case 1:
                               employee.setEmpName(cell.getStringCellValue());
                               break;
                           case 2:
                               employee.setExtCode((int) cell.getNumericCellValue());
                               break;
                       }
                   }
                   employeeList.add(employee);
               }
           }
            file.close();
        } catch (FileNotFoundException e) {
            e.printStackTrace();
        } catch (IOException e) {
            e.printStackTrace();
        }
        return employeeList;
    }
}