aspose.cells

The Aspose.Cells namespace provides fundamental and base classes for generating, converting, modifying, rendering and printing Spreadsheets without utilizing Microsoft Excel. For example, Workbook class is the main entry to create or load and then manipulate a spreadsheet file, Cells class is the main class to manipulate all data and properties in a sheet, …etc.

Classes

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.
`AbstractFormulaChangeMonitor`	Monitor for user to track the change of formulas during certain operations.
`AbstractGlobalizationSettings`	Represents the globalization settings.
`AbstractInterruptMonitor`	Monitor for interruption requests in all time-consuming operations.
`AbstractTextLoadOptions`	Common options for loading text values
`AdvancedFilter`	Represents the settings of advanced filter.
`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.
`CellArea`	Represent an area of cells.
`CellRichValue`	Represents rich value of the cell.
`CellValue`	Represents the cell value and corresponding type.
`CellWatch`	Represents Cell Watch Item in the ‘watch window’.
`CellWatchCollection`	Represents the collection of cells on this worksheet being watched in the ‘watch window’.
`Cells`	Encapsulates a collection of cell relevant objects, such as `Cell`, `Row`, …etc.
`CellsColor`	Represents all types of color.
`CellsDataTableFactory`	Utility to build ICellsDataTable from custom objects for user’s convenience.
`CellsException`	The exception that is thrown when Aspose.Cells specified error occurs.
`CellsFactory`	Utility for instantiating classes of Cells model.
`CellsHelper`	Provides helper functions.
`ColorFilter`	Represents filtering the range by color.
`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`	Collection of the `Column` objects that represent the individual column(setting)s in a worksheet. The Column object only represents the settings such as column width, styles, .etc. for the whole column, has nothing to do with the fact that there are non-empty cells(data) or not in corresponding column. And the “Count” of this collection only represents the count Column objects that have been instantiated in this collection, has nothing to do with the fact that there are non-empty cells(data) or not in the 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.
`CustomFunctionDefinition`	Definition of custom function for calculating with user’s custom engine.
`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.
`DefaultStyleSettings`	Settings for the default values of workbook’s style properties.
`DeleteBlankOptions`	Represents the setting of deleting blank cells/rows/columns.
`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.
`EbookLoadOptions`	Represents options when importing an ebook file.
`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.
`FormulaSettings`	Settings of formulas and calculation.
`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.
`HtmlTableLoadOption`	Represents the option when import table from html.
`HtmlTableLoadOptionCollection`	Represents the table options when importing html.
`Hyperlink`	Encapsulates the object that represents a hyperlink.
`HyperlinkCollection`	Encapsulates a collection of `Hyperlink` objects.
`ICellsDataTable`	Represents data table.
`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.
`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. For advanced usage, please use `WorkbookRender` or `SheetRender`.
`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.
`JsonLoadOptions`	Represents the options of loading json files
`JsonSaveOptions`	Represents the options of saving the workbook as a json file.
`License`	Provides methods to license the component.
`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.
`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.
`PaginatedSaveOptions`	Represents the options for pagination.
`PaneCollection`	Represents all Pane objects shown in the specified window.
`PasteOptions`	Represents the paste special options.
`PclSaveOptions`	Represents the options for saving Pcl file.
`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.
`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 `Row` 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.
`SettableChartGlobalizationSettings`	Implementation of PivotGlobalizationSettings that supports user to set/change pre-defined texts.
`SettableGlobalizationSettings`	Implementation of GlobalizationSettings that supports user to set/change pre-defined texts.
`SettablePivotGlobalizationSettings`	Implementation of PivotGlobalizationSettings that supports user to set/change pre-defined texts.
`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. The Style object contains all style attributes (font, number format, alignment, and so on) as properties.
`StyleFlag`	Represents flags which indicates applied formatting properties.
`SubtotalSetting`	Represents the setting of the subtotal .
`SvgSaveOptions`
`SystemTimeInterruptMonitor`	Simple implementation of `AbstractInterruptMonitor` by checking and comparing current system time with user specified limit.
`ThemeColor`	Represents a theme color.
`ThreadInterruptMonitor`	Simple implementation of `AbstractInterruptMonitor` by starting another thread to require the interruption after sleeping user specified limit.
`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.
`TwoColorGradient`	Represents two color gradient.
`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.
`XlsSaveOptions`	Represents the save options for the Excel 97-2003 file format: xls and xlt.
`XlsbSaveOptions`	Represents the options for saving xlsb file.
`XmlColumnProperty`	Represents Xml Data Binding information.
`XmlDataBinding`	Represents Xml Data Binding information.
`XmlLoadOptions`	Represents the options of loading xml.
`XmlMap`	Represents Xml map information.
`XmlMapCollection`	A collection of `XmlMap` objects that represent XmlMap information.
`XmlSaveOptions`	Represents the options of saving the workbook as an xml file.
`XpsSaveOptions`	Represents the additional options when saving the file as the Xps.

Enumerations

Enumeration	Description
`AccessCacheOptions`	Cache options for data access. Can be combined with \| operator for multiple options together.
`AutoFillType`	Represents the auto fill type.
`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 types.
`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.
`CellsUnitType`	Specifies the unit of measurement.
`ColorType`	Represents all color type
`ConsolidationFunction`	Represents consolidation function.
`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.
`ErrorCellValueType`	Represents a cell value which contains an error.
`ErrorCheckType`	Represents all error check type.
`ExceptionType`	Represents custom exception type code.
`ExternalLinkType`	Represents the type of external link.
`FileFormatType`	Represents the file format types.
`FilterCategory`	Represents the category of the filter.
`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 columns in html.
`HtmlHiddenRowDisplayType`	Represents two types of showing the hidden rows in html.
`HtmlLinkTargetType`	Represents the type of target attribute in HTML tag.
`HtmlOfficeMathOutputType`	Represents how export OfficeMath to HTML.
`HtmlVersion`	Indicates the version of HTML is used when saving to Html formats.
`HyperlinkType`	Represents the type of hyperlink.
`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.
`MergeEmptyTdType`	Represents the merge type for empty TD element when exporting file to html.
`MergedCellsShrinkType`	Represents the strategy to shrink merged cells for operations such as deleting blank rows/column.
`NameScopeType`	Represents the scope type of defined names.
`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.
`PasteOperationType`	Represents operation type when pasting range.
`PasteType`	Represents the paste special type.
`PrintCommentsType`	Represents the way comments are printed with the sheet.
`PrintErrorsType`	Represents print errors constants.
`PrintOrderType`	Represent print order constants.
`PrintSizeType`	Represents the printed chart size.
`PrintingPageType`	Indicates which pages will not be printed.
`ProtectionType`	Represents workbook/worksheet protection type.
`RenameStrategy`	Strategy option for duplicate names of columns.
`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`