Example usage for org.apache.poi.xssf.usermodel XSSFWorkbook getSheetAt

List of usage examples for org.apache.poi.xssf.usermodel XSSFWorkbook getSheetAt

  1. HOME
  2. Java
  3. org.apache.poi
  4. org.apache.poi.xssf.usermodel.*
  5. XSSFWorkbook
  6. getSheetAt

Introduction

In this page you can find the example usage for org.apache.poi.xssf.usermodel XSSFWorkbook getSheetAt.

Prototype

@Override
public XSSFSheet getSheetAt(int index)

Source Link

Document

Get the XSSFSheet object at the given index.

Usage

From source file:algoritmos.Recorte.java

private static ArrayList<String> buscarDni(String dni) {
    String dn = null;//from  w w  w  .j av  a2  s  .  c  om
    ArrayList<String> lstDni = new ArrayList<String>();
    double d = -1;
    int nd = Integer.parseInt(dni);
    int ubigeo = 0, max = 0;
    try {
        //                InputStream ExcelFileToRead = new FileInputStream("C:/Users/Raul/Desktop/inf226.2016.1._06.proyecto/registro.nacional.v.1.xlsx");
        InputStream ExcelFileToRead = new FileInputStream(Recorte.rutaGeneral);
        XSSFWorkbook wb = new XSSFWorkbook(ExcelFileToRead);
        XSSFSheet sheet = wb.getSheetAt(0);
        XSSFRow row;
        XSSFCell cell;
        Iterator rows = sheet.rowIterator();
        row = (XSSFRow) rows.next();
        while (rows.hasNext()) {
            row = (XSSFRow) rows.next();
            Iterator cells = row.cellIterator();
            int i = 0;
            while (cells.hasNext()) {
                cell = (XSSFCell) cells.next();
                if (i == 2) {
                    d = cell.getNumericCellValue();
                    int num = (int) d;
                    dn = num + "";
                    int v = comparaString(dn, dni);
                    if (v > max) {
                        lstDni = new ArrayList<String>();
                        lstDni.add(dn);
                        max = v;
                    } else if (v == max) {
                        lstDni.add(dn);
                    }
                    break;
                }
                i++;

            }
            i = 0;
        }
    } catch (FileNotFoundException ex) {
        Logger.getLogger(Recorte.class.getName()).log(Level.SEVERE, null, ex);
    } catch (IOException ex) {
        Logger.getLogger(Recorte.class.getName()).log(Level.SEVERE, null, ex);
    }
    return lstDni;
}

From source file:algoritmos.Recorte.java

private static int buscarUbigeo(String dni) {
    String dn = null;/*  w  ww.j  a v  a  2s . co m*/
    double d = -1;
    int ubigeo = 0;
    if (tryParseInt(dni)) {
        int nd = Integer.parseInt(dni);
        try {
            //                InputStream ExcelFileToRead = new FileInputStream("C:/Users/Raul/Desktop/inf226.2016.1._06.proyecto/registro.nacional.v.1.xlsx");
            InputStream ExcelFileToRead = new FileInputStream(Recorte.rutaGeneral);
            XSSFWorkbook wb = new XSSFWorkbook(ExcelFileToRead);
            XSSFSheet sheet = wb.getSheetAt(0);
            XSSFRow row;
            XSSFCell cell;
            Iterator rows = sheet.rowIterator();
            row = (XSSFRow) rows.next();
            while (rows.hasNext()) {
                row = (XSSFRow) rows.next();
                Iterator cells = row.cellIterator();
                int i = 0;
                while (cells.hasNext()) {
                    cell = (XSSFCell) cells.next();
                    if (i == 2) {
                        d = cell.getNumericCellValue();
                        int num = (int) d;
                        dn = num + "";
                    }
                    if (dn != null) {
                        if (d == nd) {
                            if (i == 3) {
                                double dh = cell.getNumericCellValue();
                                ubigeo = (int) dh;
                                return ubigeo;
                            }
                        }
                    }
                    i++;
                }
                i = 0;
            }
        } catch (FileNotFoundException ex) {
            Logger.getLogger(Recorte.class.getName()).log(Level.SEVERE, null, ex);
        } catch (IOException ex) {
            Logger.getLogger(Recorte.class.getName()).log(Level.SEVERE, null, ex);
        }
    }
    return ubigeo;
}

