Documentation for Microsoft Office 2003 Reference Schemas
Definition Type: Element
Name: ExcelWorkbook
Namespace: urn:schemas-microsoft-com:office:excel
Containing Schema: excel.xsd
Abstract
Documentation:
Contains the properties of a workbook.
Collapse XSD Schema Diagram:
Drilldown into Uncalced in schema excel_xsd Drilldown into AcceptLabelsInFormulas in schema excel_xsd Drilldown into NoAutoRecover in schema excel_xsd Drilldown into DoNotSaveLinkValues in schema excel_xsd Drilldown into PrecisionAsDisplayed in schema excel_xsd Drilldown into MaxChange in schema excel_xsd Drilldown into MaxIterations in schema excel_xsd Drilldown into Iteration in schema excel_xsd Drilldown into RefModeR1C1 in schema excel_xsd Drilldown into Date1904 in schema excel_xsd Drilldown into DoNotCalculateBeforeSave in schema excel_xsd Drilldown into Calculation in schema excel_xsd Drilldown into CreateBackup in schema excel_xsd Drilldown into DisplayDrawingObjects in schema excel_xsd Drilldown into WindowIconic in schema excel_xsd Drilldown into TabRatio in schema excel_xsd Drilldown into FutureVer in schema excel_xsd Drilldown into EmbedSaveSmartTags in schema excel_xsd Drilldown into DisplayInkNotes in schema excel_xsd Drilldown into ProtectWindows in schema excel_xsd Drilldown into ProtectStructure in schema excel_xsd Drilldown into HidePivotTableFieldList in schema excel_xsd Drilldown into FirstVisibleSheet in schema excel_xsd Drilldown into ActiveChart in schema excel_xsd Drilldown into ActiveSheet in schema excel_xsd Drilldown into WindowTopY in schema excel_xsd Drilldown into WindowTopX in schema excel_xsd Drilldown into WindowWidth in schema excel_xsd Drilldown into WindowHeight in schema excel_xsd Drilldown into HideWorkbookTabs in schema excel_xsd Drilldown into HideVerticalScrollBar in schema excel_xsd Drilldown into HideHorizontalScrollBar in schema excel_xsd Drilldown into WindowHidden in schema excel_xsd Drilldown into SelectedSheets in schema excel_xsd Drilldown into SupBook in schema excel_xsd Drilldown into PublishObjects in schema excel_xsdXSD Diagram of ExcelWorkbook in schema excel_xsd (Microsoft Office 2003 Reference Schemas)
Collapse XSD Schema Code: 
<xsd:element name="ExcelWorkbook">
    <xsd:annotation>
        <xsd:documentation>Contains the properties of a workbook.</xsd:documentation>
    </xsd:annotation>
    <xsd:complexType>
        <xsd:sequence>
            <xsd:element name="PublishObjects" type="PublishObjectsType" minOccurs="0">
                <xsd:annotation>
                    <xsd:documentation>Contains information about all published items in a workbook.</xsd:documentation>
                </xsd:annotation>
            </xsd:element>
            <xsd:element name="SupBook" type="SupBookType" minOccurs="0" maxOccurs="unbounded">
                <xsd:annotation>
                    <xsd:documentation>Contains information about references and links to other workbooks and data sources.</xsd:documentation>
                </xsd:annotation>
            </xsd:element>
            <xsd:element name="SelectedSheets" type="xsd:int" default="1" minOccurs="0">
                <xsd:annotation>
                    <xsd:documentation>Specifies the number of sheets selected in a workbook.</xsd:documentation>
                </xsd:annotation>
            </xsd:element>
            <xsd:element name="WindowHidden" minOccurs="0">
                <xsd:annotation>
                    <xsd:documentation>Specifies whether a workbook window is hidden.</xsd:documentation>
                </xsd:annotation>
            </xsd:element>
            <xsd:element name="HideHorizontalScrollBar" minOccurs="0">
                <xsd:annotation>
                    <xsd:documentation>Specifies whether the horizontal scroll bar in a workbook window is hidden.</xsd:documentation>
                </xsd:annotation>
            </xsd:element>
            <xsd:element name="HideVerticalScrollBar" minOccurs="0">
                <xsd:annotation>
                    <xsd:documentation>Specifies whether the vertical scroll bar in a workbook window is hidden.</xsd:documentation>
                </xsd:annotation>
            </xsd:element>
            <xsd:element name="HideWorkbookTabs" minOccurs="0">
                <xsd:annotation>
                    <xsd:documentation>Specifies whether the worksheet tabs in a workbook window are hidden.</xsd:documentation>
                </xsd:annotation>
            </xsd:element>
            <xsd:element name="WindowHeight" type="xsd:long" minOccurs="0">
                <xsd:annotation>
                    <xsd:documentation>Contains a value specifying the height in points of a workbook window.</xsd:documentation>
                </xsd:annotation>
            </xsd:element>
            <xsd:element name="WindowWidth" type="xsd:long" minOccurs="0">
                <xsd:annotation>
                    <xsd:documentation>Contains a value in points that specifies the width of a workbook window.</xsd:documentation>
                </xsd:annotation>
            </xsd:element>
            <xsd:element name="WindowTopX" type="xsd:long" minOccurs="0">
                <xsd:annotation>
                    <xsd:documentation>Contains a value in points that specifies the horizontal position of a workbook window relative to the left border of the application window.</xsd:documentation>
                </xsd:annotation>
            </xsd:element>
            <xsd:element name="WindowTopY" type="xsd:long" minOccurs="0">
                <xsd:annotation>
                    <xsd:documentation>Contains a value in points that specifies the vertical position of a workbook window relative to the top border of the application window.</xsd:documentation>
                </xsd:annotation>
            </xsd:element>
            <xsd:element name="ActiveSheet" type="xsd:int" default="1" minOccurs="0">
                <xsd:annotation>
                    <xsd:documentation>Contains the index number of the active worksheet in a workbook.</xsd:documentation>
                </xsd:annotation>
            </xsd:element>
            <xsd:element name="ActiveChart" type="xsd:string" minOccurs="0">
                <xsd:annotation>
                    <xsd:documentation>Contains the name of the active chart in a workbook.</xsd:documentation>
                </xsd:annotation>
            </xsd:element>
            <xsd:element name="FirstVisibleSheet" type="xsd:int" default="1" minOccurs="0">
                <xsd:annotation>
                    <xsd:documentation>Specifies that all worksheets before to the worksheet identified in this element are hidden and that no navigation tabs are shown for hidden sheets.</xsd:documentation>
                </xsd:annotation>
            </xsd:element>
            <xsd:element name="HidePivotTableFieldList" minOccurs="0">
                <xsd:annotation>
                    <xsd:documentation>Prevents the PivotTable Field List dialog box from appearing when the user moves the input focus to the PivotTable view.</xsd:documentation>
                </xsd:annotation>
            </xsd:element>
            <xsd:element name="ProtectStructure" type="TrueFalseType" minOccurs="0">
                <xsd:annotation>
                    <xsd:documentation>Specifies whether the structure of a workbook is protected.</xsd:documentation>
                </xsd:annotation>
            </xsd:element>
            <xsd:element name="ProtectWindows" type="TrueFalseType" minOccurs="0">
                <xsd:annotation>
                    <xsd:documentation>Specifies whether the worksheet windows are protected.</xsd:documentation>
                </xsd:annotation>
            </xsd:element>
            <xsd:element name="DisplayInkNotes" type="TrueFalseType" minOccurs="0">
                <xsd:annotation>
                    <xsd:documentation>Specifies whether ink comments are displayed.</xsd:documentation>
                </xsd:annotation>
            </xsd:element>
            <xsd:element name="EmbedSaveSmartTags" minOccurs="0">
                <xsd:annotation>
                    <xsd:documentation>Causes smart tags in the document to be saved to the XML spreadsheet.</xsd:documentation>
                </xsd:annotation>
            </xsd:element>
            <xsd:element name="FutureVer" type="xsd:string" minOccurs="0">
                <xsd:annotation>
                    <xsd:documentation>Enables Excel 2002 to warn users that they may lose data on save back to XMLSS, when the XMLSS loaded was created with Excel 2003. This element will only be written into the XMLSS if were writing out the MapInfo collection (new feature in Excel 2003).</xsd:documentation>
                </xsd:annotation>
            </xsd:element>
            <xsd:element name="TabRatio" type="xsd:int" default="600" minOccurs="0">
                <xsd:annotation>
                    <xsd:documentation>Specifies the ratio of the worksheet tab area width to the width of the horizontal scroll bar.</xsd:documentation>
                </xsd:annotation>
            </xsd:element>
            <xsd:element name="WindowIconic" minOccurs="0">
                <xsd:annotation>
                    <xsd:documentation>Specifies whether a workbook window is minimized.</xsd:documentation>
                </xsd:annotation>
            </xsd:element>
            <xsd:element name="DisplayDrawingObjects" default="DisplayShapes" minOccurs="0">
                <xsd:annotation>
                    <xsd:documentation>Specifies whether drawing objects are displayed, placeholders are displayed in their place, or all drawing objects are hidden in a workbook.</xsd:documentation>
                </xsd:annotation>
                <xsd:simpleType>
                    <xsd:restriction base="xsd:string">
                        <xsd:enumeration value="DisplayShapes" />
                        <xsd:enumeration value="PlaceHolders" />
                        <xsd:enumeration value="HideAll" />
                    </xsd:restriction>
                </xsd:simpleType>
            </xsd:element>
            <xsd:element name="CreateBackup" minOccurs="0">
                <xsd:annotation>
                    <xsd:documentation>Specifies whether a backup file is created when you save a workbook.</xsd:documentation>
                </xsd:annotation>
            </xsd:element>
            <xsd:element name="Calculation" type="CalculationWorkbookType" default="AutomaticCalculation" minOccurs="0">
                <xsd:annotation>
                    <xsd:documentation>Specifies the type of calculation for a PivotTable field or the mode of calculation for a workbook.</xsd:documentation>
                </xsd:annotation>
            </xsd:element>
            <xsd:element name="DoNotCalculateBeforeSave" minOccurs="0">
                <xsd:annotation>
                    <xsd:documentation>Specifies whether a workbook is calculated before it is saved.</xsd:documentation>
                </xsd:annotation>
            </xsd:element>
            <xsd:element name="Date1904" minOccurs="0">
                <xsd:annotation>
                    <xsd:documentation>Specifies the date system used in a workbook.</xsd:documentation>
                </xsd:annotation>
            </xsd:element>
            <xsd:element name="RefModeR1C1" minOccurs="0">
                <xsd:annotation>
                    <xsd:documentation>Specifies that references are in R1C1 reference style.</xsd:documentation>
                </xsd:annotation>
            </xsd:element>
            <xsd:element name="Iteration" minOccurs="0">
                <xsd:annotation>
                    <xsd:documentation>Specifies whether to track the number of iterations through circular references in formulas.</xsd:documentation>
                </xsd:annotation>
            </xsd:element>
            <xsd:element name="MaxIterations" minOccurs="0">
                <xsd:annotation>
                    <xsd:documentation>Specifies the maximum number of iterations when resolving circular references in Excel.</xsd:documentation>
                </xsd:annotation>
            </xsd:element>
            <xsd:element name="MaxChange" type="xsd:double" default="0.001" minOccurs="0">
                <xsd:annotation>
                    <xsd:documentation>Specifies the maximum amount of change for a value between each iteration when Excel resolves circular references in formulas.</xsd:documentation>
                </xsd:annotation>
            </xsd:element>
            <xsd:element name="PrecisionAsDisplayed" minOccurs="0">
                <xsd:annotation>
                    <xsd:documentation>Specifies whether calculations are performed using the precision of numbers as they are displayed.</xsd:documentation>
                </xsd:annotation>
            </xsd:element>
            <xsd:element name="DoNotSaveLinkValues" minOccurs="0">
                <xsd:annotation>
                    <xsd:documentation>Specifies whether the values in linked cells are saved.</xsd:documentation>
                </xsd:annotation>
            </xsd:element>
            <xsd:element name="NoAutoRecover" minOccurs="0">
                <xsd:annotation>
                    <xsd:documentation>Suppresses autorecovery of documents if Excel fails.</xsd:documentation>
                </xsd:annotation>
            </xsd:element>
            <xsd:element name="AcceptLabelsInFormulas" minOccurs="0">
                <xsd:annotation>
                    <xsd:documentation>Specifies whether range names are allowed in formulas.</xsd:documentation>
                </xsd:annotation>
            </xsd:element>
            <xsd:element name="Uncalced" minOccurs="0">
                <xsd:annotation>
                    <xsd:documentation>Specifies whether a workbook has already been calculated.</xsd:documentation>
                </xsd:annotation>
            </xsd:element>
        </xsd:sequence>
    </xsd:complexType>
