Examples of com.extentech.ExtenXLS.FormatHandle.addCell()

      fmt1.setBorderLineStyle(FormatHandle.BORDER_MEDIUM_DASH_DOT_DOT);
      sheet.add("NEW CELL!","C5");
      CellHandle bordercell = sheet.getCell("C3");
    
      int i = bordercell.getFormatId();
      fmt1.addCell(bordercell);
      i = bordercell.getFormatId();
      System.out.println(i);
    }catch(Exception e){System.out.println(e);}
    testWrite(tbo, "testFormats_out.xls");
  }

      fmx.setBorderLineStyle(3);
      fmx.setBorderTopColor(FormatHandle.COLOR_LIGHT_BLUE);
      fmx.setBorderBottomColor(FormatHandle.COLOR_GREEN);
      fmx.setBorderLeftColor(FormatHandle.COLOR_YELLOW);
      fmx.setBorderRightColor(FormatHandle.COLOR_BLACK);
      fmx.addCell(sheet.add("Great new cell!!", "A1"));
      fmx.setFont("Courier",Font.BOLD,12);
      fmx.setForegroundColor(FormatHandle.COLOR_BRIGHT_GREEN);
      fmx.setBackgroundColor(FormatHandle.COLOR_BLUE);
      fmx.setFontColor(FormatHandle.COLOR_BLUE);
      fmx.setBackgroundPattern(FormatHandle.PATTERN_HOR_STRIPES3);

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.