Plutext

Hello,

Is there an easy way to apply a fill color to a cell? Im creating the cells with this code:

Code: Select all

private static Cell createCell(String content) {

        Cell cell = Context.getsmlObjectFactory().createCell();
       

        CTXstringWhitespace ctx = Context.getsmlObjectFactory().createCTXstringWhitespace();
        ctx.setValue(content);

        CTRst ctrst = new CTRst();
        ctrst.setT(ctx);

        cell.setT(STCellType.INLINE_STR);
        cell.setIs(ctrst); // add ctrst as inline string

        return cell;
      
    }


That i copied from some example here. Is there a way i can modify that to apply a fill color to the cell. I dont want an entire row to be colored, only one cell.

Thank you very much!

In your worksheet, your cell needs a style attribute (@s):



Per http://webapp.docx4java.org/OnlineDemo/ ... L/c_1.html

s (Style Index): The index of this cell's style. Style records are stored in the Styles Part.

In the Styles part, in this example, you then have:



The index into cellXfs is zero-based, so here we are using fillId 2, which is the last of the fills.

To see whether your SpreadsheetMLPackage contains a org.docx4j.openpackaging.parts.SpreadsheetML.Styles part, invoke workbookPart.getStylesPart()

If your SpreadsheetMLPackage doesn't contain a Styles part, you'll need to instantiate one, then add it using workbookPart.addTargetPart(stylesPart). You'll need to create a CTStylesheet then call stylesPart.setContent(yourCTStylesheetObj)

Great, I had trouble implementing background colors as well, but I did that and it worked fine. I was really at a loss there...