Package jxl

Examples of jxl.Workbook


    super(dataset, parametersMap);
  }

  public JRDataSource createDatasource() throws JRException {
    try {
      Workbook workbook = (Workbook) getParameterValue(JRXlsQueryExecuterFactory.XLS_WORKBOOK);
      if (workbook != null) {
        datasource = new JRXlsDataSource(workbook);
      } else {
        InputStream xlsInputStream = (InputStream) getParameterValue(JRXlsQueryExecuterFactory.XLS_INPUT_STREAM);
        if (xlsInputStream != null) {
View Full Code Here


            protected void invokeApplication() throws Exception {

                Renderer.instance().render("/simple.xhtml");

                DocumentData data = (DocumentData) Contexts.getEventContext().get("testExport");
                Workbook workbook = Workbook.getWorkbook(new ByteArrayInputStream(((ByteArrayDocumentData)data).getData()));
                Sheet sheet = workbook.getSheet("Developers");
               
                assert sheet != null;

                assert "Daniel Roth".equals(sheet.getCell(0, 0).getContents());
                assert "Nicklas Karlsson".equals(sheet.getCell(0, 1).getContents());
View Full Code Here

public class JExcelDocumentHandler extends AbstractTypeFileDocumentHandler {

  protected String extractText(InputStream inputStream) throws IOException {
    StringBuffer text=new StringBuffer();
    try {
      Workbook workbook=Workbook.getWorkbook(inputStream);
      for(int cpt = 0; cpt<workbook.getNumberOfSheets(); cpt++) {
        Sheet sheet = workbook.getSheet(cpt);
        extractTextFromSheet(sheet,text);
      }
    } catch(BiffException ex) {
      ex.printStackTrace();
    }
View Full Code Here

        this._useFirstSheet = true;
    }

    public void parseFile(InputStream inStream) {
        try {
            Workbook workbook = Workbook.getWorkbook( inStream );

            if ( _useFirstSheet ) {
                Sheet sheet = workbook.getSheet( 0 );
                processSheet( sheet,
                              (List) _listners.get( DEFAULT_RULESHEET_NAME ) );
            } else {
                Set sheetNames = _listners.keySet();
                for ( Iterator iter = sheetNames.iterator(); iter.hasNext(); ) {
                    String sheetName = (String) iter.next();
                    Sheet sheet = workbook.getSheet( sheetName );
                    processSheet( sheet,
                                  (List) _listners.get( sheetName ) );

                }
            }
View Full Code Here

    return readExcel(rs, 0, rs.getRows(), 0, rs.getColumns());
  }

  public Sheet getSheet(String filename, int index) throws BiffException, IOException {
    InputStream is = null;
    Workbook rwb = null;
    Sheet rs = null;
    try {
      is = new FileInputStream(filename);
      rwb = Workbook.getWorkbook(is);
      rs = rwb.getSheet(0);
    } finally {
      if (is != null)
        is.close();
    }
    return rs;
View Full Code Here

    }

    public void parseFile(InputStream inStream) {
        try {
            WorkbookSettings ws = new WorkbookSettings();
            Workbook workbook = Workbook.getWorkbook( inStream, ws);

            if ( _useFirstSheet ) {
                Sheet sheet = workbook.getSheet( 0 );
                processSheet( sheet,
                              _listeners.get( DEFAULT_RULESHEET_NAME ) );
            } else {
                for ( String sheetName : _listeners.keySet() ) {
                    Sheet sheet = workbook.getSheet( sheetName );
                    processSheet( sheet,
                                  _listeners.get( sheetName ) );

                }
            }
View Full Code Here

    }

    public void parseFile(InputStream inStream) {
        try {
            WorkbookSettings ws = new WorkbookSettings();
            Workbook workbook = Workbook.getWorkbook( inStream, ws);

            if ( _useFirstSheet ) {
                Sheet sheet = workbook.getSheet( 0 );
                processSheet( sheet,
                              _listeners.get( DEFAULT_RULESHEET_NAME ) );
            } else {
                for ( String sheetName : _listeners.keySet() ) {
                    Sheet sheet = workbook.getSheet( sheetName );
                    if (sheet == null) {
                        throw new IllegalStateException("Could not find the sheetName (" + sheetName
                                + ") in the workbook sheetNames (" + Arrays.toString(workbook.getSheetNames()) + ").");
                    }
                    processSheet( sheet,
                                  _listeners.get( sheetName ) );

                }
View Full Code Here

        ReadWrite rw = new ReadWrite(file, outputFile);
        rw.readWrite();
      }
      else if (formulas)
      {
        Workbook w = Workbook.getWorkbook(new File(file));
        Formulas f = new Formulas(w, System.out, encoding);
        w.close();
      }
      else if (features)
      {
        Workbook w = Workbook.getWorkbook(new File(file));
        Features f = new Features(w, System.out, encoding);
        w.close();
      }
      else if (escher)
      {
        Workbook w = Workbook.getWorkbook(new File(file));
        Escher f = new Escher(w, System.out, encoding);
        w.close();
      }
      else if (escherdg)
      {
        Workbook w = Workbook.getWorkbook(new File(file));
        EscherDrawingGroup f = new EscherDrawingGroup(w, System.out, encoding);
        w.close();
      }
      else if (biffdump)
      {
        BiffDump bd = new BiffDump(new File(file), System.out);
      }
      else if (jxlversion)
      {
        WriteAccess bd = new WriteAccess(new File(file));
      }
      else if (propertysets)
      {
        OutputStream os = System.out;
        if (outputFile != null)
        {
          os = new FileOutputStream(outputFile);
        }
        PropertySetsReader psr = new PropertySetsReader(new File(file),
                                                        propertySet,
                                                        os);
      }
      else
      {
        Workbook w = Workbook.getWorkbook(new File(file));
       
        //        findTest(w);

        if (format == CSVFormat)
        { 
          CSV csv = new CSV(w, System.out, encoding, hideCells);
        }
        else if (format == XMLFormat)
        {
          XML xml = new XML(w, System.out, encoding, formatInfo);
        }
       
        w.close();
      }
    }
    catch (Throwable t)
    {
      System.out.println(t.toString());
View Full Code Here

   * @exception BiffException
   */
  public void readWrite() throws IOException, BiffException, WriteException
  {
    logger.info("Reading...");
    Workbook w1 = Workbook.getWorkbook(inputWorkbook);

    logger.info("Copying...");
    WritableWorkbook w2 = Workbook.createWorkbook(outputWorkbook, w1);

    if (inputWorkbook.getName().equals("jxlrwtest.xls"))
View Full Code Here

            DialogManager.error("CannotRead{0}", fileName);

            return null;
        }

        Workbook workbook = Workbook.getWorkbook(file);

        Sheet sheet = workbook.getSheets()[0];

        Cell[] headerCells = sheet.getRow(0);

        StructModel s = new StructModel("A");
View Full Code Here

TOP

Related Classes of jxl.Workbook

Copyright © 2018 www.massapicom. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.