</xsd:element>
Collapse Child Elements:
Name Type Min Occurs Max Occurs
PublishObjects x:PublishObjects 0 (1)
SupBook x:SupBook 0 unbounded
SelectedSheets x:SelectedSheets 0 (1)
WindowHidden x:WindowHidden 0 (1)
HideHorizontalScrollBar x:HideHorizontalScrollBar 0 (1)
HideVerticalScrollBar x:HideVerticalScrollBar 0 (1)
HideWorkbookTabs x:HideWorkbookTabs 0 (1)
WindowHeight x:WindowHeight 0 (1)
WindowWidth x:WindowWidth 0 (1)
WindowTopX x:WindowTopX 0 (1)
WindowTopY x:WindowTopY 0 (1)
ActiveSheet x:ActiveSheet 0 (1)
ActiveChart x:ActiveChart 0 (1)
FirstVisibleSheet x:FirstVisibleSheet 0 (1)
HidePivotTableFieldList x:HidePivotTableFieldList 0 (1)
ProtectStructure x:ProtectStructure 0 (1)
ProtectWindows x:ProtectWindows 0 (1)
DisplayInkNotes x:DisplayInkNotes 0 (1)
EmbedSaveSmartTags x:EmbedSaveSmartTags 0 (1)
FutureVer x:FutureVer 0 (1)
TabRatio x:TabRatio 0 (1)
WindowIconic x:WindowIconic 0 (1)
DisplayDrawingObjects x:DisplayDrawingObjects 0 (1)
CreateBackup x:CreateBackup 0 (1)
Calculation x:Calculation 0 (1)
DoNotCalculateBeforeSave x:DoNotCalculateBeforeSave 0 (1)
Date1904 x:Date1904 0 (1)
RefModeR1C1 x:RefModeR1C1 0 (1)
Iteration x:Iteration 0 (1)
MaxIterations x:MaxIterations 0 (1)
MaxChange x:MaxChange 0 (1)
PrecisionAsDisplayed x:PrecisionAsDisplayed 0 (1)
DoNotSaveLinkValues x:DoNotSaveLinkValues 0 (1)
NoAutoRecover x:NoAutoRecover 0 (1)
AcceptLabelsInFormulas x:AcceptLabelsInFormulas 0 (1)
Uncalced x:Uncalced 0 (1)
Documentation for Microsoft Office 2003 Reference Schemas

Generated using Liquid Studio - Developer Bundle 21.0.0.0