Example usage for org.apache.poi.ss.usermodel Sheet getSheetName

Introduction

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

Prototype

String getSheetName();

Source Link

Document

Returns the name of this sheet

Usage

From source file:eu.esdihumboldt.hale.io.xls.test.writer.XLSInstanceWriterTest.java

License:Open Source License

/**
 * /*from  w  ww.j  a  v  a 2  s  .  c o  m*/
 * @param sheet the excel file sheet
 * @param sheetName The sheet name
 * @throws Exception , if an error occurs
 */
private void checkSheetName(Sheet sheet, String sheetName) throws Exception {

    assertTrue("There is no sheet in the file named: " + sheet.getSheetName(),
            sheetName.equals(sheet.getSheetName()));

}

---

From source file:eu.esdihumboldt.hale.io.xls.ui.XLSSchemaTypePage.java

License:Open Source License

@Override
protected void onShowPage(boolean firstShow) {

    URI newLocation = getWizard().getProvider().getSource().getLocation();
    if (!firstShow && newLocation != null && !newLocation.equals(oldLocation)) {
        sheetNum = 0;/*from   w w  w  .j a v  a2 s  .  c  o m*/
    }

    try {
        Workbook wb = WorkbookFactory.create(getWizard().getProvider().getSource().getInput());

        int numberOfSheets = wb.getNumberOfSheets();
        if (sheetNum >= numberOfSheets) {
            sheetNum = 0;
        }
        ArrayList<String> items = new ArrayList<String>();
        for (int i = 0; i < numberOfSheets; i++) {
            items.add(wb.getSheetAt(i).getSheetName());
            // only add items if there is a header (no empty sheet)
            Row row = wb.getSheetAt(i).getRow(0);
            if (row == null && newLocation != null && !newLocation.equals(oldLocation)) {
                sheetNum++;
            }
        }

        sheet.setItems(items.toArray(new String[items.size()]));
        sheet.select(sheetNum);

        // try to update
        update(sheetNum);

        super.onShowPage(firstShow);

        // Overwrite super string field editor value
        Sheet sheet = wb.getSheetAt(sheetNum);
        setStringFieldEditorValue(sheet.getSheetName());

        oldLocation = newLocation;

    } catch (OldExcelFormatException e) {
        // the setup is not in a valid state
        clearPage();
        clearSuperPage();
        setErrorMessage(
                "Old excel format detected (format 5.0/7.0 (BIFF5)). Please convert the excel file to BIFF8 from Excel versions 97/2000/XP/2003.");
        setPageComplete(false);
    } catch (Exception e) {
        clearPage();
        clearSuperPage();
        setErrorMessage("Excel file cannot be loaded!");
        setPageComplete(false);
    }
}

---

From source file:eu.learnpad.ontology.kpi.data.ExcelParser.java

public String getSPARQLQuery() throws IOException, InvalidFormatException {
    Boolean foundSparqlQuery = false;

    Workbook wb = WorkbookFactory.create(excelFile);

    for (Sheet sheet : wb) {
        if (sheet.getSheetName().equals(SHEETNAME)) {
            for (Row row : sheet) {
                for (Cell cell : row) {
                    if (cell.getCellType() == Cell.CELL_TYPE_BLANK) {
                        continue;
                    }/*from   ww  w  . j  ava  2 s.  c om*/
                    if (!foundSparqlQuery && cell.getCellType() == Cell.CELL_TYPE_STRING) {
                        if (cell.getRichStringCellValue().getString().equals(QUERYCELLNAME)) {
                            foundSparqlQuery = true;
                            continue;
                        }
                    }
                    if (foundSparqlQuery && cell.getCellType() == Cell.CELL_TYPE_STRING) {
                        return cell.getRichStringCellValue().getString();
                    }
                }
            }
        }
    }
    return null;
}

---

From source file:eu.learnpad.ontology.kpi.data.ExcelParser.java

