Package org.zkoss.poi.ss.usermodel

Examples of org.zkoss.poi.ss.usermodel.Cell

546
547
548
549
550
551
552
553
554
555
556
557
  public static void setBackgroundColor(Worksheet sheet, Rect rect, String color) {
    final Book book  = (Book) sheet.getWorkbook();
    final Color bsColor = BookHelper.HTMLToColor(book, color);
    for (int row = rect.getTop(); row <= rect.getBottom(); row++)
      for (int col = rect.getLeft(); col <= rect.getRight(); col++) {
        Cell cell = Utils.getOrCreateCell(sheet, row, col);
        CellStyle cs = cell.getCellStyle();
        final Color srcColor = cs.getFillForegroundColorColor();
        if (Objects.equals(srcColor, bsColor)) {
          continue;
        }
        CellStyle newCellStyle = book.createCellStyle();
View Full Code Here
703
704
705
706
707
708
709
710
711
712
713
   * @param colIndex the column index of the cell
   * @return or create if not exist the {@link Cell} per the given sheet, row index, and column index.
   */
  public static Cell getOrCreateCell(Worksheet sheet,int rowIndex, int colIndex){
    Row row = getOrCreateRow(sheet, rowIndex);
    Cell cell = row.getCell(colIndex);
    if (cell == null) {
      cell = row.createCell(colIndex);
    }
    return cell;
  }
View Full Code Here
768
769
770
771
772
773
774
775
    final Range rng = getRange(sheet, 0, startCol, book.getSpreadsheetVersion().getLastRowIndex(), endCol);
    rng.delete(Range.SHIFT_DEFAULT);
  }

  public static void setCellValue(Worksheet sheet, int rowIndex, int colIndex, String value) {
    final Cell cell = getOrCreateCell(sheet, rowIndex, colIndex);
    cell.setCellValue(value);
  }
View Full Code Here
772
773
774
775
776
777
778
779
  public static void setCellValue(Worksheet sheet, int rowIndex, int colIndex, String value) {
    final Cell cell = getOrCreateCell(sheet, rowIndex, colIndex);
    cell.setCellValue(value);
  }
  public static void setCellValue(Worksheet sheet, int rowIndex, int colIndex, double value) {
    final Cell cell = getOrCreateCell(sheet, rowIndex, colIndex);
    cell.setCellValue(value);
  }
View Full Code Here
776
777
778
779
780
781
782
783
  public static void setCellValue(Worksheet sheet, int rowIndex, int colIndex, double value) {
    final Cell cell = getOrCreateCell(sheet, rowIndex, colIndex);
    cell.setCellValue(value);
  }
  public static void setCellValue(Worksheet sheet, int rowIndex, int colIndex, boolean value) {
    final Cell cell = getOrCreateCell(sheet, rowIndex, colIndex);
    cell.setCellValue(value);
  }
View Full Code Here
780
781
782
783
784
785
786
787
  public static void setCellValue(Worksheet sheet, int rowIndex, int colIndex, boolean value) {
    final Cell cell = getOrCreateCell(sheet, rowIndex, colIndex);
    cell.setCellValue(value);
  }
  public static void setCellValue(Worksheet sheet, int rowIndex, int colIndex, Date value) {
    final Cell cell = getOrCreateCell(sheet, rowIndex, colIndex);
    cell.setCellValue(value);
  }
View Full Code Here
784
785
786
787
788
789
790
791
  public static void setCellValue(Worksheet sheet, int rowIndex, int colIndex, Date value) {
    final Cell cell = getOrCreateCell(sheet, rowIndex, colIndex);
    cell.setCellValue(value);
  }
  public static void setCellValue(Worksheet sheet, int rowIndex, int colIndex, int value) {
    final Cell cell = getOrCreateCell(sheet, rowIndex, colIndex);
    cell.setCellValue(value);
  }
View Full Code Here
944
945
946
947
948
949
950
951
   * @param row the row index
   * @param col the column index
   * @param value the user input text
   */
  public static void setEditText(Worksheet sheet, int row, int col, String value) {
    final Cell cell = getOrCreateCell(sheet, row, col);
    setEditText(cell, value);
  }
View Full Code Here
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
    destination.cloneStyleFrom(cell.getCellStyle());
    return destination;
  }
 
  public static void setFontColor(Worksheet sheet, int row, int col, String color){
    final Cell cell = Utils.getOrCreateCell(sheet,row,col);
    final Book book = (Book) sheet.getWorkbook();
    final short fontIdx = cell.getCellStyle().getFontIndex();
    final Font font = book.getFontAt(fontIdx);
    final Color orgColor = BookHelper.getFontColor(book, font);
    final Color newColor = BookHelper.HTMLToColor(book, color);
    if (orgColor == newColor || orgColor != null && orgColor.equals(newColor)) {
      return;
    }
    final short boldWeight = font.getBoldweight();
    final short fontHeight = font.getFontHeight();
    final String name = font.getFontName();
    final boolean italic = font.getItalic();
    final boolean strikeout = font.getStrikeout();
    final short typeOffset = font.getTypeOffset();
    final byte underline = font.getUnderline();
    final Font newFont = BookHelper.getOrCreateFont(book, boldWeight, newColor, fontHeight, name, italic, strikeout, typeOffset, underline);
    final CellStyle style = cloneCellStyle(cell);
    style.setFont(newFont);
    cell.setCellStyle(style);
  }
View Full Code Here
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
    style.setFont(newFont);
    cell.setCellStyle(style);
  }
 
  public static void setFillColor(Worksheet sheet, int row, int col, String color){
    final Cell cell = Utils.getOrCreateCell(sheet,row,col);
    final Book book = (Book) sheet.getWorkbook();
    final Color orgColor = cell.getCellStyle().getFillForegroundColorColor();
    final Color newColor = BookHelper.HTMLToColor(book, color);
    if (orgColor == newColor || orgColor != null  && orgColor.equals(newColor)) { //no change, skip
      return;
    }
    final CellStyle style = cloneCellStyle(cell);
    BookHelper.setFillForegroundColor(style, newColor);
    cell.setCellStyle(style);
  }
View Full Code Here
TOP

Related Classes of org.zkoss.poi.ss.usermodel.Cell

  • org.zkoss.zss.app.cell.CellHelper
  • org.zkoss.zss.app.ctrl.AutoFilterCtrl
  • org.zkoss.zss.app.CustomSortWindowCtrl$SortAlgorithm
  • org.zkoss.zss.app.FormatProtectionHelper
  • org.zkoss.zss.app.MainWindowCtrl
  • org.zkoss.zss.app.MultiSpreadsheetWindow
  • org.zkoss.zss.app.sort.CustomSortWindowCtrl$SortAlgorithm
  • org.zkoss.zss.app.zul.FormulaEditor
  • org.zkoss.zss.demo.MainWindow
  • org.zkoss.zss.demo.ZssGmapWindow
    • Copyright © 2018 www.massapicom. All rights reserved.
    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.