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

Introduction

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

Prototype

@Override
public int getNumberOfSheets()

Source Link

Document

get the number of spreadsheets in the workbook (this will be three after serialization)

Usage

From source file:fi.vm.sade.osoitepalvelu.service.search.SearchResultTransformerServiceTest.java

License:EUPL

@Test
public void testProduceEmptyExcel() {
    HSSFWorkbook wb = new HSSFWorkbook();
    searchExcelService.produceExcel(wb,/*from w  ww . ja  va2s.com*/
            new SearchResultsPresentationDto(new ArrayList<>(), new AllColumnsSearchResultPresentation()));
    assertEquals(1, wb.getNumberOfSheets());
    assertEquals(0, wb.getSheetAt(0).getLastRowNum());
    assertEquals("Organisaatio", wb.getSheetAt(0).getRow(0).getCell(0).getStringCellValue());
}

From source file:fi.vm.sade.osoitepalvelu.service.search.SearchResultTransformerServiceTest.java

License:EUPL

@Test
public void testProduceSingleLineNullExcel() {
    OrganisaatioResultDto organisaatio = new OrganisaatioResultDto();
    HashMap<String, String> nimi = new HashMap<>();
    nimi.put("sv", "Organisations namnet");
    nimi.put("fi", "Organisaation nimi");
    organisaatio.setNimi(nimi);//from  ww  w  .  j  a va2s  .c o  m
    SearchResultPresentation presentation = new AllColumnsSearchResultPresentation();
    SearchResultsPresentationDto results = resultTranformerService.transformToResultRows(
            organisaatioResults(Arrays.asList(organisaatio)), presentation, new DefaultCamelRequestContext(),
            null);

    HSSFWorkbook wb = new HSSFWorkbook();
    searchExcelService.produceExcel(wb, results);
    assertEquals(1, wb.getNumberOfSheets());
    assertEquals(1, wb.getSheetAt(0).getLastRowNum());
    assertEquals("Organisaation nimi", wb.getSheetAt(0).getRow(1).getCell(0).getStringCellValue());
}

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

License:Open Source License

public Workbook inject(HSSFWorkbook xlsWorkbook) {
    Workbook workbook = XlsFactory.eINSTANCE.createWorkbook();
    for (int i = 0; i < xlsWorkbook.getNumberOfSheets(); i++) {
        Sheet xlsSheet = xlsWorkbook.getSheetAt(i);
        workbook.getWb_worksheets().add(inject(xlsSheet));
    }/* www . ja  va  2  s  . com*/
    return workbook;
}

From source file:framework.retrieval.engine.index.create.impl.file.parse.ExcelFileContentParser.java

License:Apache License

public String getContent(RFileDocument document, String charsetName) {

    InputStream fileInputStream = null;
    StringBuffer content = new StringBuffer();

    try {//from  ww  w  . j a v  a 2 s .co  m
        fileInputStream = new FileInputStream(document.getFile());
        HSSFWorkbook workbook = new HSSFWorkbook(fileInputStream);// Excel

        if (workbook != null) {
            int numSheetsNumber = workbook.getNumberOfSheets();
            for (int numSheets = 0; numSheets < numSheetsNumber; numSheets++) {
                HSSFSheet aSheet = workbook.getSheetAt(numSheets);// sheet
                if (aSheet != null) {
                    int lastRowNum = aSheet.getLastRowNum();
                    for (int rowNumOfSheet = 0; rowNumOfSheet <= lastRowNum; rowNumOfSheet++) {
                        HSSFRow aRow = aSheet.getRow(rowNumOfSheet); // 
                        if (aRow != null) {
                            int lastCellNum = aRow.getLastCellNum();
                            for (int cellNumOfRow = 0; cellNumOfRow <= lastCellNum; cellNumOfRow++) {
                                HSSFCell aCell = aRow.getCell(cellNumOfRow);// 
                                if (aCell != null) {
                                    int cellType = aCell.getCellType();
                                    if (cellType == HSSFCell.CELL_TYPE_STRING) {
                                        String value = StringClass.getString(aCell.getStringCellValue());
                                        content.append(value);
                                    }
                                }
                            }
                        }
                    }
                }
            }
        }
    } catch (Exception e) {
        RetrievalUtil.errorLog(log, document.getFile().getAbsolutePath(), e);
    } finally {
        if (fileInputStream != null) {
            try {
                fileInputStream.close();
            } catch (Exception e) {

            }
        }
    }

    return content.toString();

}

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);/*  w ww . j a va2 s.c  o  m*/
    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.caBIOApp.report.HSSFExcelSpreadsheet.java

License:BSD License