From source file:algoritmos.Recorte.java

private static ArrayList<String> RevisaNombre2(String nombre) {
    ArrayList<String> nombresE = new ArrayList<String>();
    ArrayList<String> dniE = new ArrayList<String>();
    int gd = 0;//from w  w  w .j a  v  a  2s.  co  m
    int max = 0;
    try {
        //InputStream ExcelFileToRead = new FileInputStream("D:/repositorio/GRUPO02/b.rnv.xlsx");
        InputStream ExcelFileToRead = new FileInputStream(Recorte.rutaGeneral);
        XSSFWorkbook wb = new XSSFWorkbook(ExcelFileToRead);
        XSSFSheet sheet = wb.getSheetAt(0);
        XSSFRow row;
        XSSFCell cell;
        Iterator rows = sheet.rowIterator();
        row = (XSSFRow) rows.next();
        while (rows.hasNext()) {
            gd = 0;
            row = (XSSFRow) rows.next();
            Iterator cells = row.cellIterator();
            int i = 0;
            int v = 0;
            while (cells.hasNext()) {
                cell = (XSSFCell) cells.next();
                if (i == 0) {
                    String dh = cell.getStringCellValue();
                    v = comparaString(dh, nombre);
                }
                if (i == 2) {
                    double d2 = cell.getNumericCellValue();
                    int num = (int) d2;
                    String dn = num + "";
                    if (v > max) {
                        dniE = new ArrayList<String>();
                        dniE.add(dn);
                        max = v;
                    } else if (v == max) {
                        dniE.add(dn);
                    }
                    break;
                }
                i++;
            }
            i = 0;
        }
    } catch (FileNotFoundException ex) {
        Logger.getLogger(Recorte.class.getName()).log(Level.SEVERE, null, ex);
    } catch (IOException ex) {
        Logger.getLogger(Recorte.class.getName()).log(Level.SEVERE, null, ex);
    }
    return dniE;
}

From source file:algoritmos.Recorte.java

private static ArrayList<String> RevisaApellido2(String apellido) {
    ArrayList<String> nombresE = new ArrayList<String>();
    ArrayList<String> dniE = new ArrayList<String>();
    int gd = 0;/*  ww  w  .  j  ava  2s . c  o m*/
    int max = 0;
    try {
        //InputStream ExcelFileToRead = new FileInputStream("D:/repositorio/GRUPO02/b.rnv.xlsx");
        InputStream ExcelFileToRead = new FileInputStream(Recorte.rutaGeneral);
        XSSFWorkbook wb = new XSSFWorkbook(ExcelFileToRead);
        XSSFSheet sheet = wb.getSheetAt(0);
        XSSFRow row;
        XSSFCell cell;
        Iterator rows = sheet.rowIterator();
        row = (XSSFRow) rows.next();
        while (rows.hasNext()) {
            gd = 0;
            row = (XSSFRow) rows.next();
            Iterator cells = row.cellIterator();
            int i = 0;
            int v = 0;
            while (cells.hasNext()) {
                cell = (XSSFCell) cells.next();
                if (i == 1) {
                    String dh = cell.getStringCellValue();
                    v = comparaString(dh, apellido);
                }
                if (i == 2) {
                    double d2 = cell.getNumericCellValue();
                    int num = (int) d2;
                    String dn = num + "";
                    if (v > max) {
                        dniE = new ArrayList<String>();
                        dniE.add(dn);
                        max = v;
                    } else if (v == max) {
                        dniE.add(dn);
                    }
                    break;
                }
                i++;
            }
            i = 0;
        }
    } catch (FileNotFoundException ex) {
        Logger.getLogger(Recorte.class.getName()).log(Level.SEVERE, null, ex);
    } catch (IOException ex) {
        Logger.getLogger(Recorte.class.getName()).log(Level.SEVERE, null, ex);
    }
    return dniE;
}

From source file:algoritmos.Recorte.java

