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

Introduction

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

Prototype

Sheet getSheet(String name);

Source Link

Document

Get sheet with the given name

Usage

From source file:net.bafeimao.umbrella.support.data.entity.ExcelEntityParser.java

License:Apache License

/**
 * Excel?Sheet???,?clazz//from   www  .  j  ava2s. com
 * <p/>
 * TODO {@link PrintExecutionTime}?AOP?
 */
@Override
@PrintExecutionTime
public <E extends DataEntity> LinkedList<E> parse(Class<E> entityClass) throws EntityParseException {
    LinkedList<E> entities = null;
    InputStream inputStream = null;

    try {
        ExcelMapping mapping = entityClass.getAnnotation(ExcelMapping.class);
        String fileName = "e:\\" + mapping.file();
        String sheetName = mapping.sheet();

        inputStream = new FileInputStream(fileName); // FileInputStream?Excel?
        Workbook wb = WorkbookFactory.create(inputStream); // Workbook,?excelsheet

        if (wb != null && wb.getNumberOfSheets() > 0) {
            Sheet sheet = wb.getSheet(sheetName);

            // ???
            if (sheet.getRow(0) != null) {
                entities = parse0(entityClass, sheet);
            }
        }
    } catch (Exception e) {
        LOGGER.error("{}", e);
    } finally {
        try {
            if (inputStream != null)
                inputStream.close();
        } catch (IOException e) {
            LOGGER.error("{}", e);
        }
    }

    return entities;
}

---

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

License:Apache License

/**
 * Test cascade type CASCADE_BASE/*  ww w.j  a  v  a2 s  .  com*/
 * 
 * @throws WorkbookException
 */
@Test
public void checkCascadeTypeBase() throws WorkbookException {
    CascadeObject cascadeObj = CascadeObjectBuilder.buildCascadeObject();

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

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

    assertNotNull(wb);
    assertNotNull(wb.getSheet("Cascade analyser"));
    assertEquals(wb.getNumberOfSheets(), 1);
}

---

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

License:Apache License

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

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

    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"));
    assertEquals(wb.getNumberOfSheets(), 4);
}

---

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

License:Apache License

/**
 * Test cascade type CASCADE_L2//from w  w w.  java 2s .  c  om
 * 
 * @throws WorkbookException
 */
@Test
public void checkCascadeTypeLevelTwo() throws WorkbookException {
    CascadeObject cascadeObj = CascadeObjectBuilder.buildCascadeObject();

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

    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"));
    assertEquals(wb.getNumberOfSheets(), 5);
}

---

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

License:Apache License

