officefileapi-devexpress-dot-spreadsheet-dot-ispreadsheetcomponent-dot-underscore-members.md
Exposes the basic functionality to manage workbooks.
| Name | Description |
|---|---|
| Clipboard | Provides access to the object used for working with the system Clipboard. |
| Modified | Gets or sets whether the document content was modified since it was last saved. |
| Options | Provides access to various options which can be specified for the workbook. |
| Unit | Gets or sets a unit of measure used in the workbook. |
| Name | Description |
|---|---|
| AddService(Type, ServiceCreatorCallback, Boolean) | Adds the specified service to the service container, and optionally promotes the service to parent service containers. Inherited from IServiceContainer. |
| AddService(Type, ServiceCreatorCallback) | Adds the specified service to the service container. Inherited from IServiceContainer. |
| AddService(Type, Object, Boolean) | Adds the specified service to the service container, and optionally promotes the service to any parent service containers. Inherited from IServiceContainer. |
| AddService(Type, Object) | Adds the specified service to the service container. Inherited from IServiceContainer. |
| CreateNewDocument() | Creates and loads a new empty workbook. |
| GetService(Type) | Gets the service object of the specified type. Inherited from IServiceProvider. |
| LoadDocument(Byte[], DocumentFormat) | Loads a document from a byte array. |
| LoadDocument(Byte[]) | Loads the document from a Byte[] array. |
| LoadDocument(Stream, DocumentFormat) | Loads a document from a stream, specifying the document format. |
| LoadDocument(Stream) | Loads the document from a stream. |
| LoadDocument(String, DocumentFormat) | Loads a document from a file, specifying the document format. |
| LoadDocument(String) | Loads a document from a file. |
| RemoveService(Type, Boolean) | Removes the specified service type from the service container, and optionally promotes the service to parent service containers. Inherited from IServiceContainer. |
| RemoveService(Type) | Removes the specified service type from the service container. Inherited from IServiceContainer. |
| SaveDocument(DocumentFormat, EncryptionSettings) | Saves a document to an array of bytes in the specified format with the specified encryption settings. |
| SaveDocument(DocumentFormat) | Saves a document to an array of bytes in the specified format. |
| SaveDocument(Stream, DocumentFormat, EncryptionSettings) | Saves the document to a stream, specifying the document format anf encryption options. |
| SaveDocument(Stream, DocumentFormat) | Saves the document to a stream, specifying the document format. |
| SaveDocument(String, DocumentFormat, EncryptionSettings) | Saves the document to a file, specifying the document format and encryption options. |
| SaveDocument(String, DocumentFormat) | Saves the document to a file, specifying the document format. |
| SaveDocument(String, EncryptionSettings) | Saves the document to the specified file with the specified encryption options. The file format is identified by the file extension. |
| SaveDocument(String) | Saves the document to the specified file. The file format is identified by the file extension. |
| Name | Description |
|---|---|
| ActiveSheetChanged | Occurs after an active worksheet in a workbook has been changed. |
| ActiveSheetChanging | Occurs when an active worksheet in a workbook is about to be changed. |
| BeforeEncodingDetection | Occurs before detecting the encoding of the loaded CSV or TXT data. |
| BeforeExport | Occurs before the document is saved (exported to a certain format). |
| BeforeImport | Occurs before a document is loaded (imported from an external source). |
| BeforePrintSheet | Occurs before printing a workbook. |
| ClipboardDataObtained | Occurs after data on the Clipboard is obtained and recognized, but before data is actually pasted. |
| ClipboardDataPasted | Occurs after data has been pasted from the Clipboard onto a worksheet. |
| ClipboardDataPasting | Occurs before data is pasted from the Clipboard. |
| ColumnsInserted | Occurs after new columns have been added to a worksheet. |
| ColumnsInserting | Occurs when new columns are about to be inserted into a worksheet. |
| ColumnsRemoved | Occurs after columns have been deleted from a worksheet. |
| ColumnsRemoving | Occurs when columns are about to be deleted from a worksheet. |
| ColumnWidthChanged | Occurs after the column width was changed. |
| CommentInserted | Occurs when a comment is inserted. |
| CommentInserting | Occurs before inserting a comment. |
| CommentRemoved | Occurs when a comment is deleted. |
| CommentRemoving | Occurs before deleting a comment. |
| CopiedRangePasted | Occurs after the range content has been pasted into target cells. |
| CopiedRangePasting | Occurs before the range content is pasted into target cells. |
| CustomAssemblyLoading | Occurs before a custom assembly is loaded for use as the Entity Framework data source during mail merge and allows you to cancel loading. |
| DefinedNameConflictResolving | Occurs when a formula or sheet being moved or copied contains the defined name, which already exists on the destination worksheet or workbook. |
| DocumentClosing | Occurs when a document that has not yet been saved is about to be closed. |
| DocumentLoaded | Occurs after a document is loaded. |
| DocumentSaved | Occurs after a document has been saved. |
| EmptyDocumentCreated | Occurs when a new document is created. |
| EncryptedFileIntegrityCheckFailed | Raises when the encrypted file did not pass the data integrity verification. |
| EncryptedFilePasswordCheckFailed | Occurs when the encryption password is empty or invalid. |
| EncryptedFilePasswordRequest | Raises when the WorkbookImportOptions.Password property is not set or contains a wrong password. |
| InitializeDocument | Occurs before a document is loaded. Handle this event to set initial document settings. |
| InvalidFormatException | Fires when the supplied data could not be recognized as data in the assumed format for import. |
| ModifiedChanged | Occurs when the value of the ISpreadsheetComponent.Modified property is changed. |
| PanesFrozen | Occurs after a worksheet area has been frozen. |
| PanesUnfrozen | Occurs after a frozen worksheet area has been unlocked. |
| RangeCopied | Occurs after the range content has been copied. |
| RangeCopying | Occurs before a cell range is copied in a worksheet. |
| RowHeightChanged | Occurs after the row height was changed. |
| RowsInserted | Occurs after new rows have been added to a worksheet. |
| RowsInserting | Occurs when new rows are about to be inserted into a worksheet. |
| RowsRemoved | Occurs after rows have been deleted from a worksheet. |
| RowsRemoving | Occurs when rows are about to be deleted from a worksheet. |
| ScrollPositionChanged | Occurs when the scroll position changes in a worksheet. |
| SelectionChanged | Fires in response to changing cell selection in a worksheet. |
| ShapeInserted | Occurs after a drawing object has been inserted into a worksheet. |
| ShapeRemoved | Occurs after a drawing object has been removed from a worksheet. |
| ShapeRemoving | Occurs before a drawing object is removed from a worksheet. |
| ShapesCopying | Occurs before a drawing object is copied in a worksheet. |
| SheetInserted | Occurs after a new worksheet has been added to a workbook. |
| SheetRemoved | Occurs after a worksheet has been removed from a workbook. |
| SheetRemoving | Occurs when a worksheet is about to be removed from a workbook. |
| SheetRenamed | Occurs after a worksheet has been renamed. |
| SheetRenaming | Occurs when a worksheet is about to be renamed. |
| UnitChanged | Fires after a unit of measurement used in the workbook is changed. |
| UnitChanging | Fires before a unit of measurement used within the workbook is changed. |
See Also