WorksheetPart Members

  • Article

Include Protected Members
Include Inherited Members

Defines the WorksheetPart.

The WorksheetPart type exposes the following members.

Constructors

  Name Description
Protected method WorksheetPart Construtor of WorksheetPart

Top

Properties

  Name Description
Public property ContentType Gets the ContentType. (Overrides OpenXmlPart.ContentType.)
Public property ControlPropertiesParts Gets the ControlPropertiesParts of the WorksheetPart., only available in Office2010
Public property CustomPropertyParts Gets the CustomPropertyParts of the WorksheetPart.
Public property DataPartReferenceRelationships Enumerates all DataPartReferenceRelationship relationships. (Inherited from OpenXmlPartContainer.)
Public property DrawingsPart Gets the DrawingsPart of the WorksheetPart.
Public property EmbeddedControlPersistenceBinaryDataParts Gets the EmbeddedControlPersistenceBinaryDataParts of the WorksheetPart.
Public property EmbeddedControlPersistenceParts Gets the EmbeddedControlPersistenceParts of the WorksheetPart.
Public property EmbeddedObjectParts Gets the EmbeddedObjectParts of the WorksheetPart.
Public property EmbeddedPackageParts Gets the EmbeddedPackageParts of the WorksheetPart.
Public property ExternalRelationships Enumerates all external relationships. Hyperlink relationships are not included, use HyperlinkRelationship property to enumerate hyperlink relationships. (Inherited from OpenXmlPartContainer.)
Public property HyperlinkRelationships Enumerates all hyperlink relationships. (Inherited from OpenXmlPartContainer.)
Public property ImageParts Gets the ImageParts of the WorksheetPart.
Public property OpenXmlPackage The OpenXmlPackage contains this part (Inherited from OpenXmlPart.)
Public property Parts Enumerates all parts which are relationship targets of this part. (Inherited from OpenXmlPartContainer.)
Public property PivotTableParts Gets the PivotTableParts of the WorksheetPart.
Public property QueryTableParts Gets the QueryTableParts of the WorksheetPart.
Public property RelationshipType Gets the RelationshipType. (Overrides OpenXmlPart.RelationshipType.)
Public property RootElement (Inherited from OpenXmlPart.)
Public property SingleCellTablePart Gets the SingleCellTablePart of the WorksheetPart.
Public property SlicersParts Gets the SlicersParts of the WorksheetPart., only available in Office2010
Public property SpreadsheetPrinterSettingsParts Gets the SpreadsheetPrinterSettingsParts of the WorksheetPart.
Public property TableDefinitionParts Gets the TableDefinitionParts of the WorksheetPart.
Public property Uri The internal part path in the package (Inherited from OpenXmlPart.)
Public property VmlDrawingParts Gets the VmlDrawingParts of the WorksheetPart.
Public property Worksheet Gets/Sets the root element of this part.
Public property WorksheetCommentsPart Gets the WorksheetCommentsPart of the WorksheetPart.
Public property WorksheetSortMapPart Gets the WorksheetSortMapPart of the WorksheetPart.

Top

Methods

  Name Description
Public method AddAnnotation Adds an object to the annotation list of this PartContainer (Inherited from OpenXmlPartContainer.)
Public method AddCustomPropertyPart(String) Adds a CustomPropertyPart to the WorksheetPart.
Public method AddCustomPropertyPart(CustomPropertyPartType) Adds a CustomPropertyPart to the WorksheetPart.
Public method AddCustomPropertyPart(String, String) Adds a CustomPropertyPart to the WorksheetPart.
Public method AddCustomPropertyPart(CustomPropertyPartType, String) Adds a CustomPropertyPart to the WorksheetPart.
Public method AddEmbeddedControlPersistenceBinaryDataPart(String) Adds a EmbeddedControlPersistenceBinaryDataPart to the WorksheetPart.
Public method AddEmbeddedControlPersistenceBinaryDataPart(EmbeddedControlPersistenceBinaryDataPartType) Adds a EmbeddedControlPersistenceBinaryDataPart to the WorksheetPart.
Public method AddEmbeddedControlPersistenceBinaryDataPart(String, String) Adds a EmbeddedControlPersistenceBinaryDataPart to the WorksheetPart.
Public method AddEmbeddedControlPersistenceBinaryDataPart(EmbeddedControlPersistenceBinaryDataPartType, String) Adds a EmbeddedControlPersistenceBinaryDataPart to the WorksheetPart.
Public method AddEmbeddedControlPersistencePart(String) Adds a EmbeddedControlPersistencePart to the WorksheetPart.
Public method AddEmbeddedControlPersistencePart(EmbeddedControlPersistencePartType) Adds a EmbeddedControlPersistencePart to the WorksheetPart.
Public method AddEmbeddedControlPersistencePart(String, String) Adds a EmbeddedControlPersistencePart to the WorksheetPart.
Public method AddEmbeddedControlPersistencePart(EmbeddedControlPersistencePartType, String) Adds a EmbeddedControlPersistencePart to the WorksheetPart.
Public method AddEmbeddedObjectPart Adds a EmbeddedObjectPart to the WorksheetPart.
Public method AddEmbeddedPackagePart Adds a EmbeddedPackagePart to the WorksheetPart.
Public method AddExtendedPart(String, String, String) Adds an extended part ( Application specific part ) (Inherited from OpenXmlPartContainer.)
Public method AddExtendedPart(String, String, String, String) Adds an extended part ( Application specific part ) (Inherited from OpenXmlPartContainer.)
Public method AddExternalRelationship(String, Uri) Adds external relationship. Do not add hyperlink relationships through this method. Use AddHyperlinkRelationship() instead. (Inherited from OpenXmlPartContainer.)
Public method AddExternalRelationship(String, Uri, String) Adds external relationship. Do not add hyperlink relationships through this method. Use AddHyperlinkRelationship() instead. (Inherited from OpenXmlPartContainer.)
Public method AddHyperlinkRelationship(Uri, Boolean) Adds a new hyperlink relationship. (Inherited from OpenXmlPartContainer.)
Public method AddHyperlinkRelationship(Uri, Boolean, String) Adds a new hyperlink relationship. (Inherited from OpenXmlPartContainer.)
Public method AddImagePart(String) Adds a ImagePart to the WorksheetPart.
Public method AddImagePart(ImagePartType) Adds a ImagePart to the WorksheetPart.
Public method AddImagePart(String, String) Adds a ImagePart to the WorksheetPart.
Public method AddImagePart(ImagePartType, String) Adds a ImagePart to the WorksheetPart.
Public method AddNewPart<T>() Adds a new part of type T (Inherited from OpenXmlPartContainer.)
Public method AddNewPart<T>(String) Adds a new part of type T (Inherited from OpenXmlPartContainer.)
Public method AddNewPart<T>(String, String) Adds a new part of type T. (Inherited from OpenXmlPartContainer.)
Public method AddPart<T>(T) Adds the part to the document. Must use the returned part to opertate the part added to the doucment (Inherited from OpenXmlPartContainer.)
Public method AddPart<T>(T, String) Adds the part to the document with a given relationship identifier (ID). Must use the returned part to opertate the part added to the doucment (Inherited from OpenXmlPartContainer.)
Public method Annotation(Type) Get the first annotation object of the specified type from this PartContainer (Inherited from OpenXmlPartContainer.)
Public method Annotation<T>() Get the first annotation object of the specified type from this PartContainer (Inherited from OpenXmlPartContainer.)
Public method Annotations(Type) Gets a collection of annotations of the specified type for this PartContainer (Inherited from OpenXmlPartContainer.)
Public method Annotations<T>() Gets a collection of annotations of the specified type for this PartContainer (Inherited from OpenXmlPartContainer.)
Public method ChangeIdOfPart Changes the relationship ID of the part. (Inherited from OpenXmlPartContainer.)
Public method CreateRelationshipToPart(OpenXmlPart) Adds relationship for the specified part to this part. (Inherited from OpenXmlPartContainer.)
Public method CreateRelationshipToPart(OpenXmlPart, String) Adds relationship for the specified part to this part. (Inherited from OpenXmlPartContainer.)
Public method DeleteExternalRelationship(String) Deletes the sepcified ExternalRelationship. (Inherited from OpenXmlPartContainer.)
Public method DeleteExternalRelationship(ExternalRelationship) Deletes the specified external relationship. (Inherited from OpenXmlPartContainer.)
Public method DeletePart(String) Deletes the specified child part from this part. (Inherited from OpenXmlPartContainer.)
Public method DeletePart(OpenXmlPart) Deletes a specified part in the package root layer. (Inherited from OpenXmlPartContainer.)
Public method DeleteParts<T> Deletes all the parts which in the passed in collection from the document. (Inherited from OpenXmlPartContainer.)
Public method DeleteReferenceRelationship(String) Deletes the sepcified reference relationship. (Inherited from OpenXmlPartContainer.)
Public method DeleteReferenceRelationship(ReferenceRelationship) Deletes the specified reference relationship. (Inherited from OpenXmlPartContainer.)
Public method Equals (Inherited from Object.)
Public method FeedData Feed data into the part stream. The stream of the part will be truncated at first. (Inherited from OpenXmlPart.)
Protected method Finalize (Inherited from Object.)
Public method GetExternalRelationship Gets the sepcified ExternalRelationship. (Inherited from OpenXmlPartContainer.)
Public method GetHashCode (Inherited from Object.)
Public method GetIdOfPart Gets the relationship ID of the part. (Inherited from OpenXmlPartContainer.)
Public method GetParentParts Enum all parents that reference this part anywhere in the document. (Inherited from OpenXmlPart.)
Public method GetPartById Gets the child part through the relationship ID. (Inherited from OpenXmlPartContainer.)
Public method GetPartsCountOfType<T> Gets the count of all parts in type T. (Inherited from OpenXmlPartContainer.)
Public method GetPartsOfType<T>() Enumerates all the children parts of the specified type "T" of this part. (Inherited from OpenXmlPartContainer.)
Public method GetPartsOfType<T>(ICollection<T>) Gets all the children parts of the specified type "T" into "partCollection" of this part. (Inherited from OpenXmlPartContainer.)
Public method GetReferenceRelationship Gets the sepcified ReferenceRelationship. (Inherited from OpenXmlPartContainer.)
Public method GetStream() Returns the part content data stream. (Inherited from OpenXmlPart.)
Public method GetStream(FileMode) Returns the content stream opened in a specified I/O FileMode. (Inherited from OpenXmlPart.)
Public method GetStream(FileMode, FileAccess) Returns the part content stream opened with a specified FileMode and FileAccess. (Inherited from OpenXmlPart.)
Public method GetType (Inherited from Object.)
Protected method MemberwiseClone (Inherited from Object.)
Public method RemoveAnnotations(Type) Removes the annotations of the specified type from this PartContainer (Inherited from OpenXmlPartContainer.)
Public method RemoveAnnotations<T>() Removes the annotations of the specified type from this PartContainer (Inherited from OpenXmlPartContainer.)
Protected method ThrowIfObjectDisposed Test whether the object is already disposed. (Inherited from OpenXmlPart.)
Public method ToString (Inherited from Object.)
Public method ValidateXml(String, ValidationEventHandler) Obsolete. Validate the xml content of the part according the specified schema. (Inherited from OpenXmlPart.)
Public method ValidateXml(XmlSchemaSet, ValidationEventHandler) Obsolete. Validate the xml content of the part according the specified schema. (Inherited from OpenXmlPart.)

Top

See Also

Reference

WorksheetPart Class

DocumentFormat.OpenXml.Packaging Namespace