/**
 * Test cascade type CASCADE_L3//from  w  ww.  j  av a 2  s.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  ww . j  a  v a 2  s  .co 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.sibcolombia.sibsp.service.portal.implementation.ResourceManagerImplementation.java

License:Creative Commons License

private void readAdditionalMetadata(Eml eml, Workbook template) throws InvalidFormatException {
    Sheet sheet = template.getSheet("Metadatos Adicionales");
    DateFormat dateFormatA = new SimpleDateFormat("MM/dd/yyyy");
    DateFormat dateFormatB = new SimpleDateFormat("yyyy-MM-dd");
    eml.setHierarchyLevel(readCellValue(sheet.getRow(5).getCell(1)));
    eml.setLogoUrl(readCellValue(sheet.getRow(7).getCell(1)));
    try {//  w  w w  .  ja  v  a 2  s  . c om
        if (readCellValue(sheet.getRow(5).getCell(4)).matches("\\d{4}-\\d{2}-\\d{2}")) {
            eml.setPubDate(dateFormatB.parse(readCellValue(sheet.getRow(5).getCell(4))));
        } else if (readCellValue(sheet.getRow(5).getCell(4)).matches("\\d{2}/\\d{2}/\\d{4}")) {
            eml.setPubDate(dateFormatA.parse(readCellValue(sheet.getRow(5).getCell(4))));
        } else {
            throw new InvalidFormatException("Error al procesar fecha inicial y final en cobertura temporal: ");
        }
    } catch (ParseException e) {
        throw new InvalidFormatException("Error al procesar fecha inicial y final en cobertura temporal: " + e);
    }
    eml.setPurpose(readCellValue(sheet.getRow(9).getCell(1)));
    switch (readCellValue(sheet.getRow(11).getCell(1))) {
    case "Ningna licencia seleccionada":
        eml.setIntellectualRights(readCellValue(sheet.getRow(12).getCell(1)));
        break;
    case "Creative Commons CCZero":
        eml.setIntellectualRights(baseAction.getText("eml.intellectualRights.license.cczero.text"));
        break;
    case "Open Data Commons Public Domain Dedication and Licence (PDDL)":
        eml.setIntellectualRights(baseAction.getText("eml.intellectualRights.license.pddl.text"));
        break;
    case "Open Data Commons Attribution License":
        eml.setIntellectualRights(baseAction.getText("eml.intellectualRights.license.odcby.text"));
        break;
    case "Open Data Commons Open Database License (ODbL)":
        eml.setIntellectualRights(baseAction.getText("eml.intellectualRights.license.odbl.text"));
        break;
    default:
        throw new InvalidFormatException("El tipo de licencia elegida es invlida.");
    }
    eml.setAdditionalInfo(readCellValue(sheet.getRow(14).getCell(1)));
    List<String> alternateIdentifiers = new ArrayList<String>();
    Iterator<Row> rowIterator = sheet.rowIterator();
    Row row;
    while (rowIterator.hasNext()) {
        row = rowIterator.next();
        if (readCellValue(sheet.getRow(row.getRowNum()).getCell(1, Row.CREATE_NULL_AS_BLANK))
                .equalsIgnoreCase("Identificador Alterno:")) {
            if (!readCellValue(sheet.getRow(row.getRowNum() + 1).getCell(1)).isEmpty()) {
                alternateIdentifiers.add(readCellValue(sheet.getRow(row.getRowNum() + 1).getCell(1)));
            }
        }
    }
    eml.setAlternateIdentifiers(alternateIdentifiers);
}

---

From source file:net.sibcolombia.sibsp.service.portal.implementation.ResourceManagerImplementation.java

License:Creative Commons License

private void readAssociatedParties(Eml eml, Workbook template) throws InvalidFormatException {
    Sheet sheet = template.getSheet("Partes Asociadas");
    Iterator<Row> rowIterator = sheet.rowIterator();
    Agent agent;//from  w  w w .  j a va2  s.co m
    Address address;
    Row row;
    while (rowIterator.hasNext()) {
        row = rowIterator.next();
        if (readCellValue(sheet.getRow(row.getRowNum()).getCell(1, Row.CREATE_NULL_AS_BLANK))
                .equalsIgnoreCase("Nombre:")) {
            agent = new Agent();
            agent.setFirstName(
                    readCellValue(sheet.getRow(row.getRowNum() + 1).getCell(1, Row.CREATE_NULL_AS_BLANK)));
            agent.setLastName(
                    readCellValue(sheet.getRow(row.getRowNum() + 1).getCell(4, Row.CREATE_NULL_AS_BLANK)));
            agent.setPosition(
                    readCellValue(sheet.getRow(row.getRowNum() + 3).getCell(1, Row.CREATE_NULL_AS_BLANK)));
            agent.setOrganisation(
                    readCellValue(sheet.getRow(row.getRowNum() + 3).getCell(4, Row.CREATE_NULL_AS_BLANK)));
            agent.setPhone(
                    readCellValue(sheet.getRow(row.getRowNum() + 9).getCell(4, Row.CREATE_NULL_AS_BLANK)));
            agent.setEmail(
                    readCellValue(sheet.getRow(row.getRowNum() + 11).getCell(1, Row.CREATE_NULL_AS_BLANK)));
            agent.setHomepage(
                    readCellValue(sheet.getRow(row.getRowNum() + 11).getCell(4, Row.CREATE_NULL_AS_BLANK)));
            agent.setRole(
                    readCellValue(sheet.getRow(row.getRowNum() + 13).getCell(1, Row.CREATE_NULL_AS_BLANK)));
            address = new Address();
            address.setAddress(
                    readCellValue(sheet.getRow(row.getRowNum() + 5).getCell(1, Row.CREATE_NULL_AS_BLANK)));
            address.setCity(
                    readCellValue(sheet.getRow(row.getRowNum() + 5).getCell(4, Row.CREATE_NULL_AS_BLANK)));
            address.setProvince(
                    readCellValue(sheet.getRow(row.getRowNum() + 7).getCell(1, Row.CREATE_NULL_AS_BLANK)));
            address.setCountry(
                    readCellValue(sheet.getRow(row.getRowNum() + 7).getCell(4, Row.CREATE_NULL_AS_BLANK)));
            address.setPostalCode(
                    readCellValue(sheet.getRow(row.getRowNum() + 9).getCell(1, Row.CREATE_NULL_AS_BLANK)));
            agent.setAddress(address);
            eml.addAssociatedParty(agent);
        }
    }
}

---

From source file:net.sibcolombia.sibsp.service.portal.implementation.ResourceManagerImplementation.java

License:Creative Commons License

private void readBasicMetaData(Eml eml, Workbook template, Resource resource) throws InvalidFormatException {
    Sheet sheet = template.getSheet("Metadatos Bsicos");

    // Title/*from   w w  w  .  j  av a2  s.  c o  m*/
    eml.setTitle(readCellValue(sheet.getRow(5).getCell(1)));
    // Description
    eml.setDescription(readCellValue(sheet.getRow(7).getCell(1)));
    // Metadata language
    eml.setMetadataLanguage(readCellValue(sheet.getRow(9).getCell(1)));
    // Language resource
    eml.setLanguage(readCellValue(sheet.getRow(9).getCell(4)));

    // Resource creator
    Agent agent = new Agent();
    agent.setFirstName(readCellValue(sheet.getRow(33).getCell(1)));
    agent.setLastName(readCellValue(sheet.getRow(33).getCell(4)));
    agent.setPosition(readCellValue(sheet.getRow(35).getCell(1)));
    agent.setOrganisation(readCellValue(sheet.getRow(35).getCell(4)));
    agent.setPhone(readCellValue(sheet.getRow(41).getCell(4)));
    agent.setEmail(readCellValue(sheet.getRow(43).getCell(1)));
    agent.setHomepage(readCellValue(sheet.getRow(43).getCell(4)));
    Address address = new Address();
    address.setAddress(readCellValue(sheet.getRow(37).getCell(1)));
    address.setCity(readCellValue(sheet.getRow(37).getCell(4)));
    address.setProvince(readCellValue(sheet.getRow(39).getCell(1)));
    address.setCountry(readCellValue(sheet.getRow(39).getCell(4)));
    address.setPostalCode(String.valueOf(Math.round(sheet.getRow(41).getCell(1).getNumericCellValue())));
    agent.setAddress(address);
    eml.setResourceCreator(agent);

    // Contact
    agent = new Agent();
    agent.setFirstName(readCellValue(sheet.getRow(17).getCell(1)));
    agent.setLastName(readCellValue(sheet.getRow(17).getCell(4)));
    agent.setPosition(readCellValue(sheet.getRow(19).getCell(1)));
    agent.setOrganisation(readCellValue(sheet.getRow(19).getCell(4)));
    agent.setPhone(readCellValue(sheet.getRow(25).getCell(4)));
    agent.setEmail(readCellValue(sheet.getRow(27).getCell(1)));
    agent.setHomepage(readCellValue(sheet.getRow(27).getCell(4)));
    address = new Address();
    address.setAddress(readCellValue(sheet.getRow(21).getCell(1)));
    address.setCity(readCellValue(sheet.getRow(21).getCell(4)));
    address.setProvince(readCellValue(sheet.getRow(23).getCell(1)));
    address.setCountry(readCellValue(sheet.getRow(23).getCell(4)));
    address.setPostalCode(String.valueOf(Math.round(sheet.getRow(25).getCell(1).getNumericCellValue())));
    agent.setAddress(address);
    eml.setContact(agent);

    // Metadata provider
    agent = new Agent();
    agent.setFirstName(readCellValue(sheet.getRow(49).getCell(1)));
    agent.setLastName(readCellValue(sheet.getRow(49).getCell(4)));
    agent.setPosition(readCellValue(sheet.getRow(51).getCell(1)));
    agent.setOrganisation(readCellValue(sheet.getRow(51).getCell(4)));
    agent.setPhone(readCellValue(sheet.getRow(57).getCell(4)));
    agent.setEmail(readCellValue(sheet.getRow(59).getCell(1)));
    agent.setHomepage(readCellValue(sheet.getRow(59).getCell(4)));
    address = new Address();
    address.setAddress(readCellValue(sheet.getRow(53).getCell(1)));
    address.setCity(readCellValue(sheet.getRow(53).getCell(4)));
    address.setProvince(readCellValue(sheet.getRow(55).getCell(1)));
    address.setCountry(readCellValue(sheet.getRow(55).getCell(4)));
    address.setPostalCode(String.valueOf(Math.round(sheet.getRow(57).getCell(1).getNumericCellValue())));
    agent.setAddress(address);
    eml.setMetadataProvider(agent);
    // ////////////////////////////////////////////

    // ///////////////////////////////////////////
    // Core Type
    resource.setCoreType(readCellValue(sheet.getRow(11).getCell(1)));
    // SubType
    resource.setSubtype(readCellValue(sheet.getRow(11).getCell(4)));
    // //////////////////////////////////////////

}

