Aspose::Cells namespace

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.
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.
Cells	Encapsulates a collection of cell relevant objects, such as Cell, Row, …etc.
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.
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’.
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.
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.
Enumerator	Enumeration template class, provides a simple way to iterate over a collection.
ErrorCheckOption	Error check setting applied on certain ranges.
ErrorCheckOptionCollection	Represents all error check option.
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.
IconFilter	Represents icon filter.
IconSet	Describe the IconSet conditional formatting rule. This conditional formatting rule applies icons to cells according to their values.
IFilePathProvider	Represents the exported file path provider.
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.
IWarningCallback	Callback interface of warning.
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.
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.
Object	Object class.
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.
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 .
SystemTimeInterruptMonitor	Simple implementation of AbstractInterruptMonitor by checking and comparing current system time with user specified limit.
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.
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.
U16String	Represents the char16_t array class and ends with u’\0'.
UnionRange	Represents union range.
Validation	Represents data validation.settings.
ValidationCollection	Represents data validation collection.
Vector	Vector template class. The elements are stored contiguously.
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.
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.

Struct

Struct	Description
Color	Represents an ARGB (alpha, red, green, blue) color.
Date	Represents a date and time.

Enums

Enum	Description
AccessCacheOptions	Cache options for data access. Can be combined with
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.
CellsUnitType	Specifies the unit of measurement.
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.
EncodingType	Enums supported encoding types.
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.
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.
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.
MergedCellsShrinkType	Represents the strategy to shrink merged cells for operations such as deleting blank rows/column.
MergeEmptyTdType	Represents the merge type for empty TD element when exporting file to html.
NameScopeType	Represents the scope type of defined names.
NumberCategoryType	Represents category type of cell’s number formatting.
ObjectType	Represents the type of the object.
NumberType	Represents the type of the number.
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.

Typedefs

Typedef	Description
UUID	Guid struct.

Methods

Method	Description
AccessCacheOptions operator&(AccessCacheOptions a, AccessCacheOptions b)
BorderType operator&(BorderType a, BorderType b)
LoadDataFilterOptions operator&(LoadDataFilterOptions a, LoadDataFilterOptions b)
StyleModifyFlag operator&(StyleModifyFlag a, StyleModifyFlag b)
AccessCacheOptions operator|(AccessCacheOptions a, AccessCacheOptions b)
BorderType operator|(BorderType a, BorderType b)
LoadDataFilterOptions operator|(LoadDataFilterOptions a, LoadDataFilterOptions b)
AccessCacheOptions operator~(AccessCacheOptions a)
LoadDataFilterOptions operator~(LoadDataFilterOptions a)
bool operator==(const Aspose::Cells::Color &left, const Aspose::Cells::Color &right)
bool operator==(const U16String &str1, const U16String &str2)	operator==
bool operator!=(const Aspose::Cells::Color &left, const Aspose::Cells::Color &right)
bool operator!=(const U16String &str1, const U16String &str2)	operator!=
void Startup()	Initializes the Aspose.Cells library, which must be invoked before using the library.
void Cleanup(bool cleanupOpenSSL=true)	Clean up the Aspose.Cells library.