Examples of jxl.Workbook

jxl.Workbook
Represents a Workbook. Contains the various factory methods and provides a variety of accessors which provide access to the work sheets.

    response.setContentType(getContentType());
    OutputStream out = response.getOutputStream();


    WritableWorkbook workbook;
    if (this.url != null) {
      Workbook template = getTemplateSource(this.url, request);
      workbook = Workbook.createWorkbook(out, template);
    } 
    else {
      logger.debug("Creating Excel Workbook from scratch");
      workbook = Workbook.createWorkbook(out);

View Full Code Here

  /* (non-Javadoc)
   * @see net.sourceforge.squirrel_sql.plugins.dataimport.importer.IFileImporter#getPreview(int)
   */
  public String[][] getPreview(int noOfLines) throws IOException {
    String[][] data = null;
    Workbook wb = null;
    Sheet sht = null; 
    try {
      wb = Workbook.getWorkbook(importFile);
      sht = getSheet(wb);
    } catch (BiffException be) {
      throw new IOException(be.toString());
    }


    int y = 0;
    int x = 0;
    int maxLines = (noOfLines < sht.getRows()) ? noOfLines : sht.getRows();
    data = new String[maxLines][sht.getColumns()];


    for (y = 0; y < maxLines; y++) {
      for (x = 0; x < sht.getColumns(); x++) {
        data[y][x] = sht.getCell(x, y).getContents();
      }
    }
    wb.close();
    
    return data;
  }

View Full Code Here

    });


    docFileURL = (instance != null ? definition.evaluateContent(instance, docFileURL).toString() : docFileURL);
    
    InputStream is = new URL(docFileURL).openStream();
    Workbook workbook = Workbook.getWorkbook(is);


    String tempFName = defaultValue.getSavingFileName(instance);
    WritableWorkbook copy = Workbook.createWorkbook(new File(tempFName), workbook); 
  
    WritableSheet sheets[] = copy.getSheets(); 
//System.out.println("  ExcelSheetActivity:getWIHAddress: start parsing file");


    for(int i=0; i<sheets.length; i++){
      WritableSheet sheet = sheets[i];
        
      for(int row = 0; row < sheet.getRows(); row++){
        boolean newRowInserted=false;
        
        for(int col = 0; col < sheet.getColumns(); col++){            
          WritableCell cell = sheet.getWritableCell(col,row);
          
          if (cell.getType() == CellType.LABEL) 
          {
            Label l = (Label) cell;        
            String expression = l.getString();
            
            if(expression.startsWith("<%=+")){
//System.out.println("expression:"+expression);
              
              if(!newRowInserted){
                newRowInserted = true;
                sheet.insertRow(row);
              }
              //l.setString(expression);
/*
                WritableCell existingCell = sheet.getWritableCell(col,row);
                Label ecl = (Label) existingCell;
                ecl.setString(                
                  EMailActivity.parseContent(expression, this, instance).toString()
                );*/
              
              jxl.format.CellFormat style = l.getCellFormat();
              WritableCell label = new Label(col,row, definition.evaluateContent(instance, expression).toString(), style); 
              sheet.addCell(label);
              
            }else
            if(expression.indexOf("<%=") > -1 || expression.indexOf("<%=*") > -1){ //if the expression contains any value need to evaluate.
//System.out.println("expression:"+expression);
              l.setString(
                definition.evaluateContent( instance, expression).toString()
              );
//System.out.println("evaluated:"+l.getString());
            }else
            if(expression.startsWith("<%->")){
              l.setString("");
            }else
            if(expression.startsWith("<%<-")){
              WritableCell leftCell = sheet.getWritableCell(col-1,row);
              Label lcl = (Label) leftCell;          
              lcl.setString(
                definition.evaluateContent(instance, expression).toString()
              );
              
              l.setString("");
              }
            }                                    
          }  
          
          if(newRowInserted) row++;
        }
        
      }
            
      copy.write(); 
      copy.close();
    
    Uploader uploader = new Uploader();
    uploader.connect(defaultValue.getFtpAddress(), defaultValue.getFtpUserId(), defaultValue.getFtpPassword());
    uploader.uploadFile(tempFName, defaultValue.getFtpDirectory() + "/" + tempFName);   


    setPath(defaultValue.getFullSavingFTPURL(instance));
    
    is.close();
    workbook.close();      
  }

View Full Code Here

      String targetUrlStr = defaultValue.getFullSavingFTPURL(instance);
      
      try{
        InputStream is = new URL(targetUrlStr).openStream();
        
        Workbook workbook = Workbook.getWorkbook(tis);
        Workbook resultWorkbook = Workbook.getWorkbook(is);    
        
        Sheet resultSheets[] = resultWorkbook.getSheets(); 
        Sheet sheets[] = workbook.getSheets(); 
        
        for(int i=0; i<sheets.length; i++){
          Sheet sheet = sheets[i];
          Sheet resultSheet = resultSheets[i];
          
          for(int col = 0; col < sheet.getColumns(); col++){
            for(int row = 0; row < sheet.getRows(); row++){
              try{
                Cell cell = sheet.getCell(col,row);        
        
                String expression = cell.getContents();
  //  System.out.println("ExcelActivity:: onComplete: expression:"+expression);
                if(expression.startsWith("<%=*")){ //if the expression contains any value need to evaluate.
                  String k = expression.substring(4, expression.indexOf("%>"));
  //  System.out.println("ExcelActivity:: key:"+k);
                  Cell resultCell = resultSheet.getCell(col, row);
                  String val = resultCell.getContents();
  //  System.out.println("ExcelActivity:: val:"+val);
                  definition.getProcessVariable(k).set(instance, "", val);
                }else
                if(expression.startsWith("<%->")){ //if the expression contains any value need to evaluate.
                  String k = expression.substring(4, expression.indexOf("%>"));
                  Cell resultCell = resultSheet.getCell(col-1, row);
                  String val = resultCell.getContents();
                  definition.getProcessVariable(k).set(instance, "", val);
                }
              }catch(Exception e){
  //  System.out.println("ExcelActivity:: error in setting value");
                e.printStackTrace();
              }
            }
          }
        }
        
        is.close();
        tis.close();  
        workbook.close();
        resultWorkbook.close();
      }catch(java.io.FileNotFoundException fne){
        new UEngineException("File result is not found. You might never open or edit a required document.");
      }


    }

View Full Code Here

   * @throws BiffException
   * @throws IOException
   * @throws FormulaException
   */
  public Book importFromStream(InputStream is, String name) {
    Workbook wb = null;
    try {
      //is = Locators.getDefault().getResourceAsStream(filePath);
      //Returns null?
      wb = ZssWorkbookParser.getWorkbook(is);
      BookImpl book = new BookImpl(name);
      
      jxl.Sheet[] sheets = wb.getSheets();
      
      /*   
       * Create sheets and add them to book first. 
       * Then you fill in cells inside the sheet.
       */
      for (int i = 0; i < sheets.length; i++) {
        jxl.Sheet jsheet = sheets[i];
        Sheet sh = book.addSheet(jsheet.getName(), jsheet
              .getColumns(), jsheet.getRows());
      }
      /*
       * Named ranges need to be imported before the formula
       */
      importNamedRanges(wb,book);
      final List zksheets = book.getSheets();
      for (int i = 0; i < sheets.length; i++) {
        jxl.Sheet jsheet = sheets[i];
        importEachSheet(wb, (SheetImpl) zksheets.get(i), jsheet); 
      }
      return book;
    } catch (Exception ex) {
      throw ModelException.Aide.wrap(ex);
    } finally {
      if (wb != null) {
        wb.close();
      }
    }
  }

View Full Code Here

    response.setContentType(getContentType());
    OutputStream out = response.getOutputStream();


    WritableWorkbook workbook;
    if (this.url != null) {
      Workbook template = getTemplateSource(this.url, request);
      workbook = Workbook.createWorkbook(out, template);
    } 
    else {
      logger.debug("Creating Excel Workbook from scratch");
      workbook = Workbook.createWorkbook(out);

View Full Code Here

      }
    };


    excelView.render(new HashMap(), request, response);


    Workbook wb = Workbook.getWorkbook(new ByteArrayInputStream(response.getContentAsByteArray()));
    assertEquals("Test Sheet", wb.getSheet(0).getName());
    Sheet sheet = wb.getSheet("Test Sheet");
    Cell cell = sheet.getCell(2, 4);
    assertEquals("Test Value", cell.getContents());
  }

View Full Code Here


    excelView.setApplicationContext(webAppCtx);
    excelView.setUrl("template");
    excelView.render(new HashMap(), request, response);


    Workbook wb = Workbook.getWorkbook(new ByteArrayInputStream(response.getContentAsByteArray()));
    Sheet sheet = wb.getSheet("Sheet1");
    Cell cell = sheet.getCell(0, 0);
    assertEquals("Test Template", cell.getContents());
  }

View Full Code Here


    excelView.setApplicationContext(webAppCtx);
    excelView.setUrl("template");
    excelView.render(new HashMap(), request, response);


    Workbook wb = Workbook.getWorkbook(new ByteArrayInputStream(response.getContentAsByteArray()));
    Sheet sheet = wb.getSheet("Sheet1");
    Cell cell = sheet.getCell(0, 0);
    assertEquals("Test Template American English", cell.getContents());
  }

View Full Code Here


    excelView.setApplicationContext(webAppCtx);
    excelView.setUrl("template");
    excelView.render(new HashMap(), request, response);


    Workbook wb = Workbook.getWorkbook(new ByteArrayInputStream(response.getContentAsByteArray()));
    Sheet sheet = wb.getSheet("Sheet1");
    Cell cell = sheet.getCell(0, 0);
    assertEquals("Test Template auf Deutsch", cell.getContents());
  }

View Full Code Here

0 1 2 3 4

TOP

Related Classes of jxl.Workbook

br.eti.kinoshita.selenium.DataDrivenSeleniumWebTest

com.nexirius.multimail.datamodel.ImportArrayModel

com.stimulus.archiva.extraction.ExcelExtractor

com.vsked.excel.ExcelOperate

importation.xls.XlsImportateur

it.pdor.webapp.contabilita.component.fileUpload.CaricamentoDiExcelMovimentiContabili

jxl.demo.Demo

jxl.demo.ReadWrite

jxl.read.biff.File

jxl.read.biff.WorkbookParser

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.