public List<List<String>> getDataTable() throws IOException, InvalidFormatException {
    List<List<String>> dataTable = new ArrayList<>();
    Integer rowNumber = -2;/* w w w. j  a  v a  2  s.c o m*/

    Workbook wb = WorkbookFactory.create(excelFile);

    FormulaEvaluator evaluator = wb.getCreationHelper().createFormulaEvaluator();
    for (Sheet sheet : wb) {
        if (sheet.getSheetName().equals(SHEETNAME)) {
            for (Row row : sheet) {
                //stop with the first empty row
                if (row.getCell(0) == null) {
                    break;
                }
                if (rowNumber >= -1) {
                    rowNumber++;
                    dataTable.add(new ArrayList<String>());
                }
                for (Cell cell : row) {
                    String sheetName = sheet.getSheetName();
                    String cellRow = "Row:" + cell.getRowIndex();
                    String cellColumn = "Column:" + cell.getColumnIndex();
                    Object[] o = new Object[] { sheetName, cellRow, cellColumn };
                    LOGGER.log(Level.INFO, "Processing: Sheet={0} celladress={1}", o);
                    if (rowNumber <= -1 && cell.getCellType() == Cell.CELL_TYPE_BLANK) {
                        continue;
                    }
                    if (rowNumber == -2 && cell.getCellType() == Cell.CELL_TYPE_STRING) {
                        if (cell.getRichStringCellValue().getString().equals(DATACELLNAME)) {
                            rowNumber = -1;
                            continue;
                        }
                    }
                    //Attributes (column headers)
                    if (rowNumber == 0) {
                        dataTable.get(rowNumber).add(cell.getRichStringCellValue().getString());
                    }

                    if (rowNumber >= 1) {

                        switch (cell.getCellType()) {
                        case Cell.CELL_TYPE_STRING:
                            dataTable.get(rowNumber).add(cell.getRichStringCellValue().getString());
                            break;
                        case Cell.CELL_TYPE_NUMERIC:
                            if (DateUtil.isCellDateFormatted(cell)) {
                                dataTable.get(rowNumber).add(cell.getDateCellValue().toString());
                            } else {
                                dataTable.get(rowNumber).add(Double.toString(cell.getNumericCellValue()));
                            }
                            break;
                        case Cell.CELL_TYPE_BOOLEAN:
                            dataTable.get(rowNumber).add(Boolean.toString(cell.getBooleanCellValue()));
                            break;
                        case Cell.CELL_TYPE_FORMULA:
                            switch (cell.getCachedFormulaResultType()) {
                            case Cell.CELL_TYPE_STRING:
                                dataTable.get(rowNumber).add(cell.getRichStringCellValue().getString());
                                break;
                            case Cell.CELL_TYPE_NUMERIC:
                                if (DateUtil.isCellDateFormatted(cell)) {
                                    dataTable.get(rowNumber).add(cell.getDateCellValue().toString());
                                } else {
                                    dataTable.get(rowNumber).add(Double.toString(cell.getNumericCellValue()));
                                }
                                break;
                            case Cell.CELL_TYPE_BOOLEAN:
                                dataTable.get(rowNumber).add(Boolean.toString(cell.getBooleanCellValue()));
                                break;
                            default:
                                dataTable.get(rowNumber).add("");
                            }
                            break;
                        default:
                            dataTable.get(rowNumber).add("");
                        }
                    }
                }
            }
        }
    }

    return dataTable;
}

---

From source file:fr.amapj.service.engine.generator.excel.ExcelGeneratorTool.java

License:Open Source License

/**
 * Permet de dplacer la page courante  l'index spcifi
 *///w w  w  .  j a  va  2s .  c om
public void setSheetFirst() {
    int nb = wb.getNumberOfSheets();

    // On construit la liste des noms des feuilles dans le bon ordre
    List<String> sheetName = new ArrayList<>();
    sheetName.add(sheet.getSheetName());
    for (int i = 0; i < nb - 1; i++) {
        Sheet s = wb.getSheetAt(i);
        sheetName.add(s.getSheetName());
    }

    // On applique ensuite  chaque feuille son nouveau numero d'ordre
    for (int i = 0; i < nb; i++) {
        wb.setSheetOrder(sheetName.get(i), i);
        Sheet s = wb.getSheetAt(i);
        if (i == 0) {
            s.setSelected(true);
        } else {
            s.setSelected(false);
        }
    }
}

---

From source file:fr.inria.teap.dcnsacfgeneration.tools.XLSInjector.java

