Aspose.Cells

Contains all basic classes of Aspose.Cells.

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.
AbstractGlobalizationSettings Represents the globalization settings.
AbstractInterruptMonitor Monitor for interruption requests in all time-consuming operations.
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 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.
CellWatch Represents Cell Watch Item in the ‘watch window’.
CellWatchCollection Represents the collection of cells on this worksheet being watched in the ‘watch window’.
CollectionBase<T> Provides the abstract base class for a strongly typed collection.
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 Collection of the 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.
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.
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.
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.
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. 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.
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.
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 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. 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 Represents Svg save options. For advanced usage, please use !:WorkbookRender or !:SheetRender.
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.
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.

Interfaces

Interface Description
ICellsDataTable Represents data table.
ICustomFunction
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

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 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 Represents the 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 columns in html.
HtmlHiddenRowDisplayType Represents two types of showing the hidden rows in html.
HtmlLinkTargetType Represents the type of target attribute in HTML tag.
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.
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.
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 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 WaringType