Example usage for org.apache.poi.hssf.usermodel HSSFWorkbook getSheet

Introduction

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

Prototype

@Override
public HSSFSheet getSheet(String name) 

Source Link

Document

Get sheet with the given name (case insensitive match)

Usage

From source file:com.photon.phresco.service.tools.PilotProjectGenerator.java

License:Apache License

private void createPilots(String tech, HSSFWorkbook workBook) throws PhrescoException {
    HSSFSheet sheet = workBook.getSheet(SHEET_NAME_PILOTS);
    Iterator<Row> rowsIter = sheet.rowIterator();
    // Skipping first row
    for (int i = 0; i < NO_OF_ROWS_TO_SKIP; i++) {
        rowsIter.next();/* www  .ja  va2  s  .  c o m*/
    }
    while (rowsIter.hasNext()) {
        Row row = rowsIter.next();
        createPilots(tech, row);
    }
}

---

From source file:com.photon.phresco.service.tools.PilotProjectGenerator.java

License:Apache License

private void generateJSLibrary(HSSFWorkbook workBook, String tech) {
    HSSFSheet sheet = workBook.getSheet(SHEET_NAME_JSLIBRARY);
    Iterator<Row> rowsIter = sheet.rowIterator();
    for (int i = 0; i < NO_OF_ROWS_TO_SKIP; i++) {
        rowsIter.next();//ww w  .  ja  va2 s  .com
    }
    while (rowsIter.hasNext()) {
        Row row = rowsIter.next();
        createJSLibrary(tech, row);
    }

}

---

From source file:com.photon.phresco.service.tools.PilotProjectGenerator.java

License:Apache License

private void generateModule(HSSFWorkbook workBook, String tech) throws PhrescoException {
    HSSFSheet sheet = workBook.getSheet(SHEET_NAME_MODULE);
    Iterator<Row> rowsIter = sheet.rowIterator();
    for (int i = 0; i < NO_OF_ROWS_TO_SKIP; i++) {
        rowsIter.next();//from  w ww .  j a  v a 2s  .c  o m
    }
    while (rowsIter.hasNext()) {
        Row row = rowsIter.next();
        createModule(tech, row);
    }
}

---

From source file:com.photon.phresco.service.tools.TechnologyDataGenerator.java

License:Apache License

private List<ModuleGroup> createModules(String tech, HSSFWorkbook workBook) throws PhrescoException {
    List<ModuleGroup> moduleGroups = new ArrayList<ModuleGroup>();
    HSSFSheet sheet = workBook.getSheet(SHEET_NAME_MODULE);
    Modules modules = new Modules();
    Iterator<Row> rowsIter = sheet.rowIterator();
    // Skipping first row
    for (int i = 0; i < NO_OF_ROWS_TO_SKIP; i++) {
        rowsIter.next();//www  .ja v a2s  .  com
    }
    while (rowsIter.hasNext()) {
        Row row = rowsIter.next();
        ModuleGroup module = createModuleGroup(tech, row);
        if (module != null) {
            moduleGroups.add(module);
        }
    }
    return moduleGroups;
}

---

From source file:com.scoretracker.service.ScoreTrackerServiceImpl.java

public ArrayList<String> getExcel() {
    ArrayList<String> lijst = new ArrayList<String>();
    try {/*  w  ww  . ja v a 2 s  .  c o m*/

        FileInputStream fileInputStream = new FileInputStream("C:\\poi-test.xls");
        HSSFWorkbook workbook = new HSSFWorkbook(fileInputStream);
        HSSFSheet worksheet = workbook.getSheet("POI Worksheet");
        HSSFRow row1 = worksheet.getRow(0);
        HSSFCell cellA1 = row1.getCell((short) 0);
        String a1Val = cellA1.getStringCellValue();
        HSSFCell cellB1 = row1.getCell((short) 1);
        String b1Val = cellB1.getStringCellValue();
        HSSFCell cellC1 = row1.getCell((short) 2);
        String c1Val = cellC1.getStringCellValue();
        HSSFCell cellD1 = row1.getCell((short) 3);
        String d1Val = cellD1.getStringCellValue();

        lijst.add(a1Val);
        lijst.add(b1Val);
        lijst.add(c1Val);
        lijst.add(d1Val);

    } catch (FileNotFoundException e) {
        e.printStackTrace();
    } catch (IOException e) {
        e.printStackTrace();
    }
    return lijst;
}

