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.

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.

Controls

Tools

Controls and Extensions

Tools

Maintenance Mode

Controls

Tools

Controls and Extensions

Tools

Maintenance Mode

ISpreadsheetComponent Members

Properties

Methods

Events