Aspose.Cells Namespace |
Class | Description | |
---|---|---|
![]() | AboveAverage |
Describe the AboveAverage conditional formatting rule.
This conditional formatting rule highlights cells that
are above or below the average for all values in the range.
|
![]() ![]() | AbstractCalculationEngine |
Represents user's custom calculation engine to extend the default calculation engine of Aspose.Cells.
|
![]() ![]() | AbstractCalculationMonitor |
Monitor for user to track the progress of formula calculation.
|
![]() | AbstractTextLoadOptions |
Common options for loading text values
|
![]() ![]() | AutoFilter |
Represents autofiltering for the specified worksheet.
|
![]() | AutoFitterOptions |
Represents all auto fitter options.
|
![]() ![]() | Border |
Encapsulates the object that represents the cell border.
|
![]() ![]() | BorderCollection |
Encapsulates a collection of Border objects.
|
![]() | CalculationCell |
Represents the calculation relevant data about one cell which is being calculated.
|
![]() | CalculationData |
Represents the required data when calculating one function, such as function name, parameters, ...etc.
|
![]() | CalculationOptions |
Represents options for calculation.
|
![]() ![]() | Cell |
Encapsulates the object that represents a single Workbook cell.
|
![]() ![]() | Cells | |
![]() | CellsColor |
Represents all types of color.
|
![]() | CellsException |
The exception that is thrown when Aspose.Cells specified error occurs.
|
![]() | CellsFactory |
Utility for instantiating classes of Cells model.
|
![]() | CellsHelper |
Provides helper functions.
|
![]() | CellWatch |
Represents Cell Watch Item in the 'watch window'.
|
![]() | CellWatchCollection |
Represents the collection of cells on this worksheet being watched in the 'watch window'.
|
![]() | ColorFilter |
Represents the color filter.
|
![]() | ColorScale |
Describe the ColorScale conditional formatting rule.
This conditional formatting rule creates a gradated color scale on the cells.
|
![]() ![]() | Column |
Represents a single column in a worksheet.
|
![]() ![]() | ColumnCollection |
Collects the objects that represent the individual columns in a worksheet.
|
![]() ![]() | Comment |
Encapsulates the object that represents a cell comment.
|
![]() ![]() | CommentCollection |
Encapsulates a collection of Comment objects.
|
![]() ![]() | ConditionalFormattingCollection |
Encapsulates a collection of FormatCondition objects.
|
![]() | ConditionalFormattingIcon |
Represents the custom icon of conditional formatting rule.
|
![]() ![]() | ConditionalFormattingIconCollection |
Represents a collection of ConditionalFormattingIcon objects.
|
![]() | ConditionalFormattingResult |
Represents the result of conditional formatting which applies to a cell.
|
![]() | ConditionalFormattingValue |
Describes the values of the interpolation points in a gradient scale, dataBar or iconSet.
|
![]() | ConditionalFormattingValueCollection |
Describes a collection of CFValueObject.
Use only for icon sets.
|
![]() | CopyOptions |
Represents the copy options.
|
![]() | CustomFilter |
Represents the custom filter.
|
![]() | CustomFilterCollection |
Represents the custom filters.
|
![]() | CustomImplementationFactory |
Factory to create some instances which may be re-implemented by user for special purpose.
|
![]() ![]() | DataBar |
Describe the DataBar conditional formatting rule.
This conditional formatting rule displays a gradated
data bar in the range of cells.
|
![]() | DataBarBorder |
Represents the border of the data bars specified by a conditional formatting rule.
|
![]() ![]() | DataSorter |
Summary description for DataSorter.
|
![]() | DataSorterKey |
Represents the key of the data sorter.
|
![]() | DataSorterKeyCollection |
Represents the key list of data sorter.
|
![]() | DateTimeGroupItem |
Represents the datetime's group setting.
|
![]() | DeleteOptions |
Represents the setting of deleting rows/columns.
|
![]() | DifSaveOptions |
Represents the options of saving dif file.
|
![]() | DocxSaveOptions |
Represents options of saving docx file.
|
![]() | DxfCollection |
Represents the master differential formatting records.
|
![]() | DynamicFilter |
Represents the dynamic filter.
|
![]() ![]() | ErrorCheckOption |
Error check setting applied on certain ranges.
|
![]() | ErrorCheckOptionCollection |
Represents all error check option.
|
![]() | ExportObjectEvent |
The event triggered when exporting an object, such as Picture.
|
![]() | ExportTableOptions |
Represents all export table options.
|
![]() ![]() | ExternalLink |
Represents an external link in a workbook.
|
![]() ![]() | ExternalLinkCollection |
Represents external links collection in a workbook.
|
![]() | FileFontSource |
Represents the single TrueType font file stored in the file system.
|
![]() | FileFormatInfo |
Contains data returned by FileFormatUtil file format detection methods.
|
![]() | FileFormatUtil |
Provides utility methods for converting file format enums to strings or file extensions and back.
|
![]() | FilterColumn |
Represents a filter for a single column. The Filter object is a member of the Filters collection
|
![]() | FilterColumnCollection |
A collection of Filter objects that represents all the filters in an autofiltered range.
|
![]() ![]() | FindOptions |
Represents find options.
|
![]() | FolderFontSource |
Represents the folder that contains TrueType font files.
|
![]() ![]() | Font |
Encapsulates the font object used in a spreadsheet.
|
![]() | FontConfigs |
Specifies font settings
|
![]() ![]() | FontSetting |
Represents a range of characters within the cell text.
|
![]() | FontSourceBase |
This is an abstract base class for the classes that allow the user to specify various font sources
|
![]() ![]() | FormatCondition |
Represents conditional formatting condition.
|
![]() ![]() | FormatConditionCollection |
Represents conditional formatting.
The FormatConditions can contain up to three conditional formats.
|
![]() | FormulaParseOptions |
Represents options when parsing formula.
|
![]() | GlobalizationSettings |
Represents the globalization settings.
|
![]() | HeaderFooterCommand |
Represents the command of header/footer
|
![]() ![]() | HorizontalPageBreak |
Encapsulates the object that represents a horizontal page break.
|
![]() ![]() | HorizontalPageBreakCollection |
Encapsulates a collection of HorizontalPageBreak objects.
|
![]() | HtmlLoadOptions |
Represents options when importing a html file.
|
![]() | HtmlSaveOptions |
Represents the options for saving html file.
|
![]() ![]() | Hyperlink |
Encapsulates the object that represents a hyperlink.
|
![]() ![]() | HyperlinkCollection |
Encapsulates a collection of Hyperlink objects.
|
![]() | IconFilter |
Represents icon filter.
|
![]() ![]() | IconSet |
Describe the IconSet conditional formatting rule.
This conditional formatting rule applies icons to cells
according to their values.
|
![]() | ImageSaveOptions |
Represents image save options
|
![]() | ImportTableOptions |
Represents the options of importing data into cells.
|
![]() | IndividualFontConfigs |
Font configs for each Workbook object.
|
![]() | InsertOptions |
Represents the options of inserting.
|
![]() | InterruptMonitor |
Represents all operator about the interrupt.
|
![]() ![]() | License |
Provides methods to license the component.
|
![]() ![]() | LoadFilter |
Represents the filter that provides options for loading data when loading workbook from template.
|
![]() | LoadOptions |
Represents the options of loading the file.
|
![]() | MarkdownSaveOptions |
Represents the save options for markdown.
|
![]() | MemoryFontSource |
Represents the single TrueType font file stored in memory.
|
![]() ![]() | Metered |
Provides methods to set metered key.
|
![]() | MultipleFilterCollection |
Represents the multiple filter collection.
|
![]() ![]() | Name |
Represents a defined name for a range of cells.
|
![]() | NameCollection |
Represents a collection of all the Name objects in the spreadsheet.
|
![]() | NegativeBarFormat |
Represents the color settings of the data bars for negative values that are defined by a data bar conditional formatting rule.
|
![]() | OdsLoadOptions |
Represents the options of loading ods file.
|
![]() | OdsSaveOptions |
Represents the options of saving ods file.
|
![]() | OoxmlSaveOptions |
Represents the options of saving office open xml file.
|
![]() | Outline |
Represents an outline on a worksheet.
|
![]() ![]() | PageSetup |
Encapsulates the object that represents the page setup description.
The PageSetup object contains all page setup options.
|
![]() | PaneCollection |
Represents all Pane objects shown in the specified window.
|
![]() | PasteOptions |
Represents the paste special options.
|
![]() | PdfSaveOptions |
Represents the options for saving pdf file.
|
![]() | PptxSaveOptions |
Represents the pptx save options.
|
![]() | ProtectedRange |
A specified range to be allowed to edit when the sheet protection is ON.
|
![]() | ProtectedRangeCollection |
Encapsulates a collection of ProtectedRange objects.
|
![]() ![]() | Protection |
Represents the various types of protection options available for a worksheet.
Only used in ExcelXP and above version.
|
![]() | QueryTable |
Represents QueryTable information.
|
![]() | QueryTableCollection |
A collection of QueryTableCollection objects that represent QueryTable collection information.
|
![]() | Range |
Encapsulates the object that represents a range of cells within a spreadsheet.
|
![]() | RangeCollection |
Encapsulates a collection of Range objects.
|
![]() | ReferredArea |
Represents a referred area by the formula.
|
![]() | ReferredAreaCollection |
Represents all referred cells and areas.
|
![]() | ReplaceOptions |
Represent the replace options.
|
![]() | Row |
Represents a single row in a worksheet.
|
![]() | RowCollection |
Collects the objects that represent the individual rows in a worksheet.
|
![]() | SaveOptions |
Represents all save options
|
![]() | Scenario |
Represents an individual scenario.
|
![]() | ScenarioCollection |
Represents the list of scenarios.
|
![]() | ScenarioInputCell |
Represents input cell for the scenario.
|
![]() | ScenarioInputCellCollection |
Represents the list of the scenario's input cells.
|
![]() | SpreadsheetML2003SaveOptions |
Represents the options for saving Excel 2003 spreadml file.
|
![]() | StreamProviderOptions |
Represents the stream options.
|
![]() ![]() | Style |
Represents display style of excel document,such as font,color,alignment,border,etc.
|
![]() | StyleCollection | Obsolete. |
![]() | StyleFlag |
Represents flags which indicates applied formatting properties.
|
![]() | SubtotalSetting |
Represents the setting of the subtotal .
|
![]() | SvgSaveOptions |
Represents Svg save options
|
![]() ![]() | ThemeColor |
Represents a theme color.
|
![]() | ThreadedComment |
Represents the threaded comment.
|
![]() | ThreadedCommentAuthor |
Represents the person who creates the threaded comments;
|
![]() | ThreadedCommentAuthorCollection |
Represents all persons who .
|
![]() | ThreadedCommentCollection |
Represents the list of threaded comments.
|
![]() | Top10 |
Describe the Top10 conditional formatting rule.
This conditional formatting rule highlights cells whose
values fall in the top N or bottom N bracket, as specified.
|
![]() | Top10Filter |
Represents the top 10 filter.
|
![]() | TxtLoadOptions |
Represents the options for loading text file.
|
![]() | TxtSaveOptions |
Represents the save options for csv/tab delimited/other text format.
|
![]() | UnionRange |
Represents union range.
|
![]() ![]() | Validation |
Represents data validation.settings.
|
![]() | ValidationCollection |
Represents data validation collection.
|
![]() ![]() | VerticalPageBreak |
Encapsulates the object that represents a vertical page break.
|
![]() | VerticalPageBreakCollection |
Encapsulates a collection of VerticalPageBreak objects.
|
![]() | WarningInfo |
Warning info
|
![]() ![]() | Workbook |
Represents a root object to create an Excel spreadsheet.
|
![]() ![]() | WorkbookDesigner |
Encapsulates the object that represents a designer spreadsheet.
|
![]() | WorkbookSettings |
Represents all settings of the workbook.
|
![]() ![]() | Worksheet |
Encapsulates the object that represents a single worksheet.
|
![]() ![]() | WorksheetCollection |
Encapsulates a collection of Worksheet objects.
|
![]() | WriteProtection |
Specifies write protection settings for a workbook.
|
![]() | XlsbSaveOptions |
Represents the options for saving xlsb file.
|
![]() | XlsSaveOptions |
Represents the save options for the Excel 97-2003 file format: xls and xlt.
|
![]() | XmlColumnProperty |
Represents Xml Data Binding information.
|
![]() | XmlDataBinding |
Represents Xml Data Binding information.
|
![]() | XmlMap |
Represents Xml map information.
|
![]() | XmlMapCollection |
A collection of XmlMap objects that represent XmlMap information.
|
![]() | XpsSaveOptions |
Represents the additional options when saving the file as the Xps.
|
Structure | Description | |
---|---|---|
![]() ![]() | CellArea |
Represent an area of cells.
|
Interface | Description | |
---|---|---|
![]() | ICellsDataTable |
Represents data table.
|
![]() | ICustomFunction | Obsolete. |
![]() | ICustomParser |
Allows users to add their custom value parser for parsing string values to other proper cell value object.
|
![]() ![]() | IExportObjectListener |
Allows users to manipulate objects while exporting.
|
![]() | IFilePathProvider |
Represents the exported file path provider.
|
![]() | ISmartMarkerCallBack |
Represents callback interface of processing smartmarker.
|
![]() | IStreamProvider |
Represents the exported stream provider.
|
![]() | IWarningCallback |
Callback interface of warning.
|
![]() | LightCellsDataHandler |
Represents cells data handler for reading large spreadsheet files in light weight mode.
|
![]() | LightCellsDataProvider |
Represents Data provider for saving large spreadsheet files in light weight mode.
|
Enumeration | Description | |
---|---|---|
![]() | AutoFitMergedCellsType |
Represents the type of auto fitting merged cells.
|
![]() | AutoFitWrappedTextType |
Represents the type of auto fitting wrapped text.
|
![]() | BackgroundType |
Enumerates cell background pattern types.
|
![]() | BorderType |
Enumerates the border line and diagonal line types.
|
![]() | BuiltinStyleType |
Represents all built-in style type
|
![]() | CalcModeType |
Represents the mode type of calculating formulas.
|
![]() | CalculationPrecisionStrategy |
Enumerates strategies for handling calculation precision.
Because of the precision issue of IEEE 754 Floating-Point Arithmetic, some "seemingly simple" formulas may not be calculated as the expected result.
Such as formula "=-0.45+0.43+0.02", when calculating operands by '+' operator directly, the result is not zero. For such kind of precision issue,
some special strategies may give the expected result.
|
![]() | CellBorderType |
Enumerates a cell's border type.
|
![]() | CellValueFormatStrategy |
Specifies how to apply style for the value of the cell.
|
![]() | CellValueType |
Specifies a cell value type.
|
![]() | ColorType |
Represents all color type
|
![]() | ConsolidationFunction |
Represents consolidation function.
|
![]() | ContentDisposition |
The content disposition type.
|
![]() | CopyFormatType |
Represents type of copying format when inserting rows.
|
![]() | CountryCode |
Represents Excel country identifiers.
|
![]() | DataBarAxisPosition |
Specifies the axis position for a range of cells with conditional formatting as data bars.
|
![]() | DataBarBorderType |
Specifies the border type of a data bar.
|
![]() | DataBarFillType |
Specifies how a data bar is filled with color.
|
![]() | DataBarNegativeColorType |
Specifies whether to use the same border and fill color as positive data bars.
|
![]() | DateTimeGroupingType |
Specifies how to group dateTime values.
|
![]() | DefaultEditLanguage |
Represents the default edit language.
|
![]() | DirectoryType |
Represents the directory type of the file name.
|
![]() | DisplayDrawingObjects |
Represents whether and how to show objects in the workbook.
|
![]() | DynamicFilterType |
Dynamic filter type.
|
![]() | EmfRenderSetting |
Setting for rendering Emf metafile.
|
![]() | EncryptionType |
Encryption Type.
Only used by excel2003.
We will encrypt 2007/2010 workbook using SHA AES the same as Excel does, and this EncryptionType will be ignored.
|
![]() | ErrorCheckType |
Represents all error check type.
|
![]() | ExceptionType |
Represents custom exception type code.
|
![]() | ExternalLinkType |
Represents the type of external link.
|
![]() | FileFormatType |
Enumerates spreadsheet file format types
|
![]() | FilterOperatorType |
Custom Filter operator type.
|
![]() | FilterType |
The filter type.
|
![]() | FontSchemeType |
Represents the scheme type of the font.
|
![]() | FontSourceType |
Specifies the type of a font source.
|
![]() | FontUnderlineType |
Enumerates the font underline types.
|
![]() | FormatConditionType |
Conditional format rule type.
|
![]() | FormatConditionValueType |
Condition value type.
|
![]() | GridlineType |
Enumerates grid line Type.
|
![]() | HeaderFooterCommandType |
Represents the command type of header and footer.
|
![]() | HtmlCrossType |
Represents five types of html cross string.
|
![]() | HtmlExportDataOptions |
Represents the options for exporting html data.
|
![]() | HtmlHiddenColDisplayType |
Represents two types of showing the hidden col in html.
|
![]() | HtmlHiddenRowDisplayType |
Represents two types of showing the hidden row in html.
|
![]() | HtmlLinkTargetType | |
![]() | IconSetType |
Icon set type for conditional formatting.
The threshold values for triggering the different icons within a set are
configurable, and the icon order is reversible.
|
![]() | LoadDataFilterOptions |
Represents the options to filter data when loading workbook from template.
|
![]() | LoadFormat |
Represents the load file format.
|
![]() | LookAtType |
Represents look at type.
|
![]() | LookInType |
Represents look in type.
|
![]() | MemorySetting |
Memory usage options.
|
![]() | NumberCategoryType |
Represents category type of cell's number formatting.
|
![]() | OoxmlCompliance |
Allows to specify which OOXML specification will be used when saving in the Xlsx format.
|
![]() | OoxmlCompressionType |
The Ooxml compression type
|
![]() | OperatorType |
Represents the operator type of conditional format and data validation.
|
![]() | PageLayoutAlignmentType |
Enumerates page layout alignment types.
|
![]() | PageOrientationType |
Represents print orientation constants.
|
![]() | PaneStateType |
Represents state of the sheet's pane.
|
![]() | PaperSizeType |
Represents paper size constants.
|
![]() | ParameterType |
Represents all parameters' type or return value type of function.
|
![]() | PasteType |
Represents the paste special type.
|
![]() | PrintCommentsType |
Represents the way comments are printed with the sheet.
|
![]() | PrintErrorsType |
Represents print errors constants.
|
![]() | PrintingPageType |
Indicates which pages will not be printed.
|
![]() | PrintOrderType |
Represent print order constants.
|
![]() | PrintSizeType |
Represents the printed chart size.
|
![]() | ProtectionType |
Represents workbook/worksheet protection type.
|
![]() | RenameStrategy |
Renames strategy when columns contains the duplicate names.
|
![]() | ResourceLoadingType |
Represents how to loading the linked resource.
|
![]() | SaveFormat |
Represents the format in which the workbook is saved.
|
![]() | SheetType |
Specifies the worksheet type.
|
![]() | ShiftType |
Represent the shift options when deleting a range of cells.
|
![]() | SortOnType |
Sorted value type.
|
![]() | SortOrder |
Represents sort order for the data range.
|
![]() | StyleModifyFlag |
The style modified flags.
|
![]() | TargetModeType |
Represents the type of target mode.
|
![]() | TextAlignmentType |
Enumerates text alignment types.
|
![]() | TextCapsType |
This type specifies the cap types of the text.
|
![]() | TextCrossType |
Enumerates displaying text type when the text width is larger than cell width.
|
![]() | TextDirectionType |
Represents the direction of the text flow for this paragraph.
|
![]() | TextOrientationType |
Enumerates text orientation types.
|
![]() | TextStrikeType |
This type specifies the strike type.
|
![]() | ThemeColorType |
Enumerates the theme color types.
|
![]() | TimePeriodType |
Used in a FormatConditionType.TimePeriod conditional formatting rule.
These are dynamic time periods, which change based on
the date the conditional formatting is refreshed / applied.
|
![]() | TxtLoadStyleStrategy |
Specifies how to apply style for parsed values when converting string value to number or datetime.
|
![]() | TxtValueQuoteType |
Specifies the type of using quotation marks for values in text format files.
|
![]() | UpdateLinksType |
Represents how to update links to other workbooks when the workbook is opened.
|
![]() | ValidationAlertType |
Represents the data validation alert style.
|
![]() | ValidationType |
Represents data validation type.
|
![]() | ViewType |
Represents the view type of the worksheet.
|
![]() | VisibilityType |
Represents the states for sheet visibility.
|
![]() | WarningType |
WaringType
|