Example usage for org.apache.poi.ss.usermodel Workbook getNumberOfSheets

Introduction

In this page you can find the example usage for org.apache.poi.ss.usermodel Workbook getNumberOfSheets.

Prototype

int getNumberOfSheets();

Source Link

Document

Get the number of spreadsheets in the workbook

Usage

From source file:net.ceos.project.poi.annotated.core.CascadeTest.java

License:Apache License

/**
 * Test cascade type CASCADE_L3/* w  ww  .  j  a v a2s.c  o  m*/
 * 
 * @throws WorkbookException
 */
@Test
public void checkCascadeTypeLevelThree() throws WorkbookException {
    CascadeObject cascadeObj = CascadeObjectBuilder.buildCascadeObject();

    XConfigCriteria criteria = new XConfigCriteria();
    criteria.overrideCascadeLevel(CascadeType.CASCADE_L3);

    IEngine en = new Engine();
    Workbook wb = en.marshalToWorkbook(criteria, cascadeObj);

    assertNotNull(wb);
    assertNotNull(wb.getSheet("Cascade analyser"));
    assertNotNull(wb.getSheet("Basic object"));
    assertNotNull(wb.getSheet("Decorators"));
    assertNotNull(wb.getSheet("Cascade L1"));
    assertNotNull(wb.getSheet("Cascade L2"));
    assertNotNull(wb.getSheet("Cascade L3"));
    assertEquals(wb.getNumberOfSheets(), 6);
}

---

From source file:net.ceos.project.poi.annotated.core.CascadeTest.java

License:Apache License

/**
 * Test cascade type CASCADE_FULL//from w w  w  .  ja v a 2  s.  c  o  m
 * 
 * @throws WorkbookException
 */
@Test
public void checkCascadeTypeFull() throws WorkbookException {
    CascadeObject cascadeObj = CascadeObjectBuilder.buildCascadeObject();

    XConfigCriteria criteria = new XConfigCriteria();
    criteria.overrideCascadeLevel(CascadeType.CASCADE_FULL);

    IEngine en = new Engine();
    Workbook wb = en.marshalToWorkbook(criteria, cascadeObj);

    assertNotNull(wb);
    assertNotNull(wb.getSheet("Cascade analyser"));
    assertNotNull(wb.getSheet("Basic object"));
    assertNotNull(wb.getSheet("Decorators"));
    assertNotNull(wb.getSheet("Cascade L1"));
    assertNotNull(wb.getSheet("Cascade L2"));
    assertNotNull(wb.getSheet("Cascade L3"));
    assertEquals(wb.getNumberOfSheets(), 6);
}

---

From source file:net.cpollet.jixture.fixtures.transformers.ExcelFileFixtureTransformer.java

License:Apache License

@Override
protected List<Object> parse(From fixture) {
    InputStream inputStream = fixture.getInputStream();
    Workbook workbook = createWorkbook(inputStream);

    DataFormatter dataFormatter = new DataFormatter();
    FormulaEvaluator evaluator = workbook.getCreationHelper().createFormulaEvaluator();

    List<Object> mappings = new LinkedList<Object>();
    Helpers helpers = new Helpers();
    helpers.dataFormatter = dataFormatter;
    helpers.evaluator = evaluator;/*from   w ww  .  jav a  2 s  .com*/

    Parameters parameters = new Parameters();
    parameters.mode = fixture.getMode();

    for (int sheetIndex = 0; sheetIndex < workbook.getNumberOfSheets(); sheetIndex++) {
        Sheet sheet = workbook.getSheetAt(sheetIndex);

        mappings.addAll(parseSheet(sheet, helpers, parameters));
    }

    return mappings;
}

---

From source file:net.pcal.sqlsheet.XlsStatement.java

License:Apache License

