Skip to main content
Row

ISpreadsheetComponent Members

Exposes the basic functionality to manage workbooks.

Properties

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.

Methods

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.

Events

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