---

From source file:com.servoy.extensions.plugins.excelxport.ExportSpecifyFilePanel.java

License:Open Source License

public static HSSFWorkbook populateWb(IFoundSet foundSet, String[] dataProviders, byte[] templateXLS,
        String[] outputColumnNames, String sheetName, int startRow, int startColumn) throws IOException {
    HSSFWorkbook hwb;
    if (templateXLS == null) {
        hwb = new HSSFWorkbook();
    } else {//from w  ww. j  a  v a 2s  . co  m
        InputStream buff = new ByteArrayInputStream(templateXLS);
        hwb = new HSSFWorkbook(buff);
    }
    if (sheetName == null)
        sheetName = "Servoy Data";
    HSSFSheet sheet = hwb.getSheet(sheetName);
    if (sheet == null)
        sheet = hwb.createSheet(sheetName);
    sheet.setActive(true);

    if (outputColumnNames != null && outputColumnNames.length != dataProviders.length) {
        throw new RuntimeException(
                "The arrays 'output column names' and 'data provider ids' must have the same length."); //$NON-NLS-1$
    }
    String[] columnNames = outputColumnNames != null ? outputColumnNames : dataProviders;
    HSSFRow header = sheet.createRow((short) 0 + startRow);
    for (int k = 0; k < columnNames.length; k++) {
        HSSFCell cell = header.createCell((short) (k + startColumn));
        cell.setCellValue(columnNames[k]);
    }

    for (int i = 0; i < foundSet.getSize(); i++) {
        HSSFRow row = sheet.createRow((short) (i + 1 + startRow));
        IRecord s = foundSet.getRecord(i);
        for (int k = 0; k < dataProviders.length; k++) {
            HSSFCell cell = row.createCell((short) (k + startColumn));

            Object obj = s.getValue(dataProviders[k]);
            if (obj instanceof Date) {
                HSSFCellStyle cellStyle = hwb.createCellStyle();
                cellStyle.setDataFormat((short) 16);
                cell.setCellValue((Date) obj);
                cell.setCellStyle(cellStyle);
            } else if (obj instanceof String) {
                cell.setCellValue((String) obj);
            } else if (obj instanceof Number) {
                cell.setCellValue(((Number) obj).doubleValue());
            } else {
                cell.setCellValue(""); //$NON-NLS-1$
            }
        }
    }

    return hwb;
}

---

From source file:com.syncnapsis.utils.data.ExcelHelper.java

License:Open Source License