private static Sheet getSheetNamed(Workbook wb, String name) throws SQLException {
    if (name == null)
        throw new IllegalArgumentException();
    name = name.trim();//  w  ww.  ja  v  a 2s.co  m
    String allSheetNames = "";
    int count = wb.getNumberOfSheets();
    for (int i = 0; i < count; i++) {
        String sheetName = wb.getSheetName(i);
        allSheetNames += sheetName + ",";
        if (sheetName == null)
            continue;
        if (sheetName.equalsIgnoreCase(name) || ("\"" + sheetName + "\"").equalsIgnoreCase(name)) {
            return wb.getSheetAt(i);
        }
    }

    String message = "No sheet named '" + name;
    if (count == 0) {
        message += " can be found. Are you sure of the Excel file path ?";
    } else {
        if (allSheetNames.length() > 2) {
            allSheetNames = allSheetNames.substring(0, allSheetNames.length() - 1);
        }
        message += ". Only the following " + count + " sheets can be found (" + allSheetNames + ")";
    }
    throw new SQLException(message);
}

---

From source file:net.sf.excelutils.ExcelUtils.java

License:Apache License

/**
 * parse workbook/*from   w  w  w  .  j a  v a  2s.  c  o m*/
 * 
 * @param context
 * @param wb
 * @throws ExcelException
 */
public static void parseWorkbook(Object context, Workbook wb) throws ExcelException {
    try {
        int sheetCount = wb.getNumberOfSheets();
        for (int sheetIndex = 0; sheetIndex < sheetCount; sheetIndex++) {
            Sheet sheet = wb.getSheetAt(sheetIndex);
            parseSheet(context, wb, sheet);
            // set print area
            WorkbookUtils.setPrintArea(wb, sheetIndex);
        }
    } catch (Exception e) {
        throw new ExcelException("parseWorkbook error: ", e);
    }
}

---

From source file:net.sf.excelutils.ExcelUtils.java

License:Apache License

/**
 * parse Workbook/*from   www .  j  av a 2s .c  om*/
 * 
 * @param context
 * @param wb
 * @param sheetIndex
 * @throws ExcelException
 */
public static void parseWorkbook(Object context, Workbook wb, int sheetIndex) throws ExcelException {
    try {
        Sheet sheet = wb.getSheetAt(sheetIndex);
        if (null != sheet) {
            parseSheet(context, wb, sheet);
            // set print area
            WorkbookUtils.setPrintArea(wb, sheetIndex);
        }

        int i = 0;
        while (i++ < sheetIndex) {
            wb.removeSheetAt(0);
        }

        i = 1;
        while (i < wb.getNumberOfSheets()) {
            wb.removeSheetAt(i);
        }
    } catch (Exception e) {
        throw new ExcelException("parseWorkbook error: ", e);
    }
}

---

From source file:net.sf.excelutils.WorkbookUtils.java

License:Apache License

public static int getSheetIndex(Workbook wb, Sheet sheet) {
    // faint, sheet can not get self index, must search
    int sheetIndex = -1;
    for (int i = 0; i < wb.getNumberOfSheets(); i++) {
        Sheet s = wb.getSheetAt(i);/*from   ww  w .  java  2s  .c o  m*/
        if (sheet.equals(s)) {
            sheetIndex = i;
            break;
        }
    }
    return sheetIndex;
}

---

From source file:nl.detoren.ijsco.io.ExcelImport.java

License:Open Source License