---

From source file:net.sibcolombia.sibsp.service.portal.implementation.ResourceManagerImplementation.java

License:Creative Commons License

private void readCitations(Eml eml, Workbook template) throws InvalidFormatException {
    Sheet sheet = template.getSheet("Referencias");
    Citation citation = new Citation();
    citation.setIdentifier(readCellValue(sheet.getRow(5).getCell(1)));
    citation.setCitation(readCellValue(sheet.getRow(7).getCell(1)));
    eml.setCitation(citation);//from   w  w w .ja v a  2  s  .c o m
    BibliographicCitationSet val = new BibliographicCitationSet();
    Iterator<Row> rowIterator = sheet.rowIterator();
    Row row;
    while (rowIterator.hasNext()) {
        row = rowIterator.next();
        if (readCellValue(sheet.getRow(row.getRowNum()).getCell(1, Row.CREATE_NULL_AS_BLANK))
                .equalsIgnoreCase("Identificacin de la Referencia:")) {
            if (!readCellValue(sheet.getRow(row.getRowNum() + 1).getCell(1)).isEmpty()
                    || !readCellValue(sheet.getRow(row.getRowNum() + 3).getCell(1)).isEmpty()) {
                val.add(readCellValue(sheet.getRow(row.getRowNum() + 3).getCell(1)),
                        readCellValue(sheet.getRow(row.getRowNum() + 1).getCell(1)));
            }
        }
    }
    eml.setBibliographicCitationSet(val);
}

---

• «
• 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
• 27
• 28
• 29
• 30
• »