Class | Description | |
---|---|---|
ArrayHelper | The class intend not to be used directly in user code. | |
Authors | Represents a list of authors. | |
AutoFilter | Represents autofiltering for the specified worksheet. | |
BuiltInCfRule | Represents a built-in conditional formatting rule. | |
BuiltInDataValidation | ||
BuiltInNumberFormats | Represents all built-in number formats. | |
CalculationEngine | Represents a class which store, evaluate or adjust expressions. Represents util functions for calculation. | |
CellImageAttribute | Represents an attributes that allow to specify the cell inline image data. | |
CellMatrix<T> | This class implements the function to store values in the locations of a sparse matrix. | |
CellRangeDataSource | Represents the data source which binds to the specified cell range via a reference or a defined name. | |
CellValueChangedEventArgs | Represents a class which stores cell calculated information. | |
CfRule | ||
ClassicCfRule | Represents a classic conditional formatting rule. | |
Collection<T> | Represents a strongly typed list of objects that can be accessed by index. | |
ColorFilter | This element specifies the color to filter by and whether to use the cell's fill or font color in the filter criteria. If the cell's font or fill color does not match the color specified in the criteria, the rows corresponding to those cells are hidden from view. | |
ColorManager | Represents the color manager of the IWorkbookSet object. | |
ColorResolver | ||
ColorScaleCfRule | ||
ColorStop | Represents the color stop point for a gradient fill in a range or selection. | |
Comment | ||
CommentBase | ||
CompatibleFeatures | ||
ConditionalFormatting | Represents a conditional formatting which apply a set of rules to a set of range references. | |
ConfirmationEventArgs | Represents the event argument for confirming user's option. | |
CustomFilter | When there is more than one custom filter criteria to apply (an 'and' or 'or' joining two criteria), then this element groups the customFilter elements together | |
DatabarCfRule | Represents the data bar conditional formatting rule. | |
DataValidation | Represent for the data valiation information. | |
DataValidations | Represents the data validations associated with the specified Worksheet. | |
DataValidationSuggestionList | ||
DataValidator | ||
DefinedName | Represents a defined name. | |
DifferentialFormat | ||
DisplayFormat | Represents the display settings for an associated Range object. | |
DocumentProperties | Represents all properties of the spreadsheet document. | |
DynamicFilter | This collection specifies dynamic filter criteria. These criteria are considered dynamic because they can change, either with the data itself (e.g., "above average") or with the current system date (e.g., show values for "today"). For any cells whose values do not meet the specified criteria, the corresponding rows shall be hidden from view when the filter is applied. | |
ExpressionView | Represents a view of cell range in worksheet which all cell values are calculated by a specified formula. | |
ExpressionViewCell | Represents a cell in the ExpressionView. | |
ExternalVariable | Represents a external variable. | |
Factory | Represents a spreadsheet factory for customizable types. | |
Features | Represents all customizable features of Spread. | |
Filter | Represents the base class for filter. | |
FormatConditionalHelper | ||
FormatConditions | Represents the conditional formats associated with the specified Worksheet. | |
Hyperlink | Represents a hyperlink. | |
IconFilter | This element specifies the icon set and particular icon within that set to filter by. For any cells whose icon does not match the specified criteria, the corresponding rows shall be hidden from view when the filter is applied. | |
IconSetCfRule | Class IconSetConditionalFormattingRule. This class cannot be inherited. | |
IndexBitmap | Represents the roaring bitmap data structure. | |
IntervalArray<T> | Represents an one dimension array data structure which is stored as intervals. | |
IntervalBitmap | Represents an one dimension array data structure which is stored as intervals. | |
LayoutManager | Represents the layout manager. | |
MultiValuesFilter | When multiple values are chosen to filter by, or when a group of date values are chosen to filter by, this element groups those criteria together. | |
NamedObjectCollection<TItem,TContainer> | Represents a strongly typed list of objects that can be accessed by index or string key. | |
Outline | ||
PageBreaks | Represents page break information used for print layout view, page layout view, drawing print breaks in normal view, and for printing the worksheet. | |
RichText | Represents the rich text. | |
Sort | Represents a sort of a range of data. | |
SortField | ||
Sparkline | Represents a sparkline. | |
SparklineDataSource | Represents the data source of a sparkline. | |
SparklineGroup | Represents a group of sparklines. | |
SparklineSetting | Represents settings for sparklines. | |
SparklineStorage | Represents the sparkline storage | |
SpreadsheetHelper | The class intend not to be used directly in user code. | |
Styles | Represents a collection of all styles in the workbook. | |
SubWorksheet | ||
Table | Represents a table of the worksheet. | |
Tables | Represents a Tables which manages all Table tables in the specified Worksheet. | |
TableStyle | Represents a single style that can be applied to a table. | |
ThreadedComment | ||
Top10Filter | This element specifies the top N (percent or number of items) to filter by. | |
Utils | Internal use only. | |
Workbook | Represents a workbook. | |
WorkbookBase | Represents a workbook base. | |
WorkbookSet | Represents a set of workbooks which may refer to each other by external cell references or external defined name references. | |
Worksheet | Represents a worksheet. | |
WorksheetBase | Represents a worksheet base. | |
WorksheetFunction | Represents the container for worksheet functions that can be called from application. | |
WorksheetOptions | Represents all options of the IWorksheet object. | |
WorksheetView | Represents a worksheet view. |