public GroepsUitslagen importeerUitslagen(File file) {

    GroepsUitslagen groepen = new GroepsUitslagen();
    try {/*ww  w.  j a  v  a  2s . co m*/

        FileInputStream excelFile = new FileInputStream(file);
        Workbook workbook = new XSSFWorkbook(excelFile);
        String versie = "onbekend";
        Sheet sheet = workbook.getSheet("Configuratie");
        try {
            versie = sheet.getRow(0).getCell(1).getStringCellValue();
        } catch (Exception ex) {
            logger.log(Level.INFO, "Indelings Excel versie ophalen mislukt");
        }
        logger.log(Level.INFO, "Indelings Excel is versie " + versie);
        for (int i = 0; i < workbook.getNumberOfSheets(); i++) {
            sheet = workbook.getSheetAt(i);
            if (sheet.getSheetName().startsWith("Groep ")) {
                logger.log(Level.INFO, "Importeer uitslag van groep : " + sheet.getSheetName());
                Row row = sheet.getRow(0);
                if (row != null) {
                    Cell cell = row.getCell(0);
                    if (cell != null) {
                        int groepsgrootte = (int) cell.getNumericCellValue();
                        logger.log(Level.INFO, "Groepsgrootte is " + groepsgrootte);
                        switch (groepsgrootte) {
                        case 4:
                            groepen.Add(importeerGroep4(sheet));
                            break;
                        case 6:
                            groepen.Add(importeerGroep6(sheet));
                            break;
                        case 8:
                            groepen.Add(importeerGroep8(sheet));
                            break;
                        case 10:
                            groepen.Add(importeerGroep10(sheet));
                            break;
                        default:
                            logger.log(Level.WARNING, "Uitslagen verwerken voor groepsgrootte " + groepsgrootte
                                    + " niet ondersteund!");
                            break;
                        }
                    }
                }
                logger.log(Level.INFO, "next");
            }
        }
        workbook.close();
    } catch (Exception ex) {
        logger.log(Level.SEVERE, "Exception! Cause: " + ex.getCause() + ". Internal error is " + ex.getMessage()
                + ". Stracktrace: \r\n" + Utils.stackTraceToString(ex));
    }
    // Print resultaat;
    logger.log(Level.INFO, groepen.toString());
    return groepen;
}

---

From source file:Opm_Package.Merger_Class.java

private int getWorksheets() throws Exception {
    Workbook workbook = openFile.readFileName(file);
    int sheetCounts = workbook.getNumberOfSheets();
    return sheetCounts;
}

---

From source file:optimizador.optimizadordirecciones.co.com.optimizador.util.LeerExcel.java

/**
 * Lee un archivo y lo convierte en objetos RuteroVO.
 * /*from   ww  w  . java2 s . co m*/
 * @param fileName
 *            el nombre del archivo.
 * @return la lista de objetos.
 */
public ArrayList<Predio> readExcelData(String fileName) {
    // Se crea un arraylist para guadar las consulta de las celdas
    // del archivo excel.
    // Y un objeto ruteroVO par guardadr la imagen exacta del archivo
    ArrayList<Predio> ruteros = new ArrayList<>();
    Predio ruteroIni;
    FileInputStream fis = null;

    try {
        // Crea stream de entrada para un archivo xlsx/xls
        fis = new FileInputStream(fileName);
        // Se crea una instancia Workbook para manejar el archivo xlsx/xls
        // Se pregunta si el archivo a leer es xlsx o xls para instanciar
        // la clase correspondiente
        Workbook workbook = getWorkbook(fis, fileName);

        // Se obtiene la cantidad de libros que tiene el archivo excel
        int numberOfSheets = workbook.getNumberOfSheets();

        // interacion a traves de cada libro
        for (int i = 0; i < numberOfSheets; i++) {

            // Se obtiene el libro
            Sheet sheet = (Sheet) workbook.getSheetAt(i);

            // Se crear iterador para seleccionar las filas de la
            // hoja del libro seleccionado
            Iterator<Row> rowIterator = sheet.iterator();

            while (rowIterator.hasNext()) {
                if (idRow == 0) { // Para quitar lafila de titulos
                    idRow = 1;
                    rowIterator.next();
                } else {
                    // Se ontiene la fila dentro de un objeto Row
                    Row row = rowIterator.next();
                    // Se crea iterador para las columnas resultando
                    // una celda
                    Iterator<Cell> cellIterator = row.cellIterator();
                    ruteroIni = new Predio();
                    while (cellIterator.hasNext()) {
                        // Se obtiene una celda dentro de un objeto
                        // Cell
                        Cell cell = cellIterator.next();
                        asignarDatos(ruteroIni, cell);
                    } // Final del iterador de celda
                    ruteros.add(ruteroIni);
                    ruteros = obtenerCoordenadas(ruteros);

                }
            } // Final del iterador fila
        } // Final del Loop hoja
    } catch (IOException e) {
        LOGGER.error(e.getMessage(), e);
    } finally {
        if (fis != null) {
            try {
                fis.close();
            } catch (IOException e) {
                LOGGER.error(e.getMessage(), e);
            }
        }
    }
    idRow = 0;

    return ruteros;
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• 23
• 24
• 25
• 26
• »