Definition Type: ComplexType
Name: StyleType
Namespace: urn:schemas-microsoft-com:office:spreadsheet
Containing Schema: excelss.xsd
Abstract
Documentation:
Defines a single style in the current workbook. This element is required for custom formatting; otherwise, it is optional.
Collapse XSD Schema Diagram:
Drilldown into Protection in schema excelss_xsd Drilldown into NumberFormat in schema excelss_xsd Drilldown into Interior in schema excelss_xsd Drilldown into Font in schema excelss_xsd Drilldown into Borders in schema excelss_xsd Drilldown into Alignment in schema excelss_xsd Drilldown into Parent in schema excelss_xsd Drilldown into Name in schema excelss_xsd Drilldown into ID in schema excelss_xsdXSD Diagram of StyleType in schema excelss_xsd (Microsoft Office 2003 Reference Schemas)
Collapse XSD Schema Code:
<xsd:complexType name="StyleType">
    <xsd:annotation>
        <xsd:documentation>Defines a single style in the current workbook. This element is required for custom formatting; otherwise, it is optional.</xsd:documentation>
    </xsd:annotation>
    <xsd:sequence>
        <xsd:element name="Alignment" type="AlignmentType" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the font alignment attributes to use for cells to which the defined style is applied.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="Borders" type="BordersType" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Defines the border properties to use for cells to which the defined style is applied.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="Font" type="FontType" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Defines the font characteristics to use for cells to which the defined style is applied.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="Interior" type="InteriorType" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Defines the fill properties to use for cells to which the defined style is applied.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="NumberFormat" type="NumberFormatType" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Defines the number format to use for cells to which the defined style is applied.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="Protection" type="ProtectionType" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Defines the protection properties of cells to which the defined style is applied.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
    </xsd:sequence>
    <xsd:attribute form="qualified" name="ID" type="xsd:ID" use="required">
        <xsd:annotation>
            <xsd:documentation>Defines a name that identifies a particular style. The special value of "Default" indicates that this style represents the default formatting in the workbook.</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute form="qualified" name="Name" type="xsd:string" use="optional">
        <xsd:annotation>
            <xsd:documentation>Specifies the name for a defined style. Duplicate names for different styles are not permitted.</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute form="qualified" name="Parent" type="xsd:IDREF" use="optional">
        <xsd:annotation>
            <xsd:documentation>Specifies a parent style from which the defined style should inherit format settings.</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
</xsd:complexType>
Collapse Child Elements:
Name Type Min Occurs Max Occurs
Alignment ss:Alignment 0 (1)
Borders ss:Borders 0 (1)
Font ss:Font 0 (1)
Interior ss:Interior 0 (1)
NumberFormat ss:NumberFormat 0 (1)
Protection ss:Protection 0 (1)
Collapse Child Attributes:
Name Type Default Value Use
ID ss:ID Required
Name ss:Name Optional
Parent ss:Parent Optional
Collapse Derivation Tree:
Collapse References:
ss:Style