Compartilhar via


WorkbookProperties Class

Defines the WorkbookProperties Class.This class is only available in Office2010.When the object is serialized out as xml, its qualified name is x14:workbookPr.

Inheritance Hierarchy

System.Object
  DocumentFormat.OpenXml.OpenXmlElement
    DocumentFormat.OpenXml.OpenXmlLeafElement
      DocumentFormat.OpenXml.Office2010.Excel.WorkbookProperties

Namespace:  DocumentFormat.OpenXml.Office2010.Excel
Assembly:  DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)

Syntax

'Declaration
<OfficeAvailabilityAttribute(FileFormatVersions.Office2010)> _
Public Class WorkbookProperties _
    Inherits OpenXmlLeafElement
'Usage
Dim instance As WorkbookProperties
[OfficeAvailabilityAttribute(FileFormatVersions.Office2010)]
public class WorkbookProperties : OpenXmlLeafElement

Remarks

2.4.12 workbookPr

Target namespace: https://schemas.microsoft.com/office/spreadsheetml/2010/main

A CT_WorkbookPr element that specifies additional properties for a workbook. See Workbook under Extensions by Part for how this element integrates with [ISO/IEC-29500-1].

The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this element.

<xsd:element name="workbookPr" type="CT_WorkbookPr"/>

See section 5.3 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).

2.6.10 CT_WorkbookPr

Target namespace: https://schemas.microsoft.com/office/spreadsheetml/2010/main

Referenced by: workbookPr

A complex type that specifies additional properties for a workbook.

Attributes:

defaultImageDpi : An unsignedInt ([XMLSCHEMA2] section 3.3.22) attribute that specifies the resolution in which images in the workbook are saved, in DPI, when the autoCompressPictures attribute of the WorkbookPr ([ISO/IEC-29500-1] section 18.2.28) element is “TRUE” and the CT_UseLocalDpi ([MS-ODRAWXML] section 2.3.4) element of the drawings part ([ISO/IEC-29500-1] section 12.3.8) corresponding to the image being saved is “FALSE”. MUST be equal to 96, 150 or 220.

discardImageEditData : A boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether all CT_Photo ([MS-ODRAWXML] section 2.3.3) elements and cropped out areas of images in the workbook are not saved.

accuracyVersion : An unsignedInt ([XMLSCHEMA2] section 3.3.22) attribute that specifies how functions are calculated in the workbook. SHOULD be equal to 0.<19>

The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this complex type.

<xsd:complexType name="CT_WorkbookPr">

<xsd:attribute name="defaultImageDpi" type="xsd:unsignedInt" default="220"/>

<xsd:attribute name="discardImageEditData" type="xsd:boolean" default="false"/>

<xsd:attribute name="accuracyVersion" type="xsd:unsignedInt"/>

</xsd:complexType>

See section 5.3 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).

Thread Safety

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

See Also

Reference

WorkbookProperties Members

DocumentFormat.OpenXml.Office2010.Excel Namespace