public static void main(String[] args) throws Exception {
    String fileName = "testdata.xls";
    HSSFWorkbook workbook = new HSSFWorkbook(new FileInputStream("src/main/resources/" + fileName));

    HSSFSheet sheet = workbook.getSheet("Benutzer");
    HSSFRow row = sheet.getRow(0);/*from w w  w  .j ava 2s .c  o m*/
    Cell cell;

    for (int i = 2; i < 256; i++) {
        try {
            cell = row.getCell(i);
            if (cell == null)
                cell = row.createCell(i);
            cell.setCellFormula("IF(ISBLANK(Benutzer!A" + (i - 1) + "),\"\",Benutzer!A" + (i - 1) + ")");
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
    workbook.write(new FileOutputStream("src/main/resources/new.xls"));
}

---

From source file:com.syncnapsis.utils.data.UniverseEvolutionExcelParser.java

License:Open Source License

/**
 * Laden der Spalten fr die Kontakt-Rechte
 * //from   ww  w  .  j  av a  2  s  .co  m
 * @param workbook - das Workbook
 * @param key_sheet_authorities_c - der Key fr das Sheet
 */
public static void parseContactAuthorities(HSSFWorkbook workbook, String key_sheet_authorities_c) {
    HSSFSheet sheet_authorities_c = workbook.getSheet(key_sheet_authorities_c);

    // sheet_authorities_c -> Laden der Spalten fr die Kontakt-Rechte
    HSSFRow row = sheet_authorities_c.getRow(0);
    for (int i = 1; i < 255; i++) {
        if (row.getCell(i) == null)
            break;
        contactAuthorities_colToName.put(i, row.getCell(i).getStringCellValue());
    }
    logger.debug("contact-authority-columns loaded: " + contactAuthorities_colToName.size());

    String name;

    // sheet_authorities_c -> Laden der Kontakt-Rechte
    int rowNum = 2;
    while ((row = sheet_authorities_c.getRow(rowNum++)) != null) {
        try {
            name = row.getCell(0).getStringCellValue();
            contactAuthorities.put(name, new TreeMap<String, Boolean>());

            for (int i = 1; i < 255; i++) {
                if (row.getCell(i) == null)
                    break;
                contactAuthorities.get(name).put(contactAuthorities_colToName.get(i),
                        row.getCell(i).getNumericCellValue() == 1);
            }
        } catch (Exception e) {
            e.printStackTrace();
            logger.error("error: " + key_sheet_authorities_c + " at line " + rowNum);
        }
    }
    logger.debug("contact-authorities loaded: " + contactAuthorities.size());
}

---

From source file:com.syncnapsis.utils.data.UniverseEvolutionExcelParser.java

License:Open Source License

/**
 * Laden der Spalten fr die Allianz-Rechte
 * /* w  ww  .j a  va2s  .c  o m*/
 * @param workbook - das Workbook
 * @param key_sheet_authorities_a - der Key fr das Sheet
 */
public static void parseAllianceAuthorities(HSSFWorkbook workbook, String key_sheet_authorities_a) {
    HSSFSheet sheet_authorities_a = workbook.getSheet(key_sheet_authorities_a);

    // sheet_authorities_a -> Laden der Spalten fr die Allianz-Rechte
    HSSFRow row = sheet_authorities_a.getRow(0);
    for (int i = 3; i < 255; i++) {
        if (row.getCell(i) == null)
            break;
        allianceAuthorities_colToName.put(i, row.getCell(i).getStringCellValue());
    }
    logger.debug("alliance-authority-columns loaded: " + allianceAuthorities_colToName.size());

    String name, fullname, parent, ref, weight;

    // sheet_authorities_a -> Laden der Allianz-Rechte
    int rowNum = 2;
    while ((row = sheet_authorities_a.getRow(rowNum++)) != null) {
        try {
            name = row.getCell(0).getStringCellValue();
            if (name == null || name.isEmpty())
                break;
            fullname = row.getCell(1).getStringCellValue();
            parent = row.getCell(2).getStringCellValue();
            weight = "" + (int) row.getCell(3).getNumericCellValue();
            allianceAuthorities.put(name, new TreeMap<String, Boolean>());
            allianceMemberRanks.put(name + "_full", fullname);
            allianceMemberRanks.put(name + "_parent", parent);
            allianceMemberRanks.put(name + "_weight", weight);

            for (int i = 5; i < 255; i++) {
                if (row.getCell(i) == null)
                    break;
                allianceAuthorities.get(name).put(allianceAuthorities_colToName.get(i),
                        row.getCell(i).getNumericCellValue() == 1);
            }

            ref = row.getCell(4).getStringCellValue(); // contactauthorities
            allianceAuthorities.get(name).putAll(contactAuthorities.get(ref));
        } catch (Exception e) {
            e.printStackTrace();
            logger.error("error: " + key_sheet_authorities_a + " at line " + rowNum);
        }
    }
    logger.debug("alliance-authorities loaded: " + allianceAuthorities.size());
    logger.debug("alliance-ranks loaded: " + allianceMemberRanks.size());
}

---

From source file:com.syncnapsis.utils.data.UniverseEvolutionExcelParser.java

License:Open Source License

/**
 * Erstellen aller Benutzer//from w  ww  .  j  ava 2s  . c  o  m
 * 
 * @param workbook - das Workbook
 * @param key_sheet_players - der Key fr das Sheet
 */
public static void parseUsers(HSSFWorkbook workbook, String key_sheet_players) {
    HSSFSheet sheet_players = workbook.getSheet(key_sheet_players);

    HSSFRow row;
    Cell cell;
    String username, rolename, username1, username2;
    String playerrole, userrole;
    Player player;

    // sheet_players -> erstelle alle Benutzer
    int rowNum = 1;
    while ((row = sheet_players.getRow(rowNum++)) != null) {
        try {
            username = row.getCell(0).getStringCellValue();
            if (username == null || username.isEmpty())
                break;
            rolename = row.getCell(1).getStringCellValue();

            if (rolename.contains("NORMAL")) {
                playerrole = BaseGameConstants.ROLE_NORMAL_PLAYER;
                userrole = BaseApplicationConstants.ROLE_NORMAL_USER;
            } else if (rolename.contains("MODERATOR")) {
                playerrole = BaseGameConstants.ROLE_PREMIUM_PLAYER;
                userrole = BaseApplicationConstants.ROLE_MODERATOR;
            } else if (rolename.contains("ADMIN")) {
                playerrole = BaseGameConstants.ROLE_PREMIUM_PLAYER;
                userrole = BaseApplicationConstants.ROLE_ADMIN;
            } else
            // if (rolename.contains("DEMO"))
            {
                playerrole = BaseGameConstants.ROLE_DEMO_PLAYER;
                userrole = BaseApplicationConstants.ROLE_DEMO_USER;
            }

            getOrCreatePlayer(username, playerrole, userrole);
        } catch (Exception e) {
            e.printStackTrace();
            logger.error("error: " + key_sheet_players + " at line " + rowNum);
        }
    }
    logger.debug("players created: " + players.size());

    rowNum = 1;
    int colNum;
    int count = 0, sittercount = 0;
    boolean sitter1, sitter2;
    while ((row = sheet_players.getRow(rowNum++)) != null) {
        try {
            colNum = rowNum + 1;

            username1 = row.getCell(0).getStringCellValue();
            if (username1 == null || username1.isEmpty())
                break;

            while ((cell = sheet_players.getRow(0).getCell(colNum++)) != null) {
                username2 = cell.getStringCellValue();
                if (username2 == null || username2.isEmpty())
                    break;
                sitter1 = (row.getCell(colNum - 1) != null
                        && row.getCell(colNum - 1).getNumericCellValue() == 1);
                sitter2 = (sheet_players.getRow(colNum - 2).getCell(rowNum) != null
                        && sheet_players.getRow(colNum - 2).getCell(rowNum).getNumericCellValue() == 1);
                if (sitter1 || sitter2) {
                    RandomModels.createUserContact(getOrCreatePlayer(username1, null, null).getUser(),
                            getOrCreatePlayer(username2, null, null).getUser());
                    count++;
                }
                if (sitter1) {
                    player = getOrCreatePlayer(username1, null, null);
                    player.getSitters().add(getOrCreatePlayer(username2, null, null));
                    player = playerManager.save(player);
                    players.put(username1, player);
                    sittercount++;
                }
                if (sitter2) {
                    player = getOrCreatePlayer(username2, null, null);
                    player.getSitters().add(getOrCreatePlayer(username1, null, null));
                    player = playerManager.save(player);
                    players.put(username2, player);
                    sittercount++;
                }
            }
        } catch (Exception e) {
            e.printStackTrace();
            logger.error("error: " + key_sheet_players + " at line " + rowNum);
        }
    }
    logger.debug("user-contacts created: " + count);
    logger.debug("user-sitters created: " + sittercount);
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• »