Examples of org.apache.poi.xssf.usermodel.extensions.XSSFCellFill

Package org.apache.poi.xssf.usermodel.extensions

Examples of org.apache.poi.xssf.usermodel.extensions.XSSFCellFill

org.apache.poi.xssf.usermodel.extensions.XSSFCellFill
This element specifies fill formatting. A cell fill consists of a background color, foreground color, and pattern to be applied across the cell.


    XSSFCellBorder borderB = new XSSFCellBorder();
    assertEquals(1, stylesTable.putBorder(borderB));


    ctFill = CTFill.Factory.newInstance();
    XSSFCellFill fill = new XSSFCellFill(ctFill);
    long fillId = stylesTable.putFill(fill);
    assertEquals(2, fillId);


    ctFont = CTFont.Factory.newInstance();
    XSSFFont font = new XSSFFont(ctFont);

View Full Code Here

                    idx++;
                }
            }
      if(doc.getStyleSheet().getFills() != null)
      for (CTFill fill : doc.getStyleSheet().getFills().getFillArray()) {
        fills.add(new XSSFCellFill(fill));
      }
      if(doc.getStyleSheet().getBorders() != null)
      for (CTBorder border : doc.getStyleSheet().getBorders().getBorderArray()) {
        borders.add(new XSSFCellBorder(border));
      }

View Full Code Here

    //CTFont ctFont = createDefaultFont();
    XSSFFont xssfFont = createDefaultFont();
    fonts.add(xssfFont);


    CTFill[] ctFill = createDefaultFills();
    fills.add(new XSSFCellFill(ctFill[0]));
    fills.add(new XSSFCellFill(ctFill[1]));


    CTBorder ctBorder = createDefaultBorder();
    borders.add(new XSSFCellBorder(ctBorder));


    CTXf styleXf = createDefaultXf();

View Full Code Here

     */
    public XSSFColor getFillBackgroundXSSFColor() {
        if(!cellXf.getApplyFill()) return null;


        int fillIndex = (int)cellXf.getFillId();
        XSSFCellFill fg = stylesSource.getFillAt(fillIndex);


        return fg.getFillBackgroundColor();
    }

View Full Code Here

     */
    public XSSFColor getFillForegroundXSSFColor() {
        if(!cellXf.getApplyFill()) return null;


        int fillIndex = (int)cellXf.getFillId();
        XSSFCellFill fg = stylesSource.getFillAt(fillIndex);


        return fg.getFillForegroundColor();
    }

View Full Code Here

     */
    public short getFillPattern() {
        if(!cellXf.getApplyFill()) return 0;


        int fillIndex = (int)cellXf.getFillId();
        XSSFCellFill fill = stylesSource.getFillAt(fillIndex);


        STPatternType.Enum ptrn = fill.getPatternType();
        if(ptrn == null) return CellStyle.NO_FILL;
        return (short)(ptrn.intValue() - 1);
    }

View Full Code Here

        } else {
            if(ptrn == null) ptrn = ct.addNewPatternFill();
            ptrn.setBgColor(color.getCTColor());
        }


        int idx = stylesSource.putFill(new XSSFCellFill(ct));


        cellXf.setFillId(idx);
        cellXf.setApplyFill(true);
    }

View Full Code Here

        } else {
            if(ptrn == null) ptrn = ct.addNewPatternFill();
            ptrn.setFgColor(color.getCTColor());
        }


        int idx = stylesSource.putFill(new XSSFCellFill(ct));


        cellXf.setFillId(idx);
        cellXf.setApplyFill(true);
    }

View Full Code Here

     */
    private CTFill getCTFill(){
        CTFill ct;
        if(cellXf.getApplyFill()) {
            int fillIndex = (int)cellXf.getFillId();
            XSSFCellFill cf = stylesSource.getFillAt(fillIndex);


            ct = (CTFill)cf.getCTFill().copy();
        } else {
            ct = CTFill.Factory.newInstance();
        }
        return ct;
    }

View Full Code Here

        CTFill ct = getCTFill();
        CTPatternFill ptrn = ct.isSetPatternFill() ? ct.getPatternFill() : ct.addNewPatternFill();
        if(fp == NO_FILL && ptrn.isSetPatternType()) ptrn.unsetPatternType();
        else ptrn.setPatternType(STPatternType.Enum.forInt(fp + 1));


        int idx = stylesSource.putFill(new XSSFCellFill(ct));


        cellXf.setFillId(idx);
        cellXf.setApplyFill(true);
    }

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.apache.poi.xssf.usermodel.extensions.XSSFCellFill

org.apache.poi.xssf.model.StylesTable

org.apache.poi.xssf.usermodel.TestXSSFBugs

org.apache.poi.xssf.usermodel.TestXSSFCellStyle

org.apache.poi.xssf.usermodel.XSSFCellStyle

org.apache.poi.xssf.usermodel.XSSFColor

org.openxmlformats.schemas.spreadsheetml.x2006.main.CTColor

org.openxmlformats.schemas.spreadsheetml.x2006.main.CTPatternFill

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.