WorkbookPart Class

Definition

Defines the WorkbookPart.

public class WorkbookPart : DocumentFormat.OpenXml.Packaging.OpenXmlPart
type WorkbookPart = class
    inherit OpenXmlPart
Public Class WorkbookPart
Inherits OpenXmlPart
Inheritance

Constructors

WorkbookPart()

Construtor of WorkbookPart

Properties

CalculationChainPart

Gets the CalculationChainPart of the WorkbookPart.

CellMetadataPart

Gets the CellMetadataPart of the WorkbookPart.

ChartsheetParts

Gets the ChartsheetParts of the WorkbookPart.

ConnectionsPart

Gets the ConnectionsPart of the WorkbookPart.

ContentType

Represents the content type (MIME type) of the content data in the part.

(Inherited from OpenXmlPart)
CustomDataPropertiesParts

Gets the CustomDataPropertiesParts of the WorkbookPart., only available in Office2010

CustomXmlMappingsPart

Gets the CustomXmlMappingsPart of the WorkbookPart.

CustomXmlParts

Gets the CustomXmlParts of the WorkbookPart.

DataPartReferenceRelationships

Enumerates all DataPartReferenceRelationship relationships.

(Inherited from OpenXmlPartContainer)
DialogsheetParts

Gets the DialogsheetParts of the WorkbookPart.

ExcelAttachedToolbarsPart

Gets the ExcelAttachedToolbarsPart of the WorkbookPart.

ExternalRelationships

Enumerates all external relationships. Hyperlink relationships are not included, use HyperlinkRelationship property to enumerate hyperlink relationships.

(Inherited from OpenXmlPartContainer)
ExternalWorkbookParts

Gets the ExternalWorkbookParts of the WorkbookPart.

HyperlinkRelationships

Enumerates all hyperlink relationships.

(Inherited from OpenXmlPartContainer)
InternationalMacroSheetParts

Gets the InternationalMacroSheetParts of the WorkbookPart.

MacroSheetParts

Gets the MacroSheetParts of the WorkbookPart.

OpenXmlPackage

Represents a part that is in the OpenXmlPackage container.

(Inherited from OpenXmlPart)
Parts

Enumerates all parts which are relationship targets of this part.

(Inherited from OpenXmlPartContainer)
PivotTableCacheDefinitionParts

Gets the PivotTableCacheDefinitionParts of the WorkbookPart.

RelationshipType

Gets the RelationshipType.

RootElement

Gets the root element of the current part. Returns null when the current part is empty or is not and XML content type.

(Inherited from OpenXmlPart)
SharedStringTablePart

Gets the SharedStringTablePart of the WorkbookPart.

SlicerCacheParts

Gets the SlicerCacheParts of the WorkbookPart., only available in Office2010

ThemePart

Gets the ThemePart of the WorkbookPart.

ThumbnailPart

Gets the ThumbnailPart of the WorkbookPart.

TimeLineCacheParts

Gets the TimeLineCacheParts of the WorkbookPart., only available in Office2013

Uri

Represents the internal part path in the package.

(Inherited from OpenXmlPart)
VbaProjectPart

Gets the VbaProjectPart of the WorkbookPart.

VolatileDependenciesPart

Gets the VolatileDependenciesPart of the WorkbookPart.

Workbook

Gets/Sets the root element of this part.

WorkbookRevisionHeaderPart

Gets the WorkbookRevisionHeaderPart of the WorkbookPart.

WorkbookStylesPart

Gets the WorkbookStylesPart of the WorkbookPart.

WorkbookUserDataPart

Gets the WorkbookUserDataPart of the WorkbookPart.

WorksheetParts

Gets the WorksheetParts of the WorkbookPart.

Methods

AddAnnotation(Object)

Adds an object to the annotation list of this PartContainer.

(Inherited from OpenXmlPartContainer)
AddCustomXmlPart(CustomXmlPartType)

Adds a CustomXmlPart to the WorkbookPart.

AddCustomXmlPart(CustomXmlPartType, String)

Adds a CustomXmlPart to the WorkbookPart.

AddCustomXmlPart(String)

Adds a CustomXmlPart to the WorkbookPart.

AddCustomXmlPart(String, String)

Adds a CustomXmlPart to the WorkbookPart.

AddExtendedPart(String, String, String)

Adds an extended part ( Application specific part ).

(Inherited from OpenXmlPartContainer)
AddExtendedPart(String, String, String, String)

Adds an extended part ( Application specific part ).

(Inherited from OpenXmlPartContainer)
AddExternalRelationship(String, Uri)

Adds an external relationship. Do not add hyperlink relationships through this method. Use AddHyperlinkRelationship() instead.

(Inherited from OpenXmlPartContainer)
AddExternalRelationship(String, Uri, String)

Adds an external relationship. Do not add hyperlink relationships through this method. Use AddHyperlinkRelationship() instead.

(Inherited from OpenXmlPartContainer)
AddHyperlinkRelationship(Uri, Boolean)

Adds a new hyperlink relationship.

(Inherited from OpenXmlPartContainer)
AddHyperlinkRelationship(Uri, Boolean, String)

Adds a new hyperlink relationship.

(Inherited from OpenXmlPartContainer)
AddNewPart<T>()

Adds a new part of type T.

(Inherited from OpenXmlPartContainer)
AddNewPart<T>(String)

Adds a new part of type T.

(Inherited from OpenXmlPartContainer)
AddNewPart<T>(String, String)

Adds a new part of type T.

(Inherited from OpenXmlPartContainer)
AddPart<T>(T)

Adds the part to the document. Must use the returned part to operate on the part added to the document.

(Inherited from OpenXmlPartContainer)
AddPart<T>(T, String)

Adds the part to the document with a given relationship identifier (ID). Must use the returned part to operate on the part added to the document

(Inherited from OpenXmlPartContainer)
AddThumbnailPart(String)

Adds a ThumbnailPart to the WorkbookPart.

AddThumbnailPart(String, String)

Adds a ThumbnailPart to the WorkbookPart.

AddThumbnailPart(ThumbnailPartType)

Adds a ThumbnailPart to the WorkbookPart.

AddThumbnailPart(ThumbnailPartType, String)

Adds a ThumbnailPart to the WorkbookPart.

Annotation(Type)

Get the first annotation object of the specified type from this PartContainer.

(Inherited from OpenXmlPartContainer)
Annotation<T>()

Get the first annotation object of the specified type from this PartContainer.

(Inherited from OpenXmlPartContainer)
Annotations(Type)

Gets a collection of annotations of the specified type for this PartContainer.

(Inherited from OpenXmlPartContainer)
Annotations<T>()

Gets a collection of annotations of the specified type for this PartContainer.

(Inherited from OpenXmlPartContainer)
ChangeIdOfPart(OpenXmlPart, String)

Changes the relationship ID of the part.

(Inherited from OpenXmlPartContainer)
CreateRelationshipToPart(OpenXmlPart)

Adds a relationship for the specified part to this part.

(Inherited from OpenXmlPartContainer)
CreateRelationshipToPart(OpenXmlPart, String)

Adds a relationship for the specified part to this part.

(Inherited from OpenXmlPartContainer)
DeleteExternalRelationship(ExternalRelationship)

Deletes the specified external relationship.

(Inherited from OpenXmlPartContainer)
DeleteExternalRelationship(String)

Deletes the specified ExternalRelationship.

(Inherited from OpenXmlPartContainer)
DeletePart(OpenXmlPart)

Deletes a specified part in the package root layer.

(Inherited from OpenXmlPartContainer)
DeletePart(String)

Deletes the specified child part from this part.

(Inherited from OpenXmlPartContainer)
DeleteParts<T>(IEnumerable<T>)

Deletes all the parts which are in the passed in collection from the document.

(Inherited from OpenXmlPartContainer)
DeleteReferenceRelationship(ReferenceRelationship)

Deletes the specified reference relationship.

(Inherited from OpenXmlPartContainer)
DeleteReferenceRelationship(String)

Deletes the specified reference relationship.

(Inherited from OpenXmlPartContainer)
FeedData(Stream)

Feeds data into the part stream. The stream of the part will be truncated at first.

(Inherited from OpenXmlPart)
GetExternalRelationship(String)

Gets the specified ExternalRelationship.

(Inherited from OpenXmlPartContainer)
GetIdOfPart(OpenXmlPart)

Gets the relationship ID of the part.

(Inherited from OpenXmlPartContainer)
GetParentParts()

Enumerates all parents that reference this part anywhere in the document.

(Inherited from OpenXmlPart)
GetPartById(String)

Gets the child part through the relationship ID.

(Inherited from OpenXmlPartContainer)
GetPartsCountOfType<T>()

Gets the count of all parts of type T.

(Inherited from OpenXmlPartContainer)
GetPartsOfType<T>()

Enumerates all the children parts of the specified type "T" of this part.

(Inherited from OpenXmlPartContainer)
GetPartsOfType<T>(ICollection<T>)

Gets all the children parts of the specified type "T" into "partCollection" of this part.

(Inherited from OpenXmlPartContainer)
GetReferenceRelationship(String)

Gets the specified ReferenceRelationship.

(Inherited from OpenXmlPartContainer)
GetStream()

Returns the part content data stream.

(Inherited from OpenXmlPart)
GetStream(FileMode)

Returns the content stream that was opened using a specified I/O FileMode.

(Inherited from OpenXmlPart)
GetStream(FileMode, FileAccess)

Returns the part content stream that was opened using a specified FileMode and FileAccess.

(Inherited from OpenXmlPart)
RemoveAnnotations(Type)

Removes the annotations of the specified type from this PartContainer.

(Inherited from OpenXmlPartContainer)
RemoveAnnotations<T>()

Removes the annotations of the specified type from this PartContainer.

(Inherited from OpenXmlPartContainer)
ThrowIfObjectDisposed()

Indicates whether the object is already disposed.

(Inherited from OpenXmlPart)
ValidateXml(String, ValidationEventHandler)
Obsolete.

Validates the XML content of the part by using the specified schema.

(Inherited from OpenXmlPart)
ValidateXml(XmlSchemaSet, ValidationEventHandler)
Obsolete.

Validates the XML content of the part by using the specified schema.

(Inherited from OpenXmlPart)

Applies to