Examples of jxl.write.WritableCellFormat

jxl.write.WritableCellFormat
A user specified cell format, which may be reused across many cells. The constructors takes parameters, such as font details and the numerical date formats, which specify to Excel how cells with this format should be displayed. Once a CellFormat has been added to a Cell which has been added to a sheet, then the CellFormat becomes immutable (to prevent unforeseen effects on other cells which share the same format). Attempts to call the various set... functions on a WritableCellFormat after this time will result in a runtime exception.

      this.cellComplexFormat = cellComplexFormat;
    }


    public void handle(StringTextValue textValue) throws JRException
    {
      WritableCellFormat cellStyle = getLoadedCellStyle(baseStyle);
      result = new Label(x, y, textValue.getText(), cellStyle);
    }

View Full Code Here

      if (textValue.getPattern() != null)
      {
        baseStyle.setDisplayFormat(getNumberFormat(textValue.getPattern(), cellComplexFormat));
      }


      WritableCellFormat cellStyle = getLoadedCellStyle(baseStyle);
      if (textValue.getValue() == null)
      {
        result = blank(cellStyle);
      }
      else

View Full Code Here

    }


    public void handle(DateTextValue textValue) throws JRException
    {
      baseStyle.setDisplayFormat(getDateFormat(textValue.getPattern()));
      WritableCellFormat cellStyle = getLoadedCellStyle(baseStyle);
      if (textValue.getValue() == null)
      {
        result = blank(cellStyle);
      }
      else

View Full Code Here

      }
    }


    public void handle(BooleanTextValue textValue) throws JRException
    {
      WritableCellFormat cellStyle = getLoadedCellStyle(baseStyle);
      if (textValue.getValue() == null)
      {
        result = blank(cellStyle);
      }
      else

View Full Code Here

      mode = Pattern.SOLID;
      backcolor = getWorkbookColour(gridCell.getCellBackcolor(), true);
    }


    WritableFont cellFont = getLoadedFont(getDefaultFont(), forecolor.getValue(), getLocale());
    WritableCellFormat cellStyle = 
      getLoadedCellStyle(
        mode, 
        backcolor,
        cellFont, 
        gridCell

View Full Code Here

        side = BoxStyle.RIGHT;
      }
    }
    BoxStyle boxStyle = new BoxStyle(side, line.getLinePen());
    
    WritableCellFormat cellStyle2 = 
      getLoadedCellStyle(
        mode, 
        backcolor, 
        cellFont2, 
        boxStyle,

View Full Code Here

      backcolor = getWorkbookColour(gridCell.getCellBackcolor(), true);
    }


    Colour forecolor = getWorkbookColour(element.getLinePen().getLineColor());
    WritableFont cellFont2 = getLoadedFont(getDefaultFont(), forecolor.getValue(), getLocale());
    WritableCellFormat cellStyle2 = 
      getLoadedCellStyle(
        mode, 
        backcolor, 
        cellFont2, 
        gridCell,

View Full Code Here

  {
    CellValue cellValue;
    try
    {
      double d = Double.parseDouble(textStr);
      WritableCellFormat cellStyle = getLoadedCellStyle(baseStyle);
      cellValue = new Number(x, y, d, cellStyle);
    }
    catch (NumberFormatException nfe)
    {
      cellValue = getLabelCell(x, y, textStr, baseStyle);

View Full Code Here

    return cellValue;
  }


  protected CellValue getLabelCell(int x, int y, String textStr, StyleInfo baseStyle) throws JRException
  {
    WritableCellFormat cellStyle = getLoadedCellStyle(baseStyle);
    return new Label(x, y, textStr, cellStyle);
  }

View Full Code Here


      Colour forecolor = getWorkbookColour(element.getLineBox().getPen().getLineColor());


      WritableFont cellFont2 = this.getLoadedFont(getDefaultFont(), forecolor.getValue(), getLocale());


      WritableCellFormat cellStyle2 = 
        getLoadedCellStyle(
          mode, 
          background, 
          cellFont2, 
          gridCell,

View Full Code Here

0 1 2 3

TOP

Related Classes of jxl.write.WritableCellFormat

com.iisigroup.cap.rule.handler.RuleTbMntHandler

com.impetus.kundera.benchmark.WriteToExcelFile

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

jxl.demo.ReadWrite

jxl.demo.Write

net.sf.jasperreports.engine.export.JExcelApiExporter

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

org.dspace.app.cris.batch.ScriptStatSubscribe

org.jboss.seam.excel.jxl.JXLHelper

org.zkoss.zss.model.impl.ExcelExporter

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.