DevExpress.Spreadsheet Namespace
Contains classes and interfaces that implement basic spreadsheet functionality.
Assemblies: DevExpress.Docs.v24.2.dll, DevExpress.Spreadsheet.v24.2.Core.dll
NuGet Packages: DevExpress.Document.Processor, DevExpress.Spreadsheet.Core
Classes
Name | Description |
---|---|
ActiveSheetChangedEventArgs | Provides data for the SpreadsheetControl.ActiveSheetChanged event. |
ActiveSheetChangeEventArgsBase | Base class for classes that provides data for the ActiveSheetChanging and ActiveSheetChanged events of the SpreadsheetControl. |
ActiveSheetChangingEventArgs | Provides data for the SpreadsheetControl.ActiveSheetChanging event. |
BeforePrintSheetEventArgs | Provides data for the SpreadsheetControl.BeforePrintSheet event. |
CellRangeExtensions static | Contains extension methods for the CellRange interface. |
CellValue | A data value contained in a cell. |
ChartSheetExtensions static |
Defines extension methods for the ChartSheet interface. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use these methods in production code. |
ClipboardDataObtainedEventArgs | Provides data for the SpreadsheetControl.ClipboardDataObtained event. |
ClipboardDataPastedEventArgs | Provides data for the SpreadsheetControl.ClipboardDataPasted event. |
ColumnsChangedEventArgs | Provides data for the SpreadsheetControl.ColumnsInserted and the SpreadsheetControl.ColumnsRemoved events. |
ColumnsChangingEventArgs | Provides data for the SpreadsheetControl.ColumnsInserting and SpreadsheetControl.ColumnsRemoving events. |
ColumnWidthChangedEventArgs | Provides data for the SpreadsheetControl.ColumnWidthChanged event. |
CommentChangedEventArgs | Provides data for the SpreadsheetControl.CommentInserted and SpreadsheetControl.CommentRemoved events. |
CommentInsertingEventArgs | Provides data for the SpreadsheetControl.CommentInserting event. |
CommentRemovingEventArgs | Provides data for the SpreadsheetControl.CommentRemoving event. |
CopiedRangePastedEventArgs | Provides data for the SpreadsheetControl.CopiedRangePasted event. |
CopiedRangePastingEventArgs | Provides data for the SpreadsheetControl.CopiedRangePasting event. |
DataBindingErrorEventArgs | Provides data for the WorksheetDataBindingCollection.Error event. |
DataImportOptions | Contains properties which allow you to specify whether the imported data are treated as formulas, the cell reference style in use, the culture-specific decimal and list separators and a custom value converter. |
DataSourceImportOptions | Allows you to specify data source fields to import. |
DataSourceOptionsBase | Serves as the base for the ExternalDataSourceOptions and RangeDataSourceOptions classes. |
DateGrouping | A criterion for date values. |
DefinedNameConflictResolvingEventArgs | Provides data for the DefinedNameConflictResolving event. |
DocumentOptions | Provides access to workbook options. |
EditRangePermission | Contains security information required for applying user-level security to a ProtectedRange. |
EncryptedFileIntegrityCheckFailedEventArgs | Provides data for the EncryptedFileIntegrityCheckFailed event. |
EncryptedFilePasswordCheckFailedEventArgs | Provides data for the EncryptedFilePasswordCheckFailed event. |
EncryptedFilePasswordRequestEventArgs | Provides data for the EncryptedFilePasswordRequest event. |
EncryptionSettings | Base implementation of the EncryptionOptions interface. |
ExternalDataSourceOptions | Contains options for data retrieval from an external data source when establishing a data binding. |
FillSortField | Specifies a fill field to sort by and the comparer used for sorting. |
FilterValue | A value or values used in a filter criterion. |
FontColorSortField | Specifies a font color field to sort by and the font color used for sorting. |
HeaderFooterCode static | Contains format codes used in headers and footers. |
PanesFrozenEventArgs | Provides data for the SpreadsheetControl.PanesFrozen event. |
PanesUnfrozenEventArgs | Provides data for the SpreadsheetControl.PanesUnfrozen event. |
PivotGroupingValue | Contains data used to specify starting and ending values for the range grouping. |
PivotItemReference | Represents a reference to a specific item in a pivot table. |
RangeCopiedEventArgs | Provides data for the SpreadsheetControl.RangeCopied event. |
RangeCopyingEventArgs | Provides data for the SpreadsheetControl.RangeCopying event. |
RangeDataSourceOptions | Contains various options for a data source created from a cell range. |
RangeExtensions static | Defines extension methods for the CellRange interface. |
RangeImageOptions | Contains options used to export a cell range to an image. |
RichTextRunFont | Contains font attributes for a rich text run. |
RichTextString | Rich formatted text in a cell. |
RowHeightChangedEventArgs | Provides data for the SpreadsheetControl.RowHeightChanged event. |
RowsChangedEventArgs | Provides data for the SpreadsheetControl.RowsInserted and the SpreadsheetControl.RowsRemoved events. |
RowsChangingEventArgs | Provides data for the SpreadsheetControl.RowsInserting and SpreadsheetControl.RowsRemoving events. |
RowsColumnsChangingEventArgsBase | Serves as the base for classes which provide data for the events which occur on inserting or removing rows and columns via the SpreadsheetControl‘s UI. |
ScrollPositionChangedEventArgs | Provides data for the SpreadsheetControl.ScrollPositionChanged event. |
SearchOptions | Contains options affecting search in a document. |
ShapeChangedEventArgs | Provides data for the SpreadsheetControl.ShapeInserted and SpreadsheetControl.ShapeRemoved events. |
ShapeChangingEventArgs | Provides data for the SpreadsheetControl.ShapeRemoving event. |
ShapesCopyingEventArgs | Provides data for the SpreadsheetControl.ShapesCopying event. |
SheetInsertedEventArgs | Provides data for the SpreadsheetControl.SheetInserted event. |
SheetRemovedEventArgs | Provides data for the SpreadsheetControl.SheetRemoved event. |
SheetRemovingEventArgs | Provides data for the SpreadsheetControl.SheetRemoving event. |
SheetRenamedEventArgs | Provides data for the SpreadsheetControl.SheetRenamed event. |
SheetRenamingEventArgs | Provides data for the SpreadsheetControl.SheetRenaming event. |
SheetThumbnailOptions | Contains options used to generate a thumbnail from a worksheet or chart sheet. |
SortCondition | Combines the column index and the specification of the direction in which column values should be sorted. |
SortField | Specifies the field by which to sort, and the comparer used for sorting. |
SortFieldBase | Base class for sort fields. |
SpreadsheetBeforeExportEventArgs | Provides data for the ISpreadsheetComponent.BeforeExport event. |
SpreadsheetBeforeImportEventArgs | Provides data for the ISpreadsheetComponent.BeforeImport event. |
SpreadsheetCustomAssemblyLoadingEventArgs | Provides data for the SpreadsheetControl.CustomAssemblyLoading event. |
SpreadsheetImageSource | An object that provides an image for the spreadsheet. |
SpreadsheetInvalidFormatExceptionEventArgs | Provides data for the ISpreadsheetComponent.InvalidFormatException event. |
SpreadsheetValidateCustomSqlQueryEventArgs | Provides data for the SpreadsheetControl.ValidateCustomSqlQuery event. |
ThemeColorScheme | Specifies document theme colors. |
ValueObject | An object that can be used to specify a value associated with a custom cell in-place editor or to create a criterion for data validation. |
Workbook | A non-visual component that allows you to generate and modify spreadsheet documents. |
WorkbookExtensions static | Defines extension methods for objects exposing the IWorkbook interface. |
WorkbookMergeOptions | Obsolete. Provides options used to specify how to merge multiple workbooks into a single document. |
WorkbookOptions | Contains workbook options. |
WorksheetCopyOptions | Allows you to define copy options when you copy data from one worksheet to another. |
WorksheetExtensions static |
Defines extension methods for the Worksheet interface. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use these methods in production code. |
WorksheetThumbnailOptions | Contains options used to generate a thumbnail from a worksheet. |
Interfaces
Name | Description |
---|---|
Alignment | Provides access to the cell content alignment settings. |
AreasCollection | A collection of worksheet CellRange objects from which a union range is composed. |
ArrayFormula | Contains a legacy array formula and the range to which the formula is applied. |
ArrayFormulaCollection | A collection of ArrayFormula objects. |
ArrowSettings | Contains arrowhead settings for a connector. |
AutoFilterBase | Base interface for objects which implement filtering functionality in a worksheet and tables. |
AutoFilterColumn | Provides filtering functionality for a column. |
AutoFilterColumnCollection | A collection of AutoFilterColumn objects. |
AverageConditionalFormatting | Represents the "above or below average" conditional formatting rule. |
Border | Provides access to the line characteristics of a cell border. |
Borders | Provides access to cell borders. |
ButtonFormControl | A button form control. |
CalculationOptions | Contains options used for calculation of formulas contained in the worksheet cells. |
Cell | A single cell in a worksheet. |
CellCollection | A collection of all cells in a worksheet. |
CellRange | Defines a range of cells and serves as the base for the Cell, CellCollection, Column and Row interfaces. |
ChartSheet | A separate sheet in a workbook that contains only a chart. |
ChartSheetCollection | A collection of ChartSheet objects contained in a workbook. |
ChartSheetPrintOptions | Contains options used for printing a chart sheet. |
ChartSheetView | Contains display and print settings for a chart sheet. |
CheckBoxFormControl | A check box form control. |
ColorScale2ConditionalFormatting | Represents a two-color scale conditional formatting rule. |
ColorScale3ConditionalFormatting | Represents a three-color scale conditional formatting rule. |
Column | A single column in a worksheet. |
ColumnCollection | A collection of all columns in a worksheet. |
ComboBoxFormControl | A combo box form control. |
Comment | A simple note (legacy comment) added to a cell. |
CommentCollection | A collection of simple notes (legacy comments) contained in a worksheet. |
CommentRun | A note text region with its own set of font characteristics. |
CommentRunCollection | A collection of note text regions, each formatted with its own font. |
ConditionalFormatting | A conditional format applied to a range of cells. |
ConditionalFormattingCollection | A collection of all conditional formatting rules on a worksheet. |
ConditionalFormattingExtremumValue | Obsolete. Represents a minimum or maximum threshold for a conditional formatting rule. |
ConditionalFormattingIconSetInsideValue | Obsolete. Represents a threshold value for an icon set conditional formatting rule. |
ConditionalFormattingIconSetValue | Represents a threshold value for an icon set conditional formatting rule. |
ConditionalFormattingInsideValue | Obsolete. Represents a threshold value for a conditional formatting rule. |
ConditionalFormattingValue | Represents a minimum or maximum threshold for a conditional formatting rule. |
ConnectorFormat | Contains connector settings. |
CustomCellInplaceEditor | Represents a custom cell in-place editor assigned to a cell or cell range in a worksheet. |
CustomCellInplaceEditorCollection | Represents a collection of the custom cell in-place editors assigned to worksheet cells. |
CustomFilter | Contains the settings of a custom filter. |
CustomXmlPartCollection | A collection of custom XML parts in a workbook. |
DataBarConditionalFormatting | Represents a data bar conditional formatting rule. |
DataSelectorFormControl | Exposes members for form controls used to select data: list box and combo box. |
DataValidation | Provides access to a data validation rule defined for a worksheet range. |
DataValidationCollection | A collection of DataValidation objects. |
DefinedName | A defined name that refers to a cell, range of cells, formula or constant value. |
DefinedNameCollection | A collection of defined names stored in a worksheet or workbook. |
DocumentCustomProperties | Contains custom document properties associated with a workbook. |
DocumentProperties | Contains basic document properties associated with a workbook. |
DocumentSettings | Contains workbook options related to formula calculation. |
DynamicArrayFormula | Contains a dynamic array formula and the range to which the formula is applied. |
DynamicArrayFormulaCollection | A collection of dynamic array formulas. |
EncryptionOptions | Contains the workbook encryption options. |
ErrorValueInfo | Contains information about an error that occurred in a cell. |
ExpressionConditionalFormatting | Represents a conditional formatting rule that uses a relational operator to determine which cells to format. |
ExternalDefinedName | A defined name that is contained in the external workbook or in the external worksheet. |
ExternalWorkbook | An external workbook. |
ExternalWorkbookCollection | A collection of external workbooks. |
ExternalWorksheet | A worksheet contained in an external workbook. |
Fill | Contains the cell background attributes. |
FilterCriteria | Provides information on multiple values and groups of dates by which to filter. |
FloatingObject | A base interface for floating objects in a worksheet (pictures, charts and comments). |
Formatting | Provides access to cell format characteristics. |
FormControl | Exposes basic members for all form control types. |
FormControlCollection | A collection of form controls. |
FormulaExpressionConditionalFormatting | Represents a conditional formatting rule that uses a formula as a formatting criteria. |
GradientFill | Contains characteristics required to create a gradient fill. |
GradientStop | A color stop that constitutes a gradient fill. |
GradientStopCollection | A collection of color stops which constitutes a linear gradient. |
GroupBoxFormControl | Group box form control. |
HeaderFooterPicture | A picture embedded in a worksheet header or footer. |
Hyperlink | A hyperlink contained in a cell or cell range. |
HyperlinkBase | Serves as the base for the Hyperlink and ShapeHyperlink interfaces that define hyperlinks for cells and shapes. |
HyperlinkCollection | A collection of hyperlinks contained in worksheet cells. |
IBindingRangeValueConverter | An interface that allows you to convert cell values to custom objects and back. |
ICellValueConverter | A converter that converts custom objects to cell values and vice versa. |
IClipboardManager | Allows you to write data to the system clipboard. |
IconSetConditionalFormatting | Represents an icon set conditional formatting rule. |
ICustomXmlPart | A custom XML part embedded in a workbook. |
IDataSourceColumnTypeDetector | Provides the capability to identify the name and type of each column in a data source created from a cell range. |
IDataValueConverter | An interface that allows you to modify data being imported before insertion in a worksheet. |
IgnoredError | Specifies a worksheet range and a type of the formula error which will be ignored in that range. |
IgnoredErrorCollection | A collection of IgnoredError objects. |
ImageInfo | Exposes members used to specify information about an image placed in a cell. |
IRangeProvider | Provides properties and methods to get cell ranges. |
ISpreadsheetComponent | Exposes the basic functionality to manage workbooks. |
ISupportsFormatting | Contains format characteristics that are applied to cells when the condition of the conditional formatting rule is true. |
IUsedNameSet | A set of table and defined names existing in the destination document into which a formula or worksheet containing a conflict name is pasted. |
IWorkbook | A workbook loaded into the Spreadsheet control (for WinForms, WPF, and ASP.NET). |
IWorkbookMergeResult | Obsolete. Contains a result of merging multiple workbooks. |
LabelFormControl | Label form control. |
LinkedCellFormControl | Exposes members for form controls that can be linked to a cell: combo box, list box, checkbox, radio button, scroll bar, and spinner. |
ListBoxFormControl | List box form control. |
Margins | Provides access to page margins used when a worksheet is printed. |
PageBreaksCollection | A collection of page breaks in a worksheet. |
Parameter | A single query parameter. |
ParametersCollection | A collection of parameters for queries used in Mail Merge. |
Picture | An image embedded in a worksheet. |
PictureCollection | A collection of Picture objects. |
PivotBehaviorOptions | Contains options that allow you to restrict specific operations in the PivotTable report. |
PivotCache | Represents the data cache for a PivotTable report. |
PivotCacheCollection | Represents the collection of data caches from the PivotTable reports in a workbook. |
PivotCalculatedFieldCollection | A collection of calculated fields in a PivotTable report. |
PivotCalculatedItemCollection | Represents a collection of calculated items in a PivotTable field. |
PivotDataField | Represents a reference to a PivotField object that is currently shown as a data field. |
PivotDataFieldCollection | Represents a collection of fields located in the data area of a PivotTable report. |
PivotField | Represents a field in a PivotTable report. |
PivotFieldBehaviorOptions | Contains options that allow you to restrict an end-user’s ability to move or remove a PivotTable field. |
PivotFieldCollection | Represents the collection of all fields in a PivotTable report. |
PivotFieldGroupingInfo | Provides access to range grouping characteristics. |
PivotFieldLayout | Contains layout settings for a PivotTable field. |
PivotFieldReference | Represents a reference to a PivotField object that is currently shown as a row or column field. |
PivotFieldReferenceBase | Represents a base interface for the PivotFieldReference, PivotPageField and PivotDataField interfaces. |
PivotFieldReferenceCollection | Represents the collection of row or column fields in the PivotTable report. |
PivotFieldSortOptions | Contains sort options for a PivotTable field. |
PivotFilter | Represents a filter applied to a PivotTable field. |
PivotFilterCollection | A collection of filters applied to the PivotTable fields. |
PivotItem | Represents an item in a PivotTable field. |
PivotItemCollection | Represents a collection of PivotItem objects in a PivotTable field. |
PivotLayout | Contains various options used to adjust the layout of the PivotTable report. |
PivotLocation | Contains information about the location of a pivot table and its areas. |
PivotPageField | Represents a reference to a PivotField object that is currently shown as a page field. |
PivotPageFieldCollection | Represents a collection of fields located in the report filter area of a pivot table. |
PivotTable | Represents a PivotTable report on a worksheet. |
PivotTableCollection | A collection of all PivotTable objects in the worksheet. |
PivotViewOptions | Contains display settings for a pivot table. |
ProtectedRange | An association of a worksheet range and credentials required to unlock it for editing. |
ProtectedRangeCollection | A collection of items which associate worksheet ranges and security information required to unlock them for editing. |
Protection | Contains various options in effect when the worksheet is protected. |
RadioButtonFormControl | Radio button form control. |
RangeConditionalFormatting | Represents a conditional formatting rule that formats cells which are between or not between two values. |
RangeFormControl | The base interface for form controls that use a value range: spinner and scroll bar. |
RankConditionalFormatting | Represents a "top/bottom N" conditional formatting rule. |
ReadOnlyDocumentCustomProperties | Stores custom document properties associated with a workbook. |
ReadOnlyDocumentProperties | Stores document properties retrieved from a workbook by the Workbook.LoadDocumentProperties method. |
RealTimeData | Defines a real-time data object for use with the Real Time Data (RTD) function. |
RepliedThreadedComment | A comment reply. |
RepliedThreadedCommentCollection | A collection of comment replies. |
RichTextRange | A range of characters within a cell’s rich text. |
RichTextRun | A region of the cell text with its own set of font characteristics. |
Row | A row in a worksheet. |
RowCollection | A collection of all rows in a worksheet. |
ScrollbarFormControl | Scrollbar form control. |
ShadedFormControl | Exposes members for shaded form controls: spinner, scrollbar, radio button, list box, group box, combo box, and checkbox. |
Shape | A common interface for drawing objects in a worksheet. |
ShapeCollection | A collection of drawing objects (shapes, pictures, and charts). |
ShapeFormatBase | Contains properties used to format drawing objects (shapes, pictures, and charts). |
ShapeGeometry | Contains the shape geometry information. |
ShapeHyperlink | A hyperlink associated with a drawing object. |
ShapeText | Provides access to a shape’s text format settings. |
ShapeTextParagraphFormat | Contains paragraph settings for a shape text range. |
ShapeTextRange | Represents a text range within a shape. |
Sheet | An individual sheet in a workbook and a base interface for Worksheet and ChartSheet. |
SheetAutoFilter | An object implementing the filtering functionality for the specified worksheet. |
SheetCollection | A collection of all sheets (worksheets and chart sheets) contained in a workbook. |
SheetView | Contains display and print settings for a sheet. |
SortState | Contains sort conditions and allows you to perform sorting. |
Sparkline | Represents a single sparkline in the sparkline group. |
SparklineCollection | A collection that stores the Sparkline objects for the specified sparkline group. |
SparklineColor | Contains display options for the horizontal axis and data markers of a sparkline group. |
SparklineGroup | Represents a sparkline group on a worksheet. |
SparklineGroupCollection | A collection of the SparklineGroup objects in a worksheet. |
SparklineHorizontalAxis | Contains settings for the horizontal axis of a sparkline group. |
SparklinePoints | Contains marker options for data points on the sparklines in a sparkline group. |
SparklineVerticalAxis | Contains scaling options for the vertical axis of a sparkline group. |
SpecialConditionalFormatting | Represents a conditional formatting rule that formats cells with specific values. |
SpinnerFormControl | Spinner form control. |
SpreadsheetFont | Contains the cell font attributes. |
SpreadsheetFontProperties | Contains font attributes for a range of characters within the cell text. |
SpreadsheetHistory | A history of operations performed in a workbook. |
SpreadsheetMailMergeOptions | Contains the mail merge options. |
Style | A named cell style. |
StyleCollection | A collection of cell styles in the workbook. |
StyleFlags | A style flag that controls formatting options to be applied. |
Table | A table in a worksheet. |
TableAutoFilter | An object implementing the filtering functionality for the specified table. |
TableCollection | A collection of tables contained in a worksheet. |
TableColumn | A single column in a table. |
TableColumnCollection | A collection of columns in a table. |
TableStyle | A named table or pivot table style. |
TableStyleCollection | A collection of table and PivotTable styles in a workbook. |
TableStyleElement | A table style element. |
TableStyleElements | A collection of table style elements. |
TextConditionalFormatting | Represents a conditional formatting rule that formats cells that contain or do not contain the given text. |
TextFormControl | Exposes members for form controls that contain text: button, check box, group box, label, and radio button. |
ThreadedComment | A threaded comment. |
ThreadedCommentAuthor | Contains information about the author of the comment. |
ThreadedCommentCollection | A collection of threaded comments. |
TimePeriodConditionalFormatting | Represents a "date occurring…" conditional formatting rule. |
WorkbookColorPalette | A color palette for a workbook. |
WorkbookTheme | A document theme. |
Worksheet | A worksheet in a workbook. |
WorksheetCollection | A collection of worksheets in a workbook. |
WorksheetDataBinding | Contains information about a cell range bound to an external data source or used to create a data source. |
WorksheetDataBindingCollection | A collection of data bindings specified in a worksheet. |
WorksheetHeaderFooter | A worksheet header or footer. |
WorksheetHeaderFooterOptions | Allows you to specify headers and footers for a worksheet or chart sheet. |
WorksheetOutlineOptions | Contains options used to specify the summary rows and columns location. |
WorksheetPageNumbering | Contains options that affect page numbering when printing worksheets in a workbook. |
WorksheetPrintOptions | Contains options used for printing a worksheet. |
WorksheetPrintTitleOptions | Represents the object that specifies rows and columns to be repeated on every printed page. |
WorksheetTableDataBinding | Contains information about a Table bound to an external data source or used to create a data source. |
WorksheetView | Contains display and print settings for a worksheet. |
WriteProtectionOptions | Contains write-protection options for a workbook. |
Structs
Name | Description |
---|---|
CellKey | A cell’s unique identifier within a workbook. |
ConditionalFormattingCustomIcon | Provides access to the particular icon in the icon set. |
DocumentFormat | A document format. |
Delegates
Name | Description |
---|---|
ActiveSheetChangedEventHandler | A method that will handle the SpreadsheetControl.ActiveSheetChanged event. |
ActiveSheetChangingEventHandler | A method that will handle the SpreadsheetControl.ActiveSheetChanging event. |
BeforeExportEventHandler | A method that will handle the ISpreadsheetComponent.BeforeExport event. |
BeforeImportEventHandler | A method that will handle the ISpreadsheetComponent.BeforeImport event. |
BeforePrintSheetEventHandler | A method that will handle the BeforePrintSheet event of the SpreadsheetControl. |
ClipboardDataObtainedEventHandler | A method that will handle the ISpreadsheetComponent.ClipboardDataObtained event. |
ClipboardDataPastedEventHandler | A method that will handle the SpreadsheetControl.ClipboardDataPasted event of the SpreadsheetControl. |
ClipboardDataPastingEventHandler | A method that will handle the ISpreadsheetComponent.ClipboardDataPasting event. |
ColumnsInsertedEventHandler | A method that will handle the SpreadsheetControl.ColumnsInserted event. |
ColumnsRemovedEventHandler | A method that will handle the SpreadsheetControl.ColumnsRemoved event. |
ColumnWidthChangedEventHandler | A method that handles the SpreadsheetControl.ColumnWidthChanged event. |
CommentChangedEventHandler | A method that will handle the SpreadsheetControl.CommentInserted, SpreadsheetControl.CommentInserted, SpreadsheetControl.CommentRemoved and SpreadsheetControl.CommentRemoved events. |
CommentInsertingEventHandler | A method that will handle the SpreadsheetControl.CommentInserting and SpreadsheetControl.CommentInserting events. |
CommentRemovingEventHandler | A method that will handle the SpreadsheetControl.CommentRemoving and SpreadsheetControl.CommentRemoving events. |
CopiedRangePastedEventHandler | A method that will handle the ISpreadsheetComponent.CopiedRangePasted event. |
CopiedRangePastingEventHandler | A method that will handle the ISpreadsheetComponent.CopiedRangePasting event. |
DataBindingErrorEventHandler | A method that will handle the WorksheetDataBindingCollection.Error event. |
DefinedNameConflictResolvingEventHandler | A method that will handle the DefinedNameConflictResolving event of the SpreadsheetControl. |
EncryptedFileIntegrityCheckFailedEventHandler | A method that will handle the EncryptedFileIntegrityCheckFailed event of the SpreadsheetControl. |
EncryptedFilePasswordCheckFailedEventHandler | Represents a method that will handle the EncryptedFilePasswordCheckFailed event. |
EncryptedFilePasswordRequestEventHandler | A method that will handle the EncryptedFilePasswordRequest event of the SpreadsheetControl. |
InvalidFormatExceptionEventHandler | A method that will handle the InvalidFormatException event of the SpreadsheetControl. |
PanesFrozenEventHandler | A method that will handle the SpreadsheetControl.PanesFrozen event. |
PanesUnfrozenEventHandler | A method that will handle the SpreadsheetControl.PanesUnfrozen event. |
RangeCopiedEventHandler | A method that will handle the ISpreadsheetComponent.RangeCopied event. |
RangeCopyingEventHandler | A method that will handle the ISpreadsheetComponent.RangeCopying event. |
RowHeightChangedEventHandler | A method that handles the SpreadsheetControl.RowHeightChanged event. |
RowsInsertedEventHandler | A method that will handle the RowsInserted event of the SpreadsheetControl. |
RowsRemovedEventHandler | A method that will handle the RowsRemoved event of the SpreadsheetControl. |
ShapesCopyingEventHandler | A method that will handle the ISpreadsheetComponent.ShapesCopying event. |
SheetInsertedEventHandler | A method that will handle the SheetInserted event of the SpreadsheetControl. |
SheetRemovedEventHandler | A method that will handle the SheetRemoved event of the SpreadsheetControl. |
SheetRemovingEventHandler | A method that will handle the SheetRemoving event of the SpreadsheetControl. |
SheetRenamedEventHandler | A method that will handle the SheetRenamed event of the SpreadsheetControl. |
SheetRenamingEventHandler | A method that will handle the SheetRenaming event of the SpreadsheetControl. |
SpreadsheetCustomAssemblyLoadingEventHandler | A method that will handle the SpreadsheetControl.CustomAssemblyLoading event of the SpreadsheetControl. |
SpreadsheetValidateCustomSqlQueryEventHandler | A method that will handle the SpreadsheetControl.ValidateCustomSqlQuery event. |
Enums
Name | Description |
---|---|
ArrowheadSize | Lists values used to specify an arrowhead’s width and length. |
ArrowheadType | Lists values that specify the type of a connector’s arrowhead. |
BorderLineStyle | Lists line styles for cell borders. |
BuiltInStyleId | Lists built-in cell styles. |
BuiltInTableStyleId | Lists built-in styles similar to Excel’s built-in table styles. |
CalculationEngineType | Lists types of computational models used for spreadsheet calculations. |
CalculationMode | Lists modes that specify when to calculate formulas in the document. |
CellValueType | Lists the data types of cell values. |
ChartSheetProtection | Lists values used to specify chart sheet elements to which protection is applied. |
ColumnFormatMode | Lists values that specify how to format inserted columns. |
CommentsPrintMode | Lists the values to specify how cell comments are printed. |
ConditionalFormattingAverageCondition | Lists values that specify the type of the conditional format operator in an "above or below average" conditional formatting rule. |
ConditionalFormattingDataBarAxisPosition | Lists values that specify the axis position between negative and positive bars when the data bar conditional format is applied. |
ConditionalFormattingDataBarDirection | Lists values that specify the direction of data bars when the data bar conditional format is applied. |
ConditionalFormattingExpressionCondition | Lists values that specify the type of the relational operator in a conditional formatting rule. |
ConditionalFormattingRangeCondition | Lists values that specify the type of the conditional format operator in a conditional formatting rule. |
ConditionalFormattingRankCondition | Lists values that specify the type of the conditional format operator in a "top/bottom N" conditional formatting rule. |
ConditionalFormattingSpecialCondition | Lists values that specify the type of the conditional format operator in a conditional formatting rule. |
ConditionalFormattingTextCondition | Lists values that specify the type of the conditional format operator in a conditional formatting rule. |
ConditionalFormattingTimePeriod | Lists applicable time periods in a "date occurring…" conditional formatting rule. |
ConditionalFormattingValueOperator | Lists values that specify the relational operator type for the icon set conditional format. |
ConditionalFormattingValueType | Lists values that specify the type of the threshold value to be used in conditional formatting rules. |
ConnectorType | Lists connector types. |
CustomCellInplaceEditorType | Lists types of the custom in-place editors that can be assigned to cells in a worksheet. |
DataBindingDirection | Indicates whose value is being updated during binding. |
DataBindingErrorType | Lists possible error causes relevant to cell range data binding. |
DataSourceEditingOptions | Lists the editing options which can be applied to the data source originated from cell range. |
DataValidationErrorStyle | Lists the styles of data validation error alert. |
DataValidationImeMode | Lists values that specify how the IME (input method editor) mode is controlled by data validation. |
DataValidationOperator | Lists comparison operators used in criteria for certain validation types. |
DataValidationType | Lists data validation types. |
DateTimeGroupingType | Lists grouping types used to specify filter criteria for DateTime values. |
DefinedNameScope | Lists values used to specify the defined name scope. |
DeleteMode | Specifies how to delete cells from a worksheet. |
DiagonalBorderType | Lists the types of cell diagonal borders. |
DocumentSecurity | Lists the security levels of the document. |
DynamicFilterType | Lists the types of dynamic filter, i.e. a filter whose results may depend on the data to which it is applied or the current date. |
EncryptionType | Lists available encryption types for a workbook. |
ErrorsPrintMode | Lists the values to specify how cell errors are printed. |
ErrorType | Lists errors that can occur in cells. |
FillType | Lists fill types. |
FilterComparisonOperator | Lists comparison operators used in a custom filter. |
FilterType | Lists types of filters available for the AutoFilter functionality. |
FontSchemeStyles | Lists values used to specify the font scheme. |
FormControlCheckState | Indicates available states for the checkbox form control. |
FormControlOrientation | Indicates the scrollbar form control orientation. |
FormControlSelectionMode | Lists values that indicate selection modes available for the list box form control. |
FormControlType | Indicates the form control type. |
FormulaReplacementMode | Specifies how to replace copied formulas if they contain references to worksheets that do not exist in the destination workbook. |
GradientFillType | Lists the types of gradient fill. |
HeaderFooterSection | Lists document header and footer sections. |
IconSetType | Lists values that specify the icon set type for an icon set conditional format. |
IgnoredErrorType | Lists types of errors that can occur in cell formulas. Use the Worksheet.IgnoredErrors property to ignore these errors. |
ImageFileFormat | Lists image formats you can use to save a cell range as an image. |
ImageReplacementMode | Specifies how to insert a new image when you replace an existing worksheet image with a different image. |
InsertCellsMode | Specifies how to insert new cells into a worksheet. |
MergeCellsMode | Lists available modes to merge cells. |
PageOrder | Contains the values to specify the order in which worksheet pages are numbered and printed when the worksheet data does not fit onto one page. |
PageOrientation | Lists values used to specify the page orientation applied when a worksheet is being printed. |
PasteSpecial | Specifies the part of data to paste from copied cells into target cells. |
PatternType | Lists patterns to apply to a cell. |
PivotAxisType | Lists values used to specify areas in the PivotTable report to which a PivotField may belong. |
PivotBaseItemType | Lists types of base items that can be used by the “Show Values As” calculation options. |
PivotCacheType | Lists values that specify the cache type of the PivotTable report. |
PivotDataConsolidationFunction | Lists aggregation functions to apply to data fields in a PivotTable report. |
PivotFieldGroupByType | Lists values that specify how items of a row or column field are grouped. |
PivotFieldSortType | Lists values that specify the sort order for a PivotTable field. |
PivotFilterTop10Type | Lists values used to specify what items should be included in the “Top 10” filtering results. |
PivotFilterType | Lists values that specify the type of filter to be applied to a PivotTable field. |
PivotPageOrder | Lists values used to specify the orientation of multiple page fields in the PivotTable report filter area. |
PivotReportLayout | Lists values used to specify the type of the PivotTable report layout. |
PivotShowValuesAsType | Lists options that specify how summary values are displayed within a data field. |
PivotSubtotalFunctions | Lists functions used to calculate subtotals for the PivotTable fields. |
PivotSubtotalType | Lists values that specify how subtotals are calculated for a PivotTable field. |
Placement | Lists the ways the object is attached to the cells below it. |
ReferenceElement | Contains values to specify the type of a cell reference to be obtained. |
ReferenceStyle | Specifies the cell reference style. |
RowFormatMode | Lists values that specify how to format inserted rows. |
ScriptType | Contains the values used to make the text in a cell superscript or subscript. |
SearchBy | Lists values that specify the direction of the search. |
SearchIn | Lists values that specify what to examine in each cell while searching. |
ShapeGeometryPreset | Lists values that specify the shape geometry type. |
ShapeTextAutoSizeType | Lists values used to specify the auto-size mode for shape text. |
ShapeTextHorizontalAnchorType | Lists values used to specify the shape text’s horizontal alignment. |
ShapeTextHorizontalOverflowType | Lists values used to specify how to display text that overflows the shape horizontally. |
ShapeTextOrientationType | Lists values used to specify the type of a shape text’s orientation. |
ShapeTextParagraphAlignment | Lists values used to specify the paragraph alignment for a shape text range. |
ShapeTextReadingOrderType | Lists values used to specify the reading order of a shape’s text. |
ShapeTextVerticalAnchorType | Lists values used to specify the shape text’s vertical alignment. |
ShapeTextVerticalOverflowType | Lists values used to specify how to display text that overflows the shape vertically. |
ShapeTextWarpFormat | Lists warp types for shape text. |
ShapeType | Lists types of graphical objects a worksheet can contain. |
SheetType | Lists values used to specify the sheet type. |
SortBy | Lists values used to indicate the sort type. |
SparklineAxisScaling | Lists values used to specify how to calculate the minimum and maximum values for the vertical axis of a sparkline group. |
SparklineGroupType | Lists sparkline group types. |
SpreadsheetFontStyle | Lists the cell font styles. |
SpreadsheetHorizontalAlignment | Specifies horizontal alignment of cell content. |
SpreadsheetVerticalAlignment | Lists the values used to specify vertical alignment of data within a cell. |
TableStyleElementType | Lists table and pivot table style elements. |
ThemePreset | Lists predefined document themes for a workbook. |
Top10Type | Lists criteria types used in the top ten filter. |
TotalRowFunction | Lists functions to calculate the totals of table columns. |
UnderlineType | Lists underline styles. |
UpdateLinksMode | Specifies how to update external links to other workbooks when a document is opened. |
WorkbookCalculationMode | Lists values used to specify when data should be recalculated in a non-visual Workbook or the Spreadsheet control. |
WorksheetPageNumberingStartType | Lists possible options for the starting number used in pagination when printing worksheets in a workbook. |
WorksheetProtectionPermissions | Lists end-user actions allowed for the protected worksheet. |
WorksheetViewType | Lists view types that can be used to display worksheets. |
WorksheetVisibilityType | Contains the values that specify worksheet visibility. |
WorksheetZoomMode | Lists values used to specify a zoom mode for a worksheet. |