Examples of jxl.write.Number

jxl.write.Number
A cell, created by user applications, which contains a numerical value

      sheet.addCell(new Label(0,goffset,entry.getKey()));
      int z;
      for(z=0;z<counts.length;z++)
      {
          if(z==(counts.length-1))
            sheet.addCell(new Number(1+z, goffset, counts[z],boldnumber));
          else
            sheet.addCell(new Number(1+z, goffset, counts[z],number));
          
      }
      sheet.addCell(new Number(1+z,goffset,XLSWriter.getIDF(idfList,entry.getKey()),boldnumber));
      goffset++;
    }
    
  }

View Full Code Here

        Summary summary=test.getSummaries().get(d);
        double[]p=Measures.Precision(summary);
        double[]r=Measures.Recall(summary);
        double[]c=Measures.Coverage(summary);
        double[]f=Measures.Fmeasure(summary);
        sheet.addCell(new Number(1, offset, p[4],boldnumber));
        sheet.addCell(new Number(2, offset, r[4],boldnumber));
        sheet.addCell(new Number(3, offset, c[4],boldnumber));
        sheet.addCell(new Number(4, offset, f[4],boldnumber));
        global.add(summary);
        d++;
        offset++;
      }
      sheet.addCell(new Label(0,offset,"Overall:"));
      double[]p=Measures.Precision(global);
      double[]r=Measures.Recall(global);
      double[]c=Measures.Coverage(global);
      double[]f=Measures.Fmeasure(global);
      sheet.addCell(new Number(1, offset, p[4],boldnumber));
      sheet.addCell(new Number(2, offset, r[4],boldnumber));
      sheet.addCell(new Number(3, offset, c[4],boldnumber));
      sheet.addCell(new Number(4, offset, f[4],boldnumber));
      sheet.addCell(new Number(5, offset, time,boldnumber));
      offset++;
      offset++;
      offset++;
    }
  }

View Full Code Here

        double[]f=Measures.Fmeasure(summary);
        for(int j=0;j<4;j++)
        {
          if(j==4)
          {
            sheet.addCell(new Number(j*4+1, offset, p[j],boldnumber));
            sheet.addCell(new Number(j*4+2, offset, r[j],boldnumber));
            sheet.addCell(new Number(j*4+3, offset, c[j],boldnumber));
            sheet.addCell(new Number(j*4+4, offset, f[j],boldnumber));
          }
          else
          {
            sheet.addCell(new Number(j*4+1, offset, p[j],number));
            sheet.addCell(new Number(j*4+2, offset, r[j],number));
            sheet.addCell(new Number(j*4+3, offset, c[j],number));
            sheet.addCell(new Number(j*4+4, offset, f[j],number));
          }
        }
        global.add(summary);
        d++;
        offset++;
      }
      sheet.addCell(new Label(0,offset,"Overall:"));
      double[]p=Measures.Precision(global);
      double[]r=Measures.Recall(global);
      double[]c=Measures.Coverage(global);
      double[]f=Measures.Fmeasure(global);
      for(int j=0;j<4;j++)
      {
        sheet.addCell(new Number(j*4+1, offset, p[j],boldnumber));
        sheet.addCell(new Number(j*4+2, offset, r[j],boldnumber));
        sheet.addCell(new Number(j*4+3, offset, c[j],boldnumber));
        sheet.addCell(new Number(j*4+4, offset, f[j],boldnumber));
      }
      offset++;
      offset++;
      offset++;
    }

View Full Code Here

            gcorrect+=1.0d/total;
          }
          polisemy+=(double)decision.getSenseCount()/((double)decisions.size());
          gpolisemy+=(double)decision.getSenseCount()/total;
        }
        sheet.addCell(new Number(1, offset, words,number)); 
        sheet.addCell(new Number(2, offset, senses,number));
        sheet.addCell(new Number(3, offset, correct,number));
        sheet.addCell(new Number(4, offset, polisemy,number));
        sheet.addCell(new Number(5, offset, score,number));
        offset++;
        i++;
      }
      sheet.addCell(new Label(0,offset,"overall"));
      sheet.addCell(new Number(1, offset, gwords,boldnumber)); 
      sheet.addCell(new Number(2, offset, gsenses,boldnumber));
      sheet.addCell(new Number(3, offset, gcorrect,boldnumber));
      sheet.addCell(new Number(4, offset, gpolisemy,boldnumber));
      sheet.addCell(new Number(5, offset, gscore,boldnumber));
      offset++;
      offset++;
    }
  }

View Full Code Here

          }
          //Print
          for(int i=0;i<10;i++)
          {
            sheet.addCell(new Label(0, offset, String.valueOf(i+1)));
            sheet.addCell(new Number(1, offset, lgiven[i])); 
            sheet.addCell(new Number(2, offset, lcorrect[i]));
            sheet.addCell(new Number(3, offset, lans[i]));
            sheet.addCell(new Number(4, offset, ladd[i]));
            sheet.addCell(new Number(5, offset, laddc[i]));
            sheet.addCell(new Number(6, offset, 100.0*lcorrect[i]/lgiven[i]));
            sheet.addCell(new Number(7, offset, 100.0*lcorrect[i]/lans[i]));
            sheet.addCell(new Number(8, offset, 100.0*lgiven[i]/lans[i]));
            sheet.addCell(new Number(9, offset, 100.0*ladd[i]/lans[i]-100.0));
            sheet.addCell(new Number(10, offset, 100.0*laddc[i]/ladd[i]));
            offset++;
          }
        }
        sheet.addCell(new Label(12, foffset, "Overall"));
        foffset++;
        sheet.addCell(new Label(12, foffset, "Sense number"));
        sheet.addCell(new Label(13, foffset, "Given answers")); 
        sheet.addCell(new Label(14, foffset, "Correct answers"));
        sheet.addCell(new Label(15, foffset, "Total answers"));
        sheet.addCell(new Label(16, foffset, "Total addresed"));
        sheet.addCell(new Label(17, foffset, "Total addresed correctly"));
        sheet.addCell(new Label(18, foffset, "P"));
        sheet.addCell(new Label(19, foffset, "R"));
        sheet.addCell(new Label(20, foffset, "C"));
        sheet.addCell(new Label(21, foffset, "OverFit"));
        sheet.addCell(new Label(22, foffset, "Addressing precision"));
        sheet.addCell(new Label(23, foffset, "Noun P"));
        sheet.addCell(new Label(24, foffset, "Verb P"));
        sheet.addCell(new Label(25, foffset, "Adjective P"));
        sheet.addCell(new Label(26, foffset, "Adverb P"));
        foffset++;
        for(int i=0;i<10;i++)
        {
          sheet.addCell(new Label(12, foffset, String.valueOf(i+1)));
          sheet.addCell(new Number(13, foffset, given[i])); 
          sheet.addCell(new Number(14, foffset, correct[i]));
          sheet.addCell(new Number(15, foffset, ans[i]));
          sheet.addCell(new Number(16, foffset, add[i]));
          sheet.addCell(new Number(17, foffset, addc[i]));
          sheet.addCell(new Number(18, foffset, 100.0*correct[i]/given[i]));
          sheet.addCell(new Number(19, foffset, 100.0*correct[i]/ans[i]));
          sheet.addCell(new Number(20, foffset, 100.0*given[i]/ans[i]));
          sheet.addCell(new Number(21, foffset, 100.0*add[i]/ans[i]-100.0));
          sheet.addCell(new Number(22, foffset, 100.0*addc[i]/add[i]));
          for(int j=0;j<4;j++)
            sheet.addCell(new Number(23+j, foffset, 100.0*posc[j][i]/pos[j][i]));
          foffset++;
        }
      }
    }

View Full Code Here




        WritableSheet sheetCoordenadas = libroTrabajoSalida.getSheet(this.hojaHeuristica);
        //Primero completamos la nueva columna
        for (int i = 0; i < limiteHeuristica.getFilas() + 1; i++) {
            Number heuristicaCol = new Number(limiteHeuristica.getColumnas() + 1, i + 1, 0);
            try {
                sheetCoordenadas.addCell(heuristicaCol);
            } catch (WriteException ex) {
                System.out.println("Aqui es el error");
                Logger.getLogger(ArchivoExcelBaseConocimiento.class.getName()).log(Level.SEVERE, null, ex);
            }
        }
        //Segundo completamos la nueva fila
        for (int i = 0; i < limiteHeuristica.getColumnas() + 1; i++) {
            Number heuristicaFila = new Number(i + 1, limiteHeuristica.getFilas() + 1, 0);
            try {
                sheetCoordenadas.addCell(heuristicaFila);
            } catch (WriteException ex) {
                System.out.println("Aqui es el error");
                Logger.getLogger(ArchivoExcelBaseConocimiento.class.getName()).log(Level.SEVERE, null, ex);

View Full Code Here

        }




        WritableSheet sheetCoordenadas = libroTrabajoSalida.getSheet(this.hojaCoordenadasPuntos);


        Number coordenadaXCelda = new Number(1, limiteCoordenadas.getFilas() + 1, coordenadaX);
        Number coordenadaYCelda = new Number(2, limiteCoordenadas.getFilas() + 1, coordenadaY);


        try {
            sheetCoordenadas.addCell(coordenadaXCelda);
            sheetCoordenadas.addCell(coordenadaYCelda);
        } catch (WriteException ex) {

View Full Code Here

            //recordar que primero son las columnas y luego filas
            WritableCell celdaFilas = sheetReglas.getWritableCell(1, 3);
            WritableCell celdaColumnas = sheetReglas.getWritableCell(2, 3);


            if (celdaFilas.getType() == CellType.NUMBER) {
                Number n = (Number) celdaFilas;
                n.setValue(numeroFilas);
            }
            if (celdaColumnas.getType() == CellType.NUMBER) {
                Number n = (Number) celdaColumnas;
                n.setValue(numeroColumnas);
            }
        } else if (tipo == ArchivoExcelBaseConocimiento.NOMBRESPUNTOS) {
            WritableSheet sheetReglas = libroTrabajoSalida.getSheet(this.hojaConfiguraciones);
            //recordar que primero son las columnas y luego filas
            WritableCell celdaFilas = sheetReglas.getWritableCell(1, 2);
            WritableCell celdaColumnas = sheetReglas.getWritableCell(2, 2);


            if (celdaFilas.getType() == CellType.NUMBER) {
                Number n = (Number) celdaFilas;
                n.setValue(numeroFilas);
            }
            if (celdaColumnas.getType() == CellType.NUMBER) {
                Number n = (Number) celdaColumnas;
                n.setValue(numeroColumnas);
            }
        } else if (tipo == ArchivoExcelBaseConocimiento.HEURISTICA) {
            WritableSheet sheetReglas = libroTrabajoSalida.getSheet(this.hojaConfiguraciones);
            //recordar que primero son las columnas y luego filas
            WritableCell celdaFilas = sheetReglas.getWritableCell(1, 1);
            WritableCell celdaColumnas = sheetReglas.getWritableCell(2, 1);


            if (celdaFilas.getType() == CellType.NUMBER) {
                Number n = (Number) celdaFilas;
                n.setValue(numeroFilas);
            }
            if (celdaColumnas.getType() == CellType.NUMBER) {
                Number n = (Number) celdaColumnas;
                n.setValue(numeroColumnas);
            }
        } else if (tipo == ArchivoExcelBaseConocimiento.COORDENADASPUNTOS) {
            WritableSheet sheetReglas = libroTrabajoSalida.getSheet(this.hojaConfiguraciones);
            //recordar que primero son las columnas y luego filas
            WritableCell celdaFilas = sheetReglas.getWritableCell(1, 0);
            WritableCell celdaColumnas = sheetReglas.getWritableCell(2, 0);


            if (celdaFilas.getType() == CellType.NUMBER) {
                Number n = (Number) celdaFilas;
                n.setValue(numeroFilas);
            }
            if (celdaColumnas.getType() == CellType.NUMBER) {
                Number n = (Number) celdaColumnas;
                n.setValue(numeroColumnas);
            }
        }


        try {
            libroTrabajoSalida.write();

View Full Code Here

      
      WritableCellFormat cfIntRight = new WritableCellFormat(wfNormal, df_);
      cfIntRight.setAlignment(Alignment.RIGHT);
      
      Label cellValue;
      Number cellNumber;
      int col = 0;
      cellValue = new Label(col, 2, "", cfBold);
      sheet.setColumnView(col, 10);
      sheet.addCell(cellValue);
      col++;
      cellValue = new Label(col, 2, "Gruppo", cfBold);
      sheet.setColumnView(col, 10);
      sheet.addCell(cellValue);
      col++;
      cellValue = new Label(col, 2, "Mastro", cfBold);
      sheet.setColumnView(col, 10);
      sheet.addCell(cellValue);
      if(visible) 
      {
        col++;
        cellValue = new Label(col, 2, "Conto", cfBold);
        sheet.setColumnView(col, 10);
        sheet.addCell(cellValue);
      }
      col++;
      cellValue = new Label(col, 2, "Descrizione", cfBold);
      sheet.setColumnView(col, 40);
      sheet.addCell(cellValue);
      col++;
      cellValue = new Label(col, 2, "Dare", cfBold);
      sheet.setColumnView(col, 20);
      sheet.addCell(cellValue);
      col++;
      cellValue = new Label(col, 2, "Avere", cfBold);
      sheet.setColumnView(col, 20);
      sheet.addCell(cellValue);
      col++;
      cellValue = new Label(col, 2, "Dare extr.", cfBold);
      sheet.setColumnView(col, 20);
      sheet.addCell(cellValue);
      col++;
      cellValue = new Label(col, 2, "Avere Extr.", cfBold);
      sheet.setColumnView(col, 20);
      sheet.addCell(cellValue);
      col++;
      cellValue = new Label(col, 2, "Saldo Dare", cfBold);
      sheet.setColumnView(col, 20);
      sheet.addCell(cellValue);
      col++;
      cellValue = new Label(col, 2, "Saldo Avere", cfBold);
      sheet.setColumnView(col, 20);
      sheet.addCell(cellValue);
      
      int riga = 2;
      
      for (RowBilancio bilancio : listaBilancio) 
      {
        riga++;
        col = 0;
        if((StringUtility.checkNull(bilancio.getTipoAttivita())).equals("&#160;")) {
          cellValue = new Label(col, riga, "", cfNormal);
        } else {
          cellValue = new Label(col, riga, StringUtility.checkNull(bilancio.getTipoAttivita()), cfBold);
        }
        sheet.addCell(cellValue);
        
        col++;
        if((StringUtility.checkNull(bilancio.getGruppo())).equals("&#160;")) {
          cellValue = new Label(col, riga, "", cfIntNumber);
          sheet.addCell(cellValue);
        } else {
          cellNumber = new Number(col, riga, Integer.parseInt((StringUtility.checkNull(bilancio.getGruppo()))), cfIntRightBold);
          sheet.addCell(cellNumber);
        }
        
        col++;
        if((StringUtility.checkNull(bilancio.getMastro())).equals("&#160;")) {
          cellValue = new Label(col, riga, "", cfIntNumber);
          sheet.addCell(cellValue);
        } else {
          cellNumber = new Number(col, riga, Integer.parseInt((StringUtility.checkNull(bilancio.getMastro()))), cfIntRight);
          sheet.addCell(cellNumber);
        }
        
        if(visible) 
        {
          col++;
          if((StringUtility.checkNull(bilancio.getConto())).equals("&#160;")) {
            cellValue = new Label(col, riga, "", cfIntNumber);
            sheet.addCell(cellValue);
          } else {
            cellNumber = new Number(col, riga, Integer.parseInt((StringUtility.checkNull(bilancio.getConto()))), cfIntRight);
            sheet.addCell(cellNumber);
          }
        }
        
        col++;
        if((StringUtility.checkNull(bilancio.getDescrizione())).equals("&#160;")) {
          cellValue = new Label(col, riga, "", cfNormal);
        } else {
          
          if(NumberUtils.checkNull(bilancio.getTipoRiga()) == 0 || NumberUtils.checkNull(bilancio.getTipoRiga()) == 1 
            || NumberUtils.checkNull(bilancio.getTipoRiga()) == 2) {
            cellValue = new Label(col, riga, StringUtility.checkNull(bilancio.getDescrizione()), cfBold);
          } else {
            cellValue = new Label(col, riga, StringUtility.checkNull(bilancio.getDescrizione()), cfNormal);
          }
        }
        sheet.addCell(cellValue);
        
        col++;
        
        if(NumberUtils.checkNull(bilancio.getTipoRiga()) == 0 || NumberUtils.checkNull(bilancio.getTipoRiga()) == 1 
          || NumberUtils.checkNull(bilancio.getTipoRiga()) == 2) {
          cellNumber = new Number(col, riga, NumberUtils.checkNull(bilancio.getDare()), cfNumberBold);
        } else {
          cellNumber = new Number(col, riga, NumberUtils.checkNull(bilancio.getDare()), cfNumber);
        }
        sheet.addCell(cellNumber);
        
        col++;
        if(NumberUtils.checkNull(bilancio.getTipoRiga()) == 0 || NumberUtils.checkNull(bilancio.getTipoRiga()) == 1 
          || NumberUtils.checkNull(bilancio.getTipoRiga()) == 2) {
          cellNumber = new Number(col, riga, NumberUtils.checkNull(bilancio.getAvere()), cfNumberBold);
        } else {
          cellNumber = new Number(col, riga, NumberUtils.checkNull(bilancio.getAvere()), cfNumber);
        }
        sheet.addCell(cellNumber);
        
        col++;
        if(NumberUtils.checkNull(bilancio.getTipoRiga()) == 0 || NumberUtils.checkNull(bilancio.getTipoRiga()) == 1 
          || NumberUtils.checkNull(bilancio.getTipoRiga()) == 2) {
          cellNumber = new Number(col, riga, NumberUtils.checkNull(bilancio.getDareExtr()), cfNumberBold);
        } else {
          cellNumber = new Number(col, riga, NumberUtils.checkNull(bilancio.getDareExtr()), cfNumber);
        }
        sheet.addCell(cellNumber);
        
        col++;
        if(NumberUtils.checkNull(bilancio.getTipoRiga()) == 0 || NumberUtils.checkNull(bilancio.getTipoRiga()) == 1 
          || NumberUtils.checkNull(bilancio.getTipoRiga()) == 2) {
          cellNumber = new Number(col, riga, NumberUtils.checkNull(bilancio.getAvereExtr()), cfNumberBold);
        } else {
          cellNumber = new Number(col, riga, NumberUtils.checkNull(bilancio.getAvereExtr()), cfNumber);
        }
        sheet.addCell(cellNumber);
        
        col++;
        if(NumberUtils.checkNull(bilancio.getTipoRiga()) == 0 || NumberUtils.checkNull(bilancio.getTipoRiga()) == 1 
          || NumberUtils.checkNull(bilancio.getTipoRiga()) == 2) {
          cellNumber = new Number(col, riga, NumberUtils.checkNull(bilancio.getDareSaldo()), cfNumberBold);
        } else {
          cellNumber = new Number(col, riga, NumberUtils.checkNull(bilancio.getDareSaldo()), cfNumber);
        }
        sheet.addCell(cellNumber);
        
        col++;
        if(NumberUtils.checkNull(bilancio.getTipoRiga()) == 0 || NumberUtils.checkNull(bilancio.getTipoRiga()) == 1 
          || NumberUtils.checkNull(bilancio.getTipoRiga()) == 2) {
          cellNumber = new Number(col, riga, NumberUtils.checkNull(bilancio.getAvereSaldo()), cfNumberBold);
        } else {
          cellNumber = new Number(col, riga, NumberUtils.checkNull(bilancio.getAvereSaldo()), cfNumber);
        }
        sheet.addCell(cellNumber);
      }
      
      wb.write();

View Full Code Here

      Cell cell = (Cell) parameters.get(i);
      String key = getKey(cell.getContents().trim());
      String type = getType(cell.getContents().trim());
      try {
        if (type.equalsIgnoreCase(G4Constants.ExcelTPL_DataType_Number)) {
          Number number = new Number(cell.getColumn(), cell.getRow(), parameterDto.getAsBigDecimal(key)
              .doubleValue());
          number.setCellFormat(cell.getCellFormat());
          wSheet.addCell(number);
        } else {
          Label label = new Label(cell.getColumn(), cell.getRow(), parameterDto.getAsString(key));
          label.setCellFormat(cell.getCellFormat());
          wSheet.addCell(label);

View Full Code Here

0 1 2

TOP

Related Classes of jxl.write.Number

baseconocimiento.ArchivoExcelBaseConocimiento

com.impetus.kundera.benchmark.WriteToExcelFile

gannuWSD.testing.XLSWriter

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

jturbojet.File.XLSWrite

jxl.demo.ReadWrite

jxl.demo.Write

net.sf.jasperreports.engine.export.JExcelApiExporter

net.sf.jasperreports.engine.export.JExcelApiExporter$CellTextValueHandler

org.g4studio.core.web.report.excel.ExcelFiller

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.