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.