HSSFExcelSpreadsheet(HSSFWorkbook wb, int worksheetNum) throws IndexOutOfBoundsException {
    _workbook = wb;/*  ww w  .j  a  v a  2  s  .  c om*/
    int numSheets = wb.getNumberOfSheets();
    if (worksheetNum < 0 || worksheetNum >= numSheets) {
        throw new IndexOutOfBoundsException("No worksheet at index " + (worksheetNum + 1));
    }
    _sheet = wb.getSheetAt(worksheetNum);
}

From source file:gov.nih.nci.ncicb.cadsr.bulkloader.util.excel.DBExcelUtility.java

License:BSD License

public String getExcelDataSet(InputStream is, String tableName) throws Exception {
    StringBuffer sb = new StringBuffer();
    HSSFWorkbook wb = ExcelUtility.createWorkbook(is);
    int cnt = wb.getNumberOfSheets();

    sb.append("<dataset>\n");

    for (int i = 0; i < cnt; i++) {
        String name = wb.getSheetName(i);

        if (name.indexOf(tableName) != -1) {
            sb.append(loadSheetXML(wb, name));
        }//from   w w w .j a va  2 s .co  m
    }
    sb.append("</dataset>\n");
    return sb.toString();
}

From source file:gov.nih.nci.ncicb.cadsr.bulkloader.util.excel.DBExcelUtility.java

License:BSD License

public String getExcelDataSet(InputStream is, ArrayList allTablesList) throws Exception {
    StringBuffer sb = new StringBuffer();
    HSSFWorkbook wb = ExcelUtility.createWorkbook(is);
    int cnt = wb.getNumberOfSheets();

    sb.append("<dataset>\n");
    tblsList = new ArrayList();

    for (int i = 0; i < cnt; i++) {
        String name = wb.getSheetName(i);

        if (name.startsWith("tbl_") || name.startsWith("TBL_")) {
            sb.append(loadSheetXML(wb, name));
        }//from ww w.j a v a 2 s  .co m
    }
    sb.append(appendOtherTables(allTablesList));
    sb.append("</dataset>\n");
    //System.out.println(sb.toString());
    return sb.toString();
}

From source file:gov.nih.nci.ncicb.cadsr.bulkloader.util.excel.DBExcelUtility.java

License:BSD License

public ExcelResultSet getExcelResultSet(InputStream is, String resultname) throws Exception {
    ExcelResultSet excelResultSet = null;
    HSSFWorkbook wb = ExcelUtility.createWorkbook(is);
    int cnt = wb.getNumberOfSheets();
    int row = 2;// w w w . ja  va 2  s  .c om
    int tblnamerow = 2;
    short col = 1;
    short tblnamecol = 1;

    for (int i = 0; i < cnt; i++) {
        String name = wb.getSheetName(i);

        if (name.startsWith("exp_") || name.startsWith("EXP_")) {
            HSSFSheet hssfsheet = ExcelUtility.createHSSFSheet(wb, name);

            String rsname = ExcelUtility.getString(hssfsheet, tblnamerow, tblnamecol);

            if (rsname.equalsIgnoreCase(resultname)) {
                excelResultSet = createExcelResultSet(hssfsheet);
                break;
            }
        }
    }
    return excelResultSet;
}

From source file:gov.nih.nci.ncicb.cadsr.bulkloader.util.excel.DBExcelUtility.java

License:BSD License

public ArrayList createDataObject(InputStream is, String resultname) throws Exception {
    ArrayList datalist = new ArrayList();
    ExcelResultSet excelResultSet = null;
    HSSFWorkbook wb = ExcelUtility.createWorkbook(is);
    int cnt = wb.getNumberOfSheets();
    int row = 2;/*from w  w w . j a  v  a2s  .  c om*/
    int tblnamerow = 2;
    short col = 1;
    short tblnamecol = 1;

    for (int i = 0; i < cnt; i++) {
        String name = wb.getSheetName(i);

        if (name.startsWith("event_") || name.startsWith("EVENT_")) {
            HSSFSheet hssfsheet = ExcelUtility.createHSSFSheet(wb, name);
            String rsname = ExcelUtility.getString(hssfsheet, tblnamerow, tblnamecol);

            //System.out.println(rsname + "," + resultname);
            if (rsname.equalsIgnoreCase(resultname)) {
                excelResultSet = createExcelResultSet(hssfsheet);
                if (excelResultSet != null) {
                    ArrayList rows = excelResultSet.getRows();
                    String[] colnames = excelResultSet.getColumns();
                    String[] coltypes = excelResultSet.getType();
                    String[] convertedtypes = convertDataTypes(coltypes);
                    String classname = excelResultSet.getClassname();
                    int rowcnt = rows.size();

                    for (int x = 0; x < rowcnt; x++) {
                        ExcelRow ro = (ExcelRow) (rows.get(x));
                        Object object = excelRowToObject(ro, classname, colnames, convertedtypes);

                        if (object != null) {
                            datalist.add(object);
                        }
                    }
                }
            }
        }
    }
    return datalist;
}