License:Open Source License

public Worksheet inject(Sheet xlsSheet) {
    Worksheet sheet = XlsFactory.eINSTANCE.createWorksheet();
    sheet.setName(xlsSheet.getSheetName());
    Table table = XlsFactory.eINSTANCE.createTable();
    sheet.setWs_table(table);//  w  ww  .  j a  v  a  2  s . c o m
    for (org.apache.poi.ss.usermodel.Row xlsRow : xlsSheet) {
        //Management of the rows just inserted by user (and so with empty cells)
        if (xlsRow.getCell(0) != null) {
            if (!StringUtils.isBlank(xlsRow.getCell(0).getStringCellValue())) {
                table.getT_rows().add(inject(xlsRow));
            }
        }
    }
    return sheet;
}

---

From source file:fsart.diffTools.gui.DiffToolsMainPanel.java

License:CeCILL license

private void appendExcelSheetInJList(String excelFile, JList listfic) {
    log.debug("Enter append excel sheet with " + excelFile);
    String type = Helper.getTypeOfFile(excelFile);
    Vector<String> emptyList = new Vector<String>();
    listfic.setListData(emptyList);//from  w ww  .j a  v a  2 s.  c  om
    log.debug("type of file : " + type);
    if (type.equals("xls")) {
        InputStream inp = null;
        try {
            inp = new FileInputStream(excelFile);
            HSSFWorkbook wb = new HSSFWorkbook(inp);
            int sheetNb = wb.getNumberOfSheets();
            if (sheetNb > 0) {
                Vector<String> sheetnames = new Vector<String>();
                for (int i = 0; i < sheetNb; i++) {
                    Sheet sheet = wb.getSheetAt(i);
                    sheetnames.addElement(sheet.getSheetName());
                    log.debug("I find : " + sheet.getSheetName());
                }
                listfic.setListData(sheetnames);
            }
        } catch (Exception e) {
        }

    }

}

---

From source file:gov.nih.nci.evs.app.neopl.XLStoXLSX.java

License:Open Source License

/**
 * @param args//w  ww .  ja v a2s  .c  om
 * @throws InvalidFormatException
 * @throws IOException
 */

public static void run(String inputfile, String outputfile) throws IOException {
    InputStream in = new BufferedInputStream(new FileInputStream(inputfile));
    try {
        Workbook wbIn = new HSSFWorkbook(in);
        File outFn = new File(outputfile);
        if (outFn.exists()) {
            outFn.delete();
        }

        Workbook wbOut = new XSSFWorkbook();
        int sheetCnt = wbIn.getNumberOfSheets();
        for (int i = 0; i < sheetCnt; i++) {
            Sheet sIn = wbIn.getSheetAt(0);
            Sheet sOut = wbOut.createSheet(sIn.getSheetName());
            Iterator<Row> rowIt = sIn.rowIterator();
            while (rowIt.hasNext()) {
                Row rowIn = rowIt.next();
                Row rowOut = sOut.createRow(rowIn.getRowNum());

                Iterator<Cell> cellIt = rowIn.cellIterator();
                while (cellIt.hasNext()) {
                    Cell cellIn = cellIt.next();
                    Cell cellOut = rowOut.createCell(cellIn.getColumnIndex(), cellIn.getCellType());

                    switch (cellIn.getCellType()) {
                    case Cell.CELL_TYPE_BLANK:
                        break;

                    case Cell.CELL_TYPE_BOOLEAN:
                        cellOut.setCellValue(cellIn.getBooleanCellValue());
                        break;

                    case Cell.CELL_TYPE_ERROR:
                        cellOut.setCellValue(cellIn.getErrorCellValue());
                        break;

                    case Cell.CELL_TYPE_FORMULA:
                        cellOut.setCellFormula(cellIn.getCellFormula());
                        break;

                    case Cell.CELL_TYPE_NUMERIC:
                        cellOut.setCellValue(cellIn.getNumericCellValue());
                        break;

                    case Cell.CELL_TYPE_STRING:
                        cellOut.setCellValue(cellIn.getStringCellValue());
                        break;
                    }

                    {
                        CellStyle styleIn = cellIn.getCellStyle();
                        CellStyle styleOut = cellOut.getCellStyle();
                        styleOut.setDataFormat(styleIn.getDataFormat());
                    }
                    cellOut.setCellComment(cellIn.getCellComment());

                    // HSSFCellStyle cannot be cast to XSSFCellStyle
                    // cellOut.setCellStyle(cellIn.getCellStyle());
                }
            }
        }
        OutputStream out = new BufferedOutputStream(new FileOutputStream(outFn));
        try {
            wbOut.write(out);
        } finally {
            out.close();
        }
    } finally {
        in.close();
    }
}

