SpreadsheetDocument Members

Include Protected Members
Include Inherited Members

Defines SpreadsheetDocument - an OpenXmlPackage represents a Spreadsheet document.

The SpreadsheetDocument type exposes the following members.

Constructors

	Name	Description
	SpreadsheetDocument	Creates a SpreadsheetDocument.

Top

Properties

	Name	Description
	AutoSave	Gets the flag indicating whether the parts should be saved on disposing. (Inherited from OpenXmlPackage.)
	CompressionOption	Get / Set the compression level for content of new part. (Inherited from OpenXmlPackage.)
	CoreFilePropertiesPart	Gets the CoreFilePropertiesPart of the SpreadsheetDocument.
	CustomFilePropertiesPart	Gets the CustomFilePropertiesPart of the SpreadsheetDocument.
	DataPartReferenceRelationships	Enumerates all DataPartReferenceRelationship relationships. (Inherited from OpenXmlPartContainer.)
	DataParts	Enumerates all the DataPart in the document package. (Inherited from OpenXmlPackage.)
	DigitalSignatureOriginPart	Gets the DigitalSignatureOriginPart of the SpreadsheetDocument.
	DocumentType	Gets the type of the SpreadsheetDocument.
	ExtendedFilePropertiesPart	Gets the ExtendedFilePropertiesPart of the SpreadsheetDocument.
	ExternalRelationships	Enumerates all external relationships. Hyperlink relationships are not included, use HyperlinkRelationship property to enumerate hyperlink relationships. (Inherited from OpenXmlPartContainer.)
	FileOpenAccess	Gets the FileAccess setting for the document. The current IO access setting: Read, Write, or ReadWrite. (Inherited from OpenXmlPackage.)
	HyperlinkRelationships	Enumerates all hyperlink relationships. (Inherited from OpenXmlPartContainer.)
	MarkupCompatibilityProcessSettings	Gets the markup compatibilty settings applied in loading time (Inherited from OpenXmlPackage.)
	MaxCharactersInPart	Gets or sets a value indicating the maximum allowable number of characters in an Open XML part. A zero (0) value means no limits on the size of the part. A non-zero value specifies the maximum size, in characters. (Inherited from OpenXmlPackage.)
	Package	Gets the Package of the document. (Inherited from OpenXmlPackage.)
	PackageProperties	Gets the core properties (PackageProperties) of the Open XML document (package). (Inherited from OpenXmlPackage.)
	PartExtensionProvider	PartExtensionProvider which provide map from ContentType to part extension (Inherited from OpenXmlPackage.)
	Parts	Enumerates all parts which are relationship targets of this part. (Inherited from OpenXmlPartContainer.)
	QuickAccessToolbarCustomizationsPart	Gets the QuickAccessToolbarCustomizationsPart of the SpreadsheetDocument.
	RibbonAndBackstageCustomizationsPart	Gets the RibbonAndBackstageCustomizationsPart of the SpreadsheetDocument, only available in Office2010.
	RibbonExtensibilityPart	Gets the RibbonExtensibilityPart of the SpreadsheetDocument.
	ThumbnailPart	Gets the ThumbnailPart of the SpreadsheetDocument.
	WorkbookPart	Gets the WorkbookPart of the SpreadsheetDocument.

Top

Methods

	Name	Description
	AddAnnotation	Adds an object to the annotation list of this PartContainer (Inherited from OpenXmlPartContainer.)
	AddCoreFilePropertiesPart	Addd a CoreFilePropertiesPart to the SpreadsheetDocument.
	AddCustomFilePropertiesPart	Addd a CustomFilePropertiesPart to the SpreadsheetDocument.
	AddDigitalSignatureOriginPart	Addd a DigitalSignatureOriginPart to the SpreadsheetDocument.
	AddExtendedFilePropertiesPart	Addd a ExtendedFilePropertiesPart to the SpreadsheetDocument.
	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 external relationship. Do not add hyperlink relationships through this method. Use AddHyperlinkRelationship() instead. (Inherited from OpenXmlPartContainer.)
	AddExternalRelationship(String, Uri, String)	Adds 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 . (Overrides OpenXmlPartContainer.AddNewPart<T>(String, String).)
	AddPart<T>(T)	Add the part to the document. Must use the returned part to opertate the part added to the doucment (Inherited from OpenXmlPackage.)
	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.)
	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.)
	AddQuickAccessToolbarCustomizationsPart	Adds a QuickAccessToolbarCustomizationsPart to the SpreadsheetDocument.
	AddRibbonAndBackstageCustomizationsPart	Adds a RibbonAndBackstageCustomizationsPart to the SpreadsheetDocument, this part is only available in Office2010.
	AddRibbonExtensibilityPart	Adds a RibbonExtensibilityPart to the SpreadsheetDocument.
	AddThumbnailPart(String)	Addd a ThumbnailPart to the SpreadsheetDocument.
	AddThumbnailPart(ThumbnailPartType)	Adds a ThumbnailPart to the SpreadsheetDocument.
	AddWorkbookPart	Created the WorkbookPart and add it to this document.
	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.)
	ChangeDocumentType	Changes the document type.
	ChangeIdOfPart	Changes the relationship ID of the part. (Inherited from OpenXmlPartContainer.)
	Close	Saves and closes the OpenXml package plus all underlying part streams. (Inherited from OpenXmlPackage.)
	Create(Package, SpreadsheetDocumentType)	Creates a new instance of the SpreadsheetDocument class from the spcified package.
	Create(Stream, SpreadsheetDocumentType)	Creates a new instance of the SpreadsheetDocument class from the IO stream.
	Create(String, SpreadsheetDocumentType)	Creates a new instance of the SpreadsheetDocument class from the specified file.
	Create(Package, SpreadsheetDocumentType, Boolean)	Creates a new instance of the SpreadsheetDocument class from the spcified package.
	Create(Stream, SpreadsheetDocumentType, Boolean)	Creates a new instance of the SpreadsheetDocument class from the IO stream.
	Create(String, SpreadsheetDocumentType, Boolean)	Creates a new instance of the SpreadsheetDocument class from the specified file.
	CreateMediaDataPart(String)	Creates a new MediaDataPart to the document package. (Inherited from OpenXmlPackage.)
	CreateMediaDataPart(MediaDataPartType)	Creates a new MediaDataPart to the document package. (Inherited from OpenXmlPackage.)
	CreateMediaDataPart(String, String)	Creates a new MediaDataPart to the document package. (Inherited from OpenXmlPackage.)
	CreateRelationshipToPart(OpenXmlPart)	Adds relationship for the specified part to this part. (Inherited from OpenXmlPartContainer.)
	CreateRelationshipToPart(OpenXmlPart, String)	Adds relationship for the specified part to this part. (Inherited from OpenXmlPartContainer.)
	DeleteExternalRelationship(String)	Deletes the sepcified ExternalRelationship. (Inherited from OpenXmlPartContainer.)
	DeleteExternalRelationship(ExternalRelationship)	Deletes the specified external relationship. (Inherited from OpenXmlPartContainer.)
	DeletePart(String)	Deletes the specified child part from this part. (Inherited from OpenXmlPartContainer.)
	DeletePart(DataPart)	Deletes the sepcified DataPart from the document package. (Inherited from OpenXmlPackage.)
	DeletePart(OpenXmlPart)	Deletes a specified part in the package root layer. (Inherited from OpenXmlPartContainer.)
	DeleteParts<T>	Deletes all the parts which in the passed in collection from the document. (Inherited from OpenXmlPartContainer.)
	DeletePartsRecursivelyOfType<T>	Delete all the parts which is the specified part type from package recursively. (Inherited from OpenXmlPackage.)
	DeleteReferenceRelationship(String)	Deletes the sepcified reference relationship. (Inherited from OpenXmlPartContainer.)
	DeleteReferenceRelationship(ReferenceRelationship)	Deletes the specified reference relationship. (Inherited from OpenXmlPartContainer.)
	Dispose()	Flushes and saves the content, closes the document, and releases all resources. (Inherited from OpenXmlPackage.)
	Dispose(Boolean)	Flushes and saves the content, closes the document, and releases all resources. (Inherited from OpenXmlPackage.)
	Equals	(Inherited from Object.)
	Finalize	(Inherited from Object.)
	GetExternalRelationship	Gets the sepcified ExternalRelationship. (Inherited from OpenXmlPartContainer.)
	GetHashCode	(Inherited from Object.)
	GetIdOfPart	Gets the relationship ID of the part. (Inherited from OpenXmlPartContainer.)
	GetPartById	Gets the child part through the relationship ID. (Inherited from OpenXmlPartContainer.)
	GetPartsCountOfType<T>	Gets the count of all parts in 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	Gets the sepcified ReferenceRelationship. (Inherited from OpenXmlPartContainer.)
	GetType	(Inherited from Object.)
	MemberwiseClone	(Inherited from Object.)
	Open(Package)	Creates a new instance of the SpreadsheetDocument class from the spcified package.
	Open(Package, OpenSettings)	Creates a new instance of the SpreadsheetDocument class from the spcified package.
	Open(Stream, Boolean)	Creates a new instance of the SpreadsheetDocument class from the IO stream.
	Open(String, Boolean)	Creates a new instance of the SpreadsheetDocument class from the specified file.
	Open(Stream, Boolean, OpenSettings)	Creates a new instance of the SpreadsheetDocument class from the IO stream.
	Open(String, Boolean, OpenSettings)	Creates a new instance of the SpreadsheetDocument class from the specified file.
	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	Throw if object is disposed. (Inherited from OpenXmlPackage.)
	ToString	(Inherited from Object.)
	Validate	Obsolete. Validate the package ( do not validate the xml content in each part ). (Inherited from OpenXmlPackage.)

Top

See Also

Reference

SpreadsheetDocument Class

DocumentFormat.OpenXml.Packaging Namespace