Documentation for Office Open XML (OOXML / OpenXML / Ecma 376)
Definition Type: ComplexType
Name: CT_Macrosheet
Namespace: http://schemas.openxmlformats.org/spreadsheetml/2006/main
Containing Schema: sml-sheet.xsd
Abstract
Collapse XSD Schema Diagram:
Drilldown into extLst in schema sml-sheet_xsd Drilldown into oleObjects in schema sml-sheet_xsd Drilldown into picture in schema sml-sheet_xsd Drilldown into legacyDrawingHF in schema sml-sheet_xsd Drilldown into legacyDrawing in schema sml-sheet_xsd Drilldown into drawing in schema sml-sheet_xsd Drilldown into customProperties in schema sml-sheet_xsd Drilldown into colBreaks in schema sml-sheet_xsd Drilldown into rowBreaks in schema sml-sheet_xsd Drilldown into headerFooter in schema sml-sheet_xsd Drilldown into pageSetup in schema sml-sheet_xsd Drilldown into pageMargins in schema sml-sheet_xsd Drilldown into printOptions in schema sml-sheet_xsd Drilldown into conditionalFormatting in schema sml-sheet_xsd Drilldown into phoneticPr in schema sml-sheet_xsd Drilldown into customSheetViews in schema sml-sheet_xsd Drilldown into dataConsolidate in schema sml-sheet_xsd Drilldown into sortState in schema sml-sheet_xsd Drilldown into autoFilter in schema sml-sheet_xsd Drilldown into sheetProtection in schema sml-sheet_xsd Drilldown into sheetData in schema sml-sheet_xsd Drilldown into cols in schema sml-sheet_xsd Drilldown into sheetFormatPr in schema sml-sheet_xsd Drilldown into sheetViews in schema sml-sheet_xsd Drilldown into dimension in schema sml-sheet_xsd Drilldown into sheetPr in schema sml-sheet_xsdXSD Diagram of CT_Macrosheet in schema sml-sheet_xsd (Office Open XML (OOXML / OpenXML / Ecma 376))
Collapse XSD Schema Code: 
<xsd:complexType name="CT_Macrosheet">
    <xsd:sequence>
        <xsd:element name="sheetPr" type="CT_SheetPr" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Sheet Properties</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="dimension" type="CT_SheetDimension" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Macro Sheet Dimensions</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="sheetViews" type="CT_SheetViews" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Macro Sheet Views</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="sheetFormatPr" type="CT_SheetFormatPr" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Sheet Format Properties</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="cols" type="CT_Cols" minOccurs="0" maxOccurs="unbounded">
            <xsd:annotation>
                <xsd:documentation>Column Information</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="sheetData" type="CT_SheetData" minOccurs="1" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Sheet Data</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="sheetProtection" type="CT_SheetProtection" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Sheet Protection Options</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="autoFilter" type="CT_AutoFilter" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>AutoFilter</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="sortState" type="CT_SortState" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Sort State</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="dataConsolidate" type="CT_DataConsolidate" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Data Consolidation</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="customSheetViews" type="CT_CustomSheetViews" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Custom Sheet Views</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="phoneticPr" type="CT_PhoneticPr" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Phonetic Properties</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="conditionalFormatting" type="CT_ConditionalFormatting" minOccurs="0" maxOccurs="unbounded">
            <xsd:annotation>
                <xsd:documentation>Conditional Formatting</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="printOptions" type="CT_PrintOptions" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Print Options</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="pageMargins" type="CT_PageMargins" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Page Margins</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="pageSetup" type="CT_PageSetup" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Page Setup Settings</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="headerFooter" type="CT_HeaderFooter" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Header Footer Settings</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="rowBreaks" type="CT_PageBreak" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Horizontal Page Breaks (Row)</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="colBreaks" type="CT_PageBreak" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Vertical Page Breaks</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="customProperties" type="CT_CustomProperties" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Custom Properties</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="drawing" type="CT_Drawing" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Drawing</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="legacyDrawing" type="CT_LegacyDrawing" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Legacy Drawing Reference</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="legacyDrawingHF" type="CT_LegacyDrawing" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Legacy Drawing Header Footer</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="picture" type="CT_SheetBackgroundPicture" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Background Image</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="oleObjects" type="CT_OleObjects" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>OLE Objects</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="extLst" minOccurs="0" type="CT_ExtensionList">
            <xsd:annotation>
                <xsd:documentation>Future Feature Data Storage Area</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
    </xsd:sequence>
</xsd:complexType>
Collapse Child Elements:
Name Type Min Occurs Max Occurs
sheetPr nsM:sheetPr 0 1
dimension nsM:dimension 0 1
sheetViews nsM:sheetViews 0 1
sheetFormatPr nsM:sheetFormatPr 0 1
cols nsM:cols 0 unbounded
sheetData nsM:sheetData 1 1
sheetProtection nsM:sheetProtection 0 1
autoFilter nsM:autoFilter 0 1
sortState nsM:sortState 0 1
dataConsolidate nsM:dataConsolidate 0 1
customSheetViews nsM:customSheetViews 0 1
phoneticPr nsM:phoneticPr 0 1
conditionalFormatting nsM:conditionalFormatting 0 unbounded
printOptions nsM:printOptions 0 1
pageMargins nsM:pageMargins 0 1
pageSetup nsM:pageSetup 0 1
headerFooter nsM:headerFooter 0 1
rowBreaks nsM:rowBreaks 0 1
colBreaks nsM:colBreaks 0 1
customProperties nsM:customProperties 0 1
drawing nsM:drawing 0 1
legacyDrawing nsM:legacyDrawing 0 1
legacyDrawingHF nsM:legacyDrawingHF 0 1
picture nsM:picture 0 1
oleObjects nsM:oleObjects 0 1
extLst nsM:extLst 0 (1)
Documentation for Office Open XML (OOXML / OpenXML / Ecma 376)

Generated using Liquid Studio - Developer Bundle 21.0.0.0