How to read and modify existing Stylesheed

[netdieter]

Hello,
i use a excel file as a template for a dataexport. Is there a way to read tge ecisting Stylesheed an modify it bevor i write the file back?

Thanx

[jason]

You'd expect the WorkbookPart to give you a reference to it, but it doesn't. I'll fix that.

So you can either:

1. get it by its expected name

Syntax: [ Download ] [ Hide ]

Syntax: [ Download ] [ Show ]

Using java Syntax Highlighting

org.docx4j.openpackaging.parts.SpreadsheetML.Styles stylesPart = (Styles)pkg.getParts().get(new PartName("xl/styles.xml"))
 

Parsed in 0.014 seconds, using GeSHi 1.0.8.4

or 2. by looking for a rel of type Namespaces.SPREADSHEETML_STYLES (in all parts, or in the rels of Workbook part)

[netdieter]

Thanx for this hint.
I post my progress here. May be usefull for others:

Code: Select all

Styles styles = (Styles)pkg.getParts().get(new PartName("/xl/styles.xml"));
CTStylesheet st =  styles.getContents();

CTXf xf = Context.getsmlObjectFactory().createCTXf();
xf.setNumFmtId( new Long(0) );
xf.setFontId( new Long(1) );
xf.setFillId( new Long(0) );
xf.setBorderId( new Long(1) );
xf.setXfId( new Long(0) );
st.getCellXfs().getXf().add(xf);
st.getCellXfs().setCount(st.getCellXfs().getCount() + 1L);


[jason]

Following https://github.com/plutext/docx4j/commi ... 708bec249f
you'll be able to do:

Syntax: [ Download ] [ Hide ]

Syntax: [ Download ] [ Show ]

Using java Syntax Highlighting

Styles stylesPart = pkg.getWorkbookPart().getStylesPart();
 

Parsed in 0.014 seconds, using GeSHi 1.0.8.4

The result will be null if there is no styles part in the pkg, so check for that...