---

From source file:gov.nih.nci.ncicb.tcga.dcc.common.web.view.TCGAExcelSXSSViewFastTest.java

@Test
public void buildExcelDocument() throws Exception {
    xlView.buildExcelDocument(model, wb, request, response);
    assertEquals("attachment; filename=domi.xls", response.getHeader("Content-Disposition"));
    Sheet sheet = wb.getSheetAt(0);
    Assert.assertEquals("domi", sheet.getSheetName());
    Assert.assertEquals("Archive Name", sheet.getRow(0).getCell(0).getStringCellValue());
    Assert.assertEquals("Platform", sheet.getRow(0).getCell(1).getStringCellValue());
    Assert.assertEquals("Url", sheet.getRow(0).getCell(2).getStringCellValue());
    Assert.assertEquals("mockArchive1", sheet.getRow(1).getCell(0).getStringCellValue());
    Assert.assertEquals("mockplatform1", sheet.getRow(1).getCell(1).getStringCellValue());
    Assert.assertEquals("mockUrl", sheet.getRow(1).getCell(2).getStringCellValue());
}

---

From source file:gov.nij.er.ui.EntityResolutionDemo.java

License:Apache License

private void loadExcelData(File file) throws Exception {

    LOG.debug("Loading Excel data file " + file.getAbsolutePath());

    InputStream inp = new FileInputStream(file);
    Workbook wb = WorkbookFactory.create(inp);

    // note that we read all the data out of the spreadsheet first, then
    // update the models. this way if there is
    // an error, we don't wipe out what the user already has.

    Sheet sheet = wb.getSheetAt(0);
    Row parametersRow = sheet.getRow(0);
    List<String> parameterNames = new ArrayList<String>();
    for (Cell cell : parametersRow) {
        String v = cell.getStringCellValue();
        if (parameterNames.contains(v)) {
            error("Duplicate field: " + v);
            return;
        }//from w w w .j  ava2 s . co  m
        parameterNames.add(v);
        LOG.debug("Adding parameter " + v);
    }

    int parameterCount = parameterNames.size();

    LOG.debug("Excel loading read " + parameterCount + " parameters");

    List<ExternallyIdentifiableRecord> records = new ArrayList<ExternallyIdentifiableRecord>();

    int rowCount = sheet.getLastRowNum();
    LOG.debug("Loading " + (rowCount - 1) + " rows from " + sheet.getSheetName());

    int digits = (int) (Math.floor(Math.log10(rowCount)) + 1);

    DataFormatter dataFormatter = new DataFormatter();

    for (int rowIndex = 1; rowIndex <= rowCount; rowIndex++) {
        List<Attribute> attributes = new ArrayList<Attribute>(parameterCount);
        Row row = sheet.getRow(rowIndex);
        for (int i = 0; i < parameterCount; i++) {
            Cell cell = row.getCell(i);
            String v = dataFormatter.formatCellValue(cell);
            String parameterName = parameterNames.get(attributes.size());
            attributes.add(new Attribute(parameterName, v));
            // LOG.debug("Adding attribute, name=" + parameterName + ", v="
            // + (v==null ? "null" : "'" + v + "'"));
        }
        records.add(new ExternallyIdentifiableRecord(makeAttributes(attributes.toArray(new Attribute[] {})),
                String.format("%0" + digits + "d", rowIndex)));
    }

    LOG.debug("Read " + records.size() + " records from Excel");

    List<RecordWrapper> recordWrappers = EntityResolutionConversionUtils.convertRecords(records);
    rawDataTreeModel.init(recordWrappers);

    parametersTableModel.clear();
    parametersTableModel.addParameters(parameterNames);

}

---

• «
• 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
• »