Examples of jxl.write.WritableWorkbook

jxl.write.WritableWorkbook
A writable workbook

   */
  public static WritableWorkbook createWorkbook(OutputStream os,
                                                WorkbookSettings ws)
    throws IOException
  {
    WritableWorkbook w = new WritableWorkbookImpl(os, false, ws);
    return w;
  }

View Full Code Here

  {
    logger.info("Reading...");
    Workbook w1 = Workbook.getWorkbook(inputWorkbook);


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


    if (inputWorkbook.getName().equals("jxlrwtest.xls"))
    {
      modify(w2);
    }


    w2.write();
    w2.close();
    logger.info("Done");
  }

View Full Code Here


    }


    @Override
    public void writeAll() throws FileNotFoundException, IOException{
        WritableWorkbook workbook = Workbook.createWorkbook(outputFile);
        WritableSheet sheet = workbook.createSheet("results", 0);


        try {
            sheet.addCell(new Label(0, 0, "NUMBER OF PILE ELEMENTS"));
            sheet.addCell(new Label(0, 1, "PILE LENGTH (m)"));
            sheet.addCell(new Label(0, 2, "PILE EI (KN M²)"));
            sheet.addCell(new Label(0, 3, "DIAMETER OF PILE (m)"));
            sheet.addCell(new Label(0, 4, "NUMBER OF INCREMENTAL SOIL DISPLACEMENTS"));
            
            sheet.addCell(new jxl.write.Number(5, 0, data.getNumOfElements()));
            sheet.addCell(new jxl.write.Number(5, 1, data.getPileLength()));
            sheet.addCell(new jxl.write.Number(5, 2, data.getEI()));
            sheet.addCell(new jxl.write.Number(5, 3, data.getPileDiameter()));
            sheet.addCell(new jxl.write.Number(5, 4, data.getNumOfPiles()));


            sheet.addCell(new Label(0, 6, "DEPTH COORDINATES OF PILE NODES (M)"));
            int currentRow = 7;
            int elementCounter =0;
            for(int i=0;i<=(data.getNumOfElements()/5);i++){
                int col=0;
                for(int j=i*5;j<=(i*5)+4;j++){
                  if(elementCounter<=data.getNumOfElements()){
                      sheet.addCell(new jxl.write.Number(col,currentRow,data.getPileNodeCoordinate(j)));
                      col++;
                   }


                   elementCounter++;
             }
                   currentRow++;
            }
            sheet.addCell(new Label(0, currentRow+1, "MODULUS OF SUBGRADE REACTION OF SOIL (KN/M PER M)  AT EACH NODE"));
            currentRow+=2;
            elementCounter =0;
            for(int i=0;i<=(data.getNumOfElements()/5);i++){
                int col=0;
                for(int j=i*5;j<=(i*5)+4;j++){
                  if(elementCounter<=data.getNumOfElements()){
                      sheet.addCell(new jxl.write.Number(col,currentRow,data.getModOfSubgradeReaction(j)));
                      col++;
                   }


                   elementCounter++;
             }
                   currentRow++;
            }
            sheet.addCell(new Label(0, currentRow+1, "LATERAL SOIL MOVEMENTS AT VARIOUS DEPTHS (M)"));
            currentRow+=2;
            elementCounter =0;
            for(int i=0;i<=(data.getNumOfElements()/5);i++){
                int col=0;
                for(int j=i*5;j<=(i*5)+4;j++){
                  if(elementCounter<=data.getNumOfElements()){
                      sheet.addCell(new jxl.write.Number(col,currentRow,data.getLateralSoilMovement(j)));
                      col++;
                   }


                   elementCounter++;
             }
                   currentRow++;
            }


            sheet.addCell(new Label(0, currentRow+1, "LIMIT SOIL PRESSURE (KN/M²)"));
            currentRow+=2;
            elementCounter =0;
            for(int i=0;i<=(data.getNumOfElements()/5);i++){
                int col=0;
                for(int j=i*5;j<=(i*5)+4;j++){
                  if(elementCounter<=data.getNumOfElements()){
                      sheet.addCell(new jxl.write.Number(col,currentRow,data.getLimitSoilPressure(j)));
                      col++;
                   }


                   elementCounter++;
             }
                   currentRow++;
            }
            currentRow++;
            sheet.addCell(new Label(0,currentRow,"INCREMENT NO 1"));
            currentRow++;
            sheet.addCell(new Label(0,currentRow,"NUMBER OF ITERATIONS TO CONVERGE"));
            sheet.addCell(new jxl.write.Number(1, currentRow, result.getNumOfItrForConv()));
            currentRow+=2;
            sheet.addCell(new Label(0,currentRow,"NODE"));
            sheet.addCell(new Label(1,currentRow,"DEPTH (m)"));
            sheet.addCell(new Label(2,currentRow,"SOIL MOVEMENT (mm)"));
            sheet.addCell(new Label(3,currentRow,"SOIL PRESSURE (kPa)"));
            sheet.addCell(new Label(4,currentRow,"ABS LIMIT PRESSURE (kPa)"));
            currentRow++;
            for(int i=0;i<data.getNumOfElements()+1;i++){
                sheet.addCell(new jxl.write.Number(0, currentRow, i+1));
                sheet.addCell(new jxl.write.Number(1, currentRow, data.getPileNodeCoordinate(i)));
                sheet.addCell(new jxl.write.Number(2, currentRow, result.getSoilMovement(i)*1000));
                sheet.addCell(new jxl.write.Number(3, currentRow, result.getSoilPressure(i)));
                sheet.addCell(new jxl.write.Number(4, currentRow, result.getLimitPressure(i)));
                currentRow++;
            }
            currentRow+=2;
            sheet.addCell(new Label(0,currentRow,"NODE"));
            sheet.addCell(new Label(1,currentRow,"DEPTH (m)"));
            sheet.addCell(new Label(2,currentRow,"PILE DISPLACEMENT (mm)"));
            sheet.addCell(new Label(3,currentRow,"ROTATION (rad)"));
            sheet.addCell(new Label(4,currentRow,"BENDM (KNm)"));
            sheet.addCell(new Label(5,currentRow,"SHEAR FORCE (KN)"));
            currentRow++;
            for(int i=0;i<data.getNumOfElements()+1;i++){
                sheet.addCell(new jxl.write.Number(0, currentRow, i+1));
                sheet.addCell(new jxl.write.Number(1, currentRow, data.getPileNodeCoordinate(i)));
                sheet.addCell(new jxl.write.Number(2, currentRow, result.getDisplacement(i)*1000));
                sheet.addCell(new jxl.write.Number(3, currentRow, result.getRotation(i)));
                sheet.addCell(new jxl.write.Number(4, currentRow, result.getBendingMoment(i)));
                sheet.addCell(new jxl.write.Number(5, currentRow, result.getShearForce(i)));
                currentRow++;
            }


            
            
        } catch (WriteException ex) {
            Logger.getLogger(XLSWriter.class.getName()).log(Level.SEVERE, null, ex);
        }


        workbook.write();
        try {
            workbook.close();
        } catch (WriteException ex) {
            Logger.getLogger(XLSWriter.class.getName()).log(Level.SEVERE, null, ex);
        }

View Full Code Here

    
    // Set the content type and get the output stream.
    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);
    }


    buildExcelDocument(model, workbook, request, response);


    // Should we set the content length here?
    // response.setContentLength(workbook.getBytes().length);


    workbook.write();
    out.flush();
    workbook.close();
  }

View Full Code Here

    
    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);

View Full Code Here

  public static void writeXLS(File file, ArrayList<Test> tests, String summary,String detail,long time) throws Exception
  {
    ArrayList<KeyString> idflist=new ArrayList<KeyString>();
    
    System.out.println("Saving "+file.getName());
    WritableWorkbook workbook = Workbook.createWorkbook(file);
    WritableSheet header = workbook.createSheet("Experimental setup", 0);
    addHeader(header,tests);
    if(summary.contains("all")||summary.contains("performance"))
    {
      System.out.println("Generating performance summary sheet");
      WritableSheet sheet = workbook.createSheet("Performance summary", workbook.getNumberOfSheets());
      addPerformanceSheet(sheet,tests,time);
    }
    if(summary.contains("all")||summary.contains("disambiguation"))
    {
      System.out.println("Generating disambiguation summary sheet");
      WritableSheet  sheet = workbook.createSheet("Words leading to disambiguation", workbook.getNumberOfSheets());
      addDisambiguationSheet(sheet,tests);
    }
    if(summary.contains("all")||summary.contains("words"))
    {
      System.out.println("Problem summary sheet");
      WritableSheet docs = workbook.createSheet("Disambiguated words", workbook.getNumberOfSheets());
      addProblemSheet(docs,tests);
    }
    if(summary.contains("all")||summary.contains("overlap"))
    {
      System.out.println("Generating overlap summary sheet");
      WritableSheet sheet = workbook.createSheet("Overlap by IDF summary", workbook.getNumberOfSheets());
      if(idflist.size()==0)
        XLSWriter.retrieveIDFs(idflist, tests);
      addOverlapSheet(sheet, tests,idflist);
    }
    if(summary.contains("all")||summary.contains("sense"))
    {
      System.out.println("Generating sense stats sheet");
      WritableSheet sheet = workbook.createSheet("Algorithm behavior", workbook.getNumberOfSheets());
      addMiscSheet(sheet, tests);
    }
    if(detail.contains("all")||detail.contains("performance"))
    {
      System.out.println("Generating performance detail sheet");
      WritableSheet sheet = workbook.createSheet("Performance detail", workbook.getNumberOfSheets());
      addPerformanceDetailSheet(sheet,tests);
    }
    if(detail.contains("all")||detail.contains("disambiguation"))
    {
      System.out.println("Generating disambiguation detail sheet");
      WritableSheet  sheet = workbook.createSheet("Disambiguation detail", workbook.getNumberOfSheets());
      if(idflist.size()==0)
        XLSWriter.retrieveIDFs(idflist, tests);
      addDisambiguationDetailSheet(sheet,tests,idflist);
    }
    if(detail.contains("all")||detail.contains("words"))
    {
      System.out.println("Generating problem detail sheet");
      WritableSheet docs = workbook.createSheet("Problem detail", workbook.getNumberOfSheets());
      if(idflist.size()==0)
        XLSWriter.retrieveIDFs(idflist, tests);
      addProblemDetailSheet(docs,tests,idflist);
    }
    if(detail.contains("overlap"))
    {
      System.out.println("Generating overlap detail sheet");
      WritableSheet sheet = workbook.createSheet("Overlap detail", workbook.getNumberOfSheets());
      addOverlapDetailSheet(sheet,tests);
    }
    
    
    if(detail.contains("all")||detail.contains("sense"))
    {
      System.out.println("Generating sense detail sheet");
      WritableSheet sheet = workbook.createSheet("Disambiguation by sense number", workbook.getNumberOfSheets());
      addSenseSheet(sheet,tests);
    }    
    workbook.write();
    workbook.close();
    System.out.println(file.getName()+" saved");
  }

View Full Code Here

    
    // Set the content type and get the output stream.
    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);
    }


    buildExcelDocument(model, workbook, request, response);


    // Should we set the content length here?
    // response.setContentLength(workbook.getBytes().length);


    workbook.write();
    out.flush();
    workbook.close();
  }

View Full Code Here

   * @param book the book object to export
   * @param file the exported file destination
   * @return the jxl.write.WritableWorkbook
   */
  public Object exports(Book book, File file) {
    WritableWorkbook workbook = null;
    try {
      WorkbookSettings ws = new WorkbookSettings();
      ws.setLocale(new Locale("en", "EN"));
      workbook = Workbook.createWorkbook(file, ws);
      exportEachBook(book, workbook);
      workbook.write();
      workbook.close();
      onSuccess();
    } catch (IOException e) {
      e.printStackTrace();
      onFailure();
    } catch (WriteException e) {

View Full Code Here

  private void exportSheetImages(WritableSheet workSheet, Sheet zkSheet){
    
  }
  public void testExport() {
    try {
      WritableWorkbook workbook = null;
      WorkbookSettings ws = new WorkbookSettings();
      ws.setLocale(new Locale("en", "EN"));
      workbook = Workbook.createWorkbook(new File(_url), ws);
      WritableSheet s = workbook.createSheet("test", 0);
      WritableCellFormat cf1 = new WritableCellFormat(
          jxl.write.DateFormats.FORMAT2);


      jxl.write.DateTime dt = new jxl.write.DateTime(0, 1, new Date(),
          cf1);


      s.addCell(dt);


      workbook.write();
      workbook.close();
    } catch (Exception e) {
      e.printStackTrace();
    }
  }

View Full Code Here

  {
    this.template = (null == this.templateInputStream) ? null : loadTemplate( this.templateInputStream );
    this.templateSheet = (null == this.template) ? null : this.template.getSheet( 0 );


    final BaseSpreadsheet wb = (BaseSpreadsheet) this.model;
    final WritableWorkbook xwb = createWorkbook();
    try {
      saveWorkbook( wb, xwb );
      xwb.write();
      xwb.close();
    }
    catch (JXLException e) {
      throw new SpreadsheetException.SaveError( e );
    }
  }

View Full Code Here

0 1 2

TOP

Related Classes of jxl.write.WritableWorkbook

com.iisigroup.cap.rule.handler.RuleTbMntHandler

com.impetus.kundera.benchmark.WriteToExcelFile

com.vsked.excel.ExcelOperate

edu.zzuli.util.ExcelHandle

gannuWSD.testing.XLSWriter

it.pdor.webapp.contabilita.stampeContabili.bilancio.BilancioExcel

jxl.demo.ReadWrite

jxl.Workbook

net.sourceforge.squirrel_sql.fw.gui.action.TableExportCsvCommand

org.dspace.app.cris.batch.ScriptStatSubscribe

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.