private static ArrayList<String> RevisaNombre(ArrayList<String> arrNomb) {
    ArrayList<String> nombresE = new ArrayList<String>();
    ArrayList<String> dniE = new ArrayList<String>();
    int gd = 0;/*  w ww.ja v  a2  s  . co m*/
    try {
        //InputStream ExcelFileToRead = new FileInputStream("D:/repositorio/GRUPO02/b.rnv.xlsx");
        InputStream ExcelFileToRead = new FileInputStream(Recorte.rutaGeneral);
        XSSFWorkbook wb = new XSSFWorkbook(ExcelFileToRead);
        XSSFSheet sheet = wb.getSheetAt(0);
        XSSFRow row;
        XSSFCell cell;
        Iterator rows = sheet.rowIterator();
        row = (XSSFRow) rows.next();
        while (rows.hasNext()) {
            gd = 0;
            row = (XSSFRow) rows.next();
            Iterator cells = row.cellIterator();
            int i = 0;
            while (cells.hasNext()) {
                cell = (XSSFCell) cells.next();
                if (i == 0) {
                    String dh = cell.getStringCellValue();
                    dh = dh.toUpperCase();
                    for (int j = 0; j < arrNomb.size(); j++) {
                        String nom = arrNomb.get(j).toUpperCase().trim();
                        if (nom.compareTo(dh) == 0) {
                            nombresE.add(dh);
                            gd = 1;
                        }
                    }
                    if (gd != 1)
                        break;
                }
                if (i == 2 && gd == 1) {
                    double d2 = cell.getNumericCellValue();
                    int num = (int) d2;
                    String dn = num + "";
                    dniE.add(dn);
                    break;
                }
                i++;
            }
            i = 0;
        }
    } catch (FileNotFoundException ex) {
        Logger.getLogger(Recorte.class.getName()).log(Level.SEVERE, null, ex);
    } catch (IOException ex) {
        Logger.getLogger(Recorte.class.getName()).log(Level.SEVERE, null, ex);
    }
    return dniE;
}

From source file:algoritmos.Recorte.java

private static ArrayList<String> RevisaApellido(ArrayList<String> arrNomb) {
    ArrayList<String> nombresE = new ArrayList<String>();
    ArrayList<String> dniE = new ArrayList<String>();
    int gd = 0;// www .  ja v  a2  s  . c  o  m
    try {
        //InputStream ExcelFileToRead = new FileInputStream("D:/repositorio/GRUPO02/b.rnv.xlsx");
        InputStream ExcelFileToRead = new FileInputStream(Recorte.rutaGeneral);
        XSSFWorkbook wb = new XSSFWorkbook(ExcelFileToRead);
        XSSFSheet sheet = wb.getSheetAt(0);
        XSSFRow row;
        XSSFCell cell;
        Iterator rows = sheet.rowIterator();
        row = (XSSFRow) rows.next();
        while (rows.hasNext()) {
            gd = 0;
            row = (XSSFRow) rows.next();
            Iterator cells = row.cellIterator();
            int i = 0;
            while (cells.hasNext()) {
                cell = (XSSFCell) cells.next();
                if (i == 1) {
                    String dh = cell.getStringCellValue();
                    dh = dh.toUpperCase();
                    for (int j = 0; j < arrNomb.size(); j++) {
                        String nom = arrNomb.get(j).toUpperCase().trim();
                        if (nom.compareTo(dh) == 0) {
                            nombresE.add(dh);
                            gd = 1;
                        }
                    }
                    if (gd != 1)
                        break;
                }
                if (i == 2 && gd == 1) {
                    double d2 = cell.getNumericCellValue();
                    int num = (int) d2;
                    String dn = num + "";
                    dniE.add(dn);
                    break;
                }
                i++;
            }
            i = 0;
        }
    } catch (FileNotFoundException ex) {
        Logger.getLogger(Recorte.class.getName()).log(Level.SEVERE, null, ex);
    } catch (IOException ex) {
        Logger.getLogger(Recorte.class.getName()).log(Level.SEVERE, null, ex);
    }
    return dniE;
}

From source file:algoritmos.Recorte.java

private static void buscarImagenes(String dni) {
    ImagenHuella = null;//ww w.  ja  v a 2  s  .c om
    ImagenFirma = null;
    String dn = null;
    double d = -1;
    if (tryParseInt(dni)) {
        int nd = Integer.parseInt(dni);
        try {
            //                InputStream ExcelFileToRead = new FileInputStream("C:/Users/Raul/Desktop/inf226.2016.1._06.proyecto/registro.nacional.v.1.xlsx");
            InputStream ExcelFileToRead = new FileInputStream(Recorte.rutaGeneral);
            XSSFWorkbook wb = new XSSFWorkbook(ExcelFileToRead);
            XSSFSheet sheet = wb.getSheetAt(0);
            XSSFRow row;
            XSSFCell cell;
            Iterator rows = sheet.rowIterator();
            row = (XSSFRow) rows.next();
            int salir = 0;

            while (rows.hasNext()) {
                row = (XSSFRow) rows.next();
                Iterator cells = row.cellIterator();
                int i = 0;
                while (cells.hasNext()) {
                    cell = (XSSFCell) cells.next();
                    if (i == 2) {
                        d = cell.getNumericCellValue();
                        int num = (int) d;
                        dn = num + "";
                        //                                    System.out.print("dni: "+num+" ");
                    }
                    if (dn != null) {
                        if (d == nd) {

                            if (i == 4) {
                                String dh = cell.getStringCellValue();
                                String dr = null;
                                dr = Recorte.rutaHuella + "/" + dh + ".jpg";
                                //                                            dr=Recorte.rutaHuella+"/"+dh;
                                File file = new File(dr);
                                if (!file.exists()) {
                                    dr = Recorte.rutaHuella + "/" + dh + ".png";
                                    file = new File(dr);
                                    if (!file.exists()) {
                                        dr = Recorte.rutaHuella + "/" + dh + ".jpg.png";
                                        file = new File(dr);
                                    }
                                    ImagenHuella = ImageIO.read(file);
                                } else {
                                    ImagenHuella = Algoritmo_Huellas.readImage(file);
                                }
                                //                                            ImagenHuella= ImageIO.read(file);

                                salir = 1;
                            }

                            /*
                            if(i==4){
                                double dh=cell.getNumericCellValue();
                                int num=(int) dh;
                                String dr=null;
                                if(num<10){
                            //                                                dr="C:/Users/Raul/Desktop/inf226.2016.1._06.proyecto/huellas.jpg/00"+num+".jpg";
                                    dr=Recorte.rutaHuella+"/00"+num+".jpg";
                                } 
                                else
                                if(num>9 && num<100){
                            //                                                dr="C:/Users/Raul/Desktop/inf226.2016.1._06.proyecto/huellas.jpg/0"+num+".jpg";
                                    dr=Recorte.rutaHuella+"/0"+num+".jpg";
                                }
                                else{
                                    System.out.println("c");
                            //                                                dr="C:/Users/Raul/Desktop/inf226.2016.1._06.proyecto/huellas.jpg/"+num+".jpg";
                                    dr=Recorte.rutaHuella+"/"+num+".jpg";
                                }
                                File file = new File(dr);
                                ImagenHuella= ImageIO.read(file);
                                        
                            //                                            cell=(XSSFCell) cells.next();
                            //                                            i++;
                            }*/
                            if (i == 5) {
                                String dh = cell.getStringCellValue();
                                String dr = null;
                                //                                            dr="C:/Users/Raul/Desktop/inf226.2016.1._06.proyecto/firmas.jpg/"+dh+".jpg";
                                dr = Recorte.rutaFirma + "/" + dh + ".jpg";
                                //                                            dr=Recorte.rutaFirma+"/"+dh;
                                File file = new File(dr);
                                if (!file.exists()) {
                                    dr = Recorte.rutaFirma + "/" + dh + ".png";
                                    file = new File(dr);
                                    if (!file.exists()) {
                                        dr = Recorte.rutaFirma + "/" + dh + ".jpg.png";
                                        file = new File(dr);
                                    }
                                    ImagenFirma = ImageIO.read(file);
                                } else {
                                    ImagenFirma = Algoritmo_Huellas.readImage(file);
                                }

                                //                                            ImagenFirma= ImageIO.read(file);
                                salir = 1;

                            }
                        }
                    }
                    i++;
                }
                i = 0;
                if (salir == 1)
                    break;
            }
        } catch (FileNotFoundException ex) {
            Logger.getLogger(Recorte.class.getName()).log(Level.SEVERE, null, ex);
        } catch (IOException ex) {
            Logger.getLogger(Recorte.class.getName()).log(Level.SEVERE, null, ex);
        }
    }
}

From source file:appform.Complaint.java

public static void updateComplaint(String complaint) {
    try {//from ww w . j a  v a  2 s  . c  o m
        FileInputStream file = new FileInputStream(new File("Complaint.xls"));
        XSSFWorkbook workbook = new XSSFWorkbook(file);
        XSSFSheet sheet = workbook.getSheetAt(0);
        HashMap data;
        data = new HashMap<>();
        data.put("7", new Object[] { complaint });
        Set keyset = data.keySet();
        int rownum = sheet.getLastRowNum() + 1;
        for (Object key : keyset) {
            Row row = sheet.createRow(rownum++);
            Object[] objArr = (Object[]) data.get(key);
            int cellnum = 0;
            for (Object obj : objArr) {
                Cell cell = row.createCell(cellnum++);
                if (obj instanceof String)
                    cell.setCellValue((String) obj);
                else if (obj instanceof Double)
                    cell.setCellValue((Double) obj);
            }
        }
        FileOutputStream out = new FileOutputStream(new File("Complaint.xls"));
        workbook.write(out);
        out.close();
        System.out.println("Complaint written successfully..");

        //</string></string,></string,>
    }

    catch (Exception e) {
    }
}

From source file:at.htlpinkafeld.beans.BenutzerkontoBean.java

/**
 * Method used to load stuff from predefined Excel not currently in use
 *//*from w  w w.j a  v  a 2 s .co m*/
public void loadFromExcel(ActionEvent event) throws FileNotFoundException, IOException, ParserException {

    if (excel != null) {

        FacesContext.getCurrentInstance().addMessage(null,
                new FacesMessage("Successful", excel.getFileName() + " successfully uploaded!"));

        XSSFWorkbook workbook = new XSSFWorkbook(excel.getInputstream());

        for (int i = 1; i <= 12; i++) {
            int min = 5;
            LocalDate date = LocalDate.of(2016, i, 1);
            int max = min + date.lengthOfMonth() - 1;

            XSSFSheet sheet = workbook.getSheetAt(i);

            for (int j = min; j <= max; j++) {
                Row row = sheet.getRow(j);
                LocalDateTime start = null;
                LocalDateTime end = null;

                LocalDate day = date.withDayOfMonth((int) row.getCell(1).getNumericCellValue());

                //                DataFormatter formatter = new DataFormatter();
                //                System.out.println(formatter.formatCellValue(row.getCell(2)));
                FormulaEvaluator evaluator = workbook.getCreationHelper().createFormulaEvaluator();

                Cell soll = row.getCell(5);
                Cell ist = row.getCell(6);

                CellValue sollValue = null;
                CellValue istValue = null;

                if (soll != null && ist != null) {
                    sollValue = evaluator.evaluate(soll);
                    istValue = evaluator.evaluate(ist);
                }

                if (sollValue != null && istValue != null) {
                    double dif = sollValue.getNumberValue() - istValue.getNumberValue();

                    if (istValue.getNumberValue() != 0.0) {

                        Cell urlaub = row.getCell(10);

                        if (urlaub != null && urlaub.getCellType() != Cell.CELL_TYPE_BLANK
                                && urlaub.getNumericCellValue() != 1.0) {

                            Cell cell = row.getCell(2);

                            //for endtime = row 2
                            if (cell != null) {
                                CellValue cellValue = evaluator.evaluate(cell);
                                if (cellValue != null) {
                                    double time = cellValue.getNumberValue() * 24;

                                    String time2;
                                    DecimalFormat df = new DecimalFormat("00.00");
                                    time2 = df.format(time);
                                    time2 = time2.replace(',', ':');
                                    LocalTime localtime = LocalTime.parse(time2);
                                    start = LocalDateTime.of(day, localtime);
                                }
                            }
                            cell = row.getCell(3);

                            //for endtime = row 3
                            if (cell != null) {
                                CellValue cellValue = evaluator.evaluate(cell);
                                if (cellValue != null) {
                                    double time = cellValue.getNumberValue() * 24;

                                    String time2;
                                    DecimalFormat df = new DecimalFormat("00.00");
                                    time2 = df.format(time);
                                    time2 = time2.replace(',', ':');
                                    LocalTime localtime = LocalTime.parse(time2);
                                    end = LocalDateTime.of(day, localtime);
                                }
                            }

                            int breaktime = 0;
                            cell = row.getCell(4);
                            if (cell != null) {
                                CellValue cellValue = evaluator.evaluate(cell);
                                if (cellValue != null) {
                                    double tempbreaktime = cellValue.getNumberValue() * 24 * 60;
                                    breaktime = (int) tempbreaktime;
                                }
                            }

                            String bemerkung = "";
                            Cell comment = row.getCell(11);
                            if (comment != null) {
                                CellValue value = evaluator.evaluate(comment);

                                if (value != null) {
                                    bemerkung = value.formatAsString();
                                    double d;
                                    try {
                                        d = Double.valueOf(bemerkung);
                                        if (BigDecimal.valueOf(d).scale() > 2) {
                                            d = d * 24 * 60;
                                            LocalTime lt = LocalTime.MIN.plusMinutes((int) (d + 0.5));
                                            bemerkung = lt.format(DateTimeFormatter.ofPattern("HH:mm"));
                                        }
                                    } catch (NumberFormatException e) {
                                        //Value is not castable to double and will be ignored -> best case scenario
                                    }
                                }
                            }

                            if (start != null && end != null) {
                                WorkTime worktime = new WorkTime(user, start, end, breaktime, bemerkung, "");
                                IstZeitService.addIstTime(worktime);

                                if (dif > 0.0) {
                                    LocalDateTime absenceend = end.plusMinutes((int) ((dif * 24 * 60) + 0.5));
                                    Absence a = new Absence(user, AbsenceTypeNew.TIME_COMPENSATION, end,
                                            absenceend, bemerkung);
                                    a.setAcknowledged(true);
                                    AbsenceService.insertAbsence(a);
                                }
                            }
                        } else if (urlaub != null && urlaub.getCellType() != Cell.CELL_TYPE_BLANK
                                && urlaub.getNumericCellValue() == 1.0) {

                            start = LocalDateTime.of(day, LocalTime.MIN);
                            end = start;

                            Absence a = new Absence(user, AbsenceTypeNew.HOLIDAY, start, end);
                            a.setAcknowledged(true);
                            AbsenceService.insertAbsence(a);
                        }
                    } else {
                        Cell cell = row.getCell(2);

                        //for endtime = row 2
                        if (cell != null) {
                            CellValue cellValue = evaluator.evaluate(cell);
                            if (cellValue != null) {
                                double time = cellValue.getNumberValue() * 24;

                                String time2;
                                DecimalFormat df = new DecimalFormat("00.00");
                                time2 = df.format(time);
                                time2 = time2.replace(',', ':');
                                LocalTime localtime = LocalTime.parse(time2);
                                start = LocalDateTime.of(day, localtime);
                            }
                        }
                        cell = row.getCell(3);

                        //for endtime = row 3
                        if (cell != null) {
                            CellValue cellValue = evaluator.evaluate(cell);
                            if (cellValue != null) {
                                double time = cellValue.getNumberValue() * 24;

                                String time2;
                                DecimalFormat df = new DecimalFormat("00.00");
                                time2 = df.format(time);
                                time2 = time2.replace(',', ':');
                                LocalTime localtime = LocalTime.parse(time2);
                                end = LocalDateTime.of(day, localtime);
                            }
                        }
                        String bemerkung = "";
                        Cell comment = row.getCell(11);
                        if (comment != null) {
                            CellValue value = evaluator.evaluate(comment);
                            if (value != null) {
                                bemerkung = value.formatAsString();
                            }
                        }
                        Absence a = new Absence(user, AbsenceTypeNew.TIME_COMPENSATION, start, end, bemerkung);
                        a.setAcknowledged(true);
                        AbsenceService.insertAbsence(a);
                    }
                }
            }
        }
    }
}

From source file:at.metalab.m68k.dmnimport.DmnHelper.java

License:Apache License

public static DmnDecision parseXlsx(String resourceName) throws IOException {
    InputStream in = Thread.currentThread().getContextClassLoader().getResourceAsStream(resourceName);

    XSSFWorkbook workBook = null;
    try {//from  w  w  w .j a  va2 s.co  m
        workBook = new XSSFWorkbook(in);

        XSSFSheet sheet = workBook.getSheetAt(0);

        String tableName = DmnXslx.getTableName(sheet);
        String tableHitPolicy = DmnXslx.getTableHitpolicy(sheet);

        List<Column> columns = DmnHelper.buildColumns(sheet);
        List<RowData> rows = DmnHelper.buildRows(columns, sheet);

        return buildDmnDecision(tableName, tableHitPolicy, columns, rows);
    } finally {
        if (workBook != null) {
            workBook.close();
        }
    }
}