Examples of jxl.write.Blank

jxl.write.Blank
A blank cell. Despite not having any contents, it may contain formatting information. Such cells are typically used when creating templates

      }
    }


    protected Blank blank(WritableCellFormat cellStyle)
    {
      return new Blank(x, y, cellStyle);
    }

View Full Code Here

        gridCell
        );


    try
    {
      sheet.addCell(new Blank(colIndex, rowIndex, cellStyle));
    }
    catch (RowsExceededException e)
    {
      throw new JRException("Error generating XLS report : " + jasperPrint.getName(), e);//FIXMENOW raise same exception everywhere
    }

View Full Code Here

        backcolor, 
        cellFont2, 
        boxStyle,
        isCellLocked(line)
        );
    Blank cell2 = new Blank(col, row, cellStyle2);


    try
    {
      sheet.addCell(cell2);
    }

View Full Code Here

        cellFont2, 
        gridCell,
        isCellLocked(element)
        );
    
    Blank cell2 = new Blank(col, row, cellStyle2);


    try
    {
      sheet.addCell(cell2);
    }

View Full Code Here

          isCellLocked(element)
          );


      try
      {
        sheet.addCell(new Blank(col, row, cellStyle2));
        double leftPos = getColumnRelativePosition(layout, col, leftOffset);
        double topPos = getRowRelativePosition(layout, yCutsRow, topOffset);
        WritableImage image =
          new WritableImage(
            col - emptyCols + leftPos,

View Full Code Here

        cellFont, 
        gridCell,
        isCellLocked(frame)
        );


    Blank cell = new Blank(col, row, cellStyle);
    try
    {
      sheet.addCell(cell);
    }
    catch (JXLException e)

View Full Code Here

    s1.addCell(l);


    l = new Label(0, 63, "Data validation:  list");
    s1.addCell(l);
    
    Blank b = new Blank(1,63);
    cellFeatures = new WritableCellFeatures();
    ArrayList al = new ArrayList();
    al.add("bagpuss");
    al.add("clangers");
    al.add("ivor the engine");
    al.add("noggin the nog");
    cellFeatures.setDataValidationList(al);
    b.setCellFeatures(cellFeatures);
    s1.addCell(b);


    l = new Label(0, 64, "Data validation:  number > 4.5");
    s1.addCell(l);
    
    b = new Blank(1,64);
    cellFeatures = new WritableCellFeatures();
    cellFeatures.setNumberValidation(4.5, WritableCellFeatures.GREATER_THAN);
    b.setCellFeatures(cellFeatures);
    s1.addCell(b);


    l = new Label(0, 65, "Data validation:  named range");
    s1.addCell(l);
    
    l = new Label(4, 65, "tiger");
    s1.addCell(l);
    l = new Label(5, 65, "sword");
    s1.addCell(l);
    l = new Label(6, 65, "honour");
    s1.addCell(l);
    l = new Label(7, 65, "company");
    s1.addCell(l);
    l = new Label(8, 65, "victory");
    s1.addCell(l);
    l = new Label(9, 65, "fortress");
    s1.addCell(l);


    b = new Blank(1,65);
    cellFeatures = new WritableCellFeatures();
    cellFeatures.setDataValidationRange("validation_range");
    b.setCellFeatures(cellFeatures);
    s1.addCell(b);


    // Set the row grouping
    s1.setRowGroup(39, 45, false);
    // s1.setRowGroup(72, 74, true);

View Full Code Here


    // Add a list data validations
    label = new Label(0, 151, "Added drop down validation");
    sheet.addCell(label);


    Blank b = new Blank(1, 151);
    wcf = new WritableCellFeatures();
    ArrayList al = new ArrayList();
    al.add("The Fellowship of the Ring");
    al.add("The Two Towers");
    al.add("The Return of the King");
    wcf.setDataValidationList(al);
    b.setCellFeatures(wcf);
    sheet.addCell(b);


    // Add a number data validation
    label = new Label(0, 152, "Added number validation 2.718 < x < 3.142");
    sheet.addCell(label);
    b = new Blank(1,152);
    wcf = new WritableCellFeatures();
    wcf.setNumberValidation(2.718, 3.142, wcf.BETWEEN);
    b.setCellFeatures(wcf);
    sheet.addCell(b);


    // Modify the text in the first cell with a comment
    cell = sheet.getWritableCell(0, 156);
    l = (Label) cell;

View Full Code Here

      }
      if (val instanceof Number) {
        return new jxl.write.Number( _col, _row, ((Number) val).doubleValue() );
      }
    }
    return new Blank( _col, _row );
  }

View Full Code Here

TOP

Related Classes of jxl.write.Blank

jxl.demo.ReadWrite

jxl.demo.Write

net.sf.jasperreports.engine.export.JExcelApiExporter

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

org.formulacompiler.spreadsheet.internal.excel.xls.saver.ExcelXLSSaver

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.