Styles Part

Content Type:

application/vnd.openxmlformats-officedocument.spreadsheetml.styles+xml

Root Namespace:

http://schemas.openxmlformats.org/spreadsheetml/2006/mains

Source Relationship:

http://schemas.openxmlformats.org/officeDocument/2006/relationships/styles

An instance of this part type contains all the characteristics for all the cells in the workbook. Such information includes numeric and text formatting, alignment, font, color, and border.

A package shall contain no more than one Styles part, and that part shall be the target of an implicit relationship from the Workbook (§12.3.23) part.

example:

<Relationships xmlns="…">
  <Relationship Id="rId5" 
    Type="http://…/styles" Target="styles.xml"/>
</Relationships>

The root element for a part of this content type shall be< styleSheet>.

example:

<styleSheet xmlns="…">
  <numFmts count="5">
    <numFmt numFmtId="164" formatCode="&quot;$&quot;#,##0.00"/>
    <numFmt numFmtId="165" 
      formatCode="&quot;Yes&quot;;&quot;Yes&quot;;&quot;No&quot;"/>
    <numFmt numFmtId="166" 
      formatCode="&quot;True&quot;;&quot;True&quot;;&quot;False&quot;"/>
    <numFmt numFmtId="167" 
      formatCode="&quot;On&quot;;&quot;On&quot;;&quot;Off&quot;"/>
    <numFmt numFmtId="168" 
      formatCode="[$€-2]\ #,##0.00_);[Red]\([$€-2]\ #,##0.00\)"/>
  </numFmts>
  <fonts count="5">
    …
  </fonts>
  <fills count="4">
    …
  </fills>
  <borders count="1">
    …
  </borders>
  …
  <colors>
    …
  </colors>
</styleSheet>

A Styles part shall be located within the package containing the source relationship (expressed syntactically, the @TargetMode attribute of the <Relationship> element shall be Internal).

A Styles part shall not have implicit or explicit relationships to any other part defined by this Standard.