The requested page is not available for the requested platform. You are viewing the content for .NET Framework 4.5.2+ platform.
.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
.NET Core 3.0+
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
CreateNewDocument()

Creates and loads a new empty workbook.

GetService(Type) Gets the service object of the specified type.
(Inherited from IServiceProvider)
LoadDocument(Byte[])

Loads the document from a Byte[] array.

LoadDocument(Byte[], DocumentFormat)

Loads a document from a byte array.

LoadDocument(Stream)

Loads the document from a stream.

LoadDocument(Stream, DocumentFormat)

Loads a document from a stream, specifying the document format.

LoadDocument(String)

Loads a document from a file.

LoadDocument(String, DocumentFormat)

Loads a document from a file, specifying the document format.

SaveDocument(DocumentFormat)

Saves a document to an array of bytes in the specified format.

SaveDocument(DocumentFormat, EncryptionSettings)

Saves a document to an array of bytes in the specified format with the specified encryption settings.

SaveDocument(Stream, DocumentFormat)

Saves the document to a stream, specifying the document format.

SaveDocument(Stream, DocumentFormat, EncryptionSettings)

Saves the document to a stream, specifying the document format anf encryption options.

SaveDocument(String)

Saves the document to the specified file. The file format is identified by the file extension.

SaveDocument(String, DocumentFormat)

Saves the document to a file, specifying the document format.

SaveDocument(String, DocumentFormat, EncryptionSettings)

Saves the document to a file, specifying the document format and encryption options.

SaveDocument(String, EncryptionSettings)

Saves the document to the specified file with the specified encryption options. 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.

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.

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 cancelling 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.

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