Aspose.Cells Namespace

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.

Represents user's custom calculation engine to extend the default calculation engine of Aspose.Cells.

Monitor for user to track the progress of formula calculation.

Common options for loading text values

Represents autofiltering for the specified worksheet.

Represents all auto fitter options.

Encapsulates the object that represents the cell border.

Encapsulates a collection of Border objects.

Represents the calculation relevant data about one cell which is being calculated.

Represents the required data when calculating one function, such as function name, parameters, ...etc.

Represents options for calculation.

Encapsulates the object that represents a single Workbook cell.

Encapsulates a collection of cell relevant objects, such as Cell, Row, ...etc.

Represents all types of color.

The exception that is thrown when Aspose.Cells specified error occurs.

Utility for instantiating classes of Cells model.

Provides helper functions.

Represents Cell Watch Item in the 'watch window'.

Represents the collection of cells on this worksheet being watched in the 'watch window'.

Represents the color filter.

Describe the ColorScale conditional formatting rule. This conditional formatting rule creates a gradated color scale on the cells.

Represents a single column in a worksheet.

Collects the objects that represent the individual columns in a worksheet.

Encapsulates the object that represents a cell comment.

Encapsulates a collection of Comment objects.

Encapsulates a collection of FormatCondition objects.

Represents the custom icon of conditional formatting rule.

Represents a collection of ConditionalFormattingIcon objects.

Represents the result of conditional formatting which applies to a cell.

Describes the values of the interpolation points in a gradient scale, dataBar or iconSet.

Describes a collection of CFValueObject. Use only for icon sets.

Represents the copy options.

Represents the custom filter.

Represents the custom filters.

Factory to create some instances which may be re-implemented by user for special purpose.

Describe the DataBar conditional formatting rule. This conditional formatting rule displays a gradated data bar in the range of cells.

Represents the border of the data bars specified by a conditional formatting rule.

Summary description for DataSorter.

Represents the key of the data sorter.

Represents the key list of data sorter.

Represents the datetime's group setting.

Represents the setting of deleting rows/columns.

Represents the options of saving dif file.

Represents options of saving docx file.

Represents the master differential formatting records.

Represents the dynamic filter.

Error check setting applied on certain ranges.

Represents all erorr check option.

The event triggered when exporting an object, such as Picture.

Represents all export table options.

Represents an external link in a workbook.

Represents external links collection in a workbook.

Represents the single TrueType font file stored in the file system.

Contains data returned by FileFormatUtil file format detection methods.

Provides utility methods for converting file format enums to strings or file extensions and back.

Represents a filter for a single column. The Filter object is a member of the Filters collection

A collection of Filter objects that represents all the filters in an autofiltered range.

Represents find options.

Represents the folder that contains TrueType font files.

Encapsulates the font object used in a spreadsheet.

Specifies font settings

Represents a range of characters within the cell text.

This is an abstract base class for the classes that allow the user to specify various font sources

Represents conditional formatting condition.

Represents conditional formatting. The FormatConditions can contain up to three conditional formats.

Represents options when parsing formula.

Repsents the globalization settings.

Represents the command of header/footer

Encapsulates the object that represents a horizontal page break.

Encapsulates a collection of HorizontalPageBreak objects.

Represents options when importing a html file.

Represents the options for saving html file.

Encapsulates the object that represents a hyperlink.

Encapsulates a collection of Hyperlink objects.

Represents icon filter.

Describe the IconSet conditional formatting rule. This conditional formatting rule applies icons to cells according to their values.

Represents image save options

Represents the options of importing data into cells.

Font configs for each Workbook object.

Represents the options of inserting.

Represents all operator about the interrupt.

Provides methods to license the component.

Represents the filter that provides options for loading data when loading workbook from template.

Represents the options of loading the file.

Represents the save options for markdown.

Represents the single TrueType font file stored in memory.

Provides methods to set metered key.

Represents the multiple filte collection.

Represents a defined name for a range of cells.

Represents a collection of all the Name objects in the spreadsheet.

Represents the color settings of the data bars for negative values that are defined by a data bar conditional formating rule.

Represents the options of loading ods file.

Represents the options of saving ods file.

Represents the options of saving office open xml file.

Represents an outline on a worksheet.

Encapsulates the object that represents the page setup description. The PageSetup object contains all page setup options.

Represents all Pane objects shown in the specified window.

Represents the paste special options.

Represents the options for saving pdf file.

Represents the pptx save options.

A specified range to be allowed to edit when the sheet protection is ON.

Encapsulates a collection of ProtectedRange objects.

Represents the various types of protection options available for a worksheet. Only used in ExcelXP and above version.

Represents QueryTable information.

A collection of QueryTableCollection objects that represent QueryTable collection information.

Encapsulates the object that represents a range of cells within a spreadsheet.

Encapsulates a collection of Range objects.

Represents a referred area by the formula.

Represents all referred cells and areas.

Represent the replace options.

Represents a single row in a worksheet.

Collects the objects that represent the individual rows in a worksheet.

Represents all save options

Represents an individual scenario.

Represents the list of scenarios.

Represents input cell for the scenario.

Represents the list of the scenario's input cells.

Represents the options for saving Excel 2003 spreadml file.

Represents the stream options.

Represents display style of excel document,such as font,color,alignment,border,etc.

Represents flags which indicates applied formatting properties.

Represents the setting of the subtotal .

Represents Svg save options

Represents a theme color.

Represents the threaded comment.

Represents the person who creates the theaded comments;

Represents all persons who .

Represents the list of threaded comments.

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.

Represents the top 10 filter.

Represents the options for loading text file.

Repesents the save options for csv/tab delimitered/other text format.

Represents union range.

Represents data validation.settings.

Represents data validation collection.

Encapsulates the object that represents a vertical page break.

Encapsulates a collection of VerticalPageBreak objects.

Warning info

Represents a root object to create an Excel spreadsheet.

Encapsulates the object that represents a designer spreadsheet.

Represents all seetings of the workbook.

Encapsulates the object that represents a single worksheet.

Encapsulates a collection of Worksheet objects.

Specifies write protection settings for a workbook.

Represents the options for saving xlsb file.

Represents the save options for the Excel 97-2003 file format: xls and xlt.

Represents Xml Data Binding information.

Represents Xml Data Binding information.

Represents Xml map information.

A collection of XmlMap objects that represent XmlMap information.

Represents the additional options when saving the file as the Xps.

Represent an area of cells.

Represents data table.

Allows users to add their custom value parser for parsing string values to other proper cell value object.

Allows users to manipulate objects while exporting.

Represents the exported file path provider.

Represents callback interface of processing smartmarker.

Represents the exported stream provider.

Callback interface of warning.

Represents cells data handler for reading large spreadsheet files in light weight mode.

Represents Data provider for saving large spreadsheet files in light weight mode.

Reprensents the type of auto fitting merged cells.

Represents the type of auto fitting wrapped text.

Enumerates cell background pattern types.

Enumerates the border line and diagonal line types.

Represents all builin style type

Represents the mode type of calculating formulas.

Enumerates strategies for handling calculation precision. Because of the precision issue of IEEE 754 Floating-Point Arithmetic, some "seemingly simple" formulas may not be calcualted as the expected result. Such as formula "=-0.45+0.43+0.02", when calcuating operands by '+' operator directly, the result is not zero. For such kind of precision issue, some special strategies may give the expected result.

Enumerates a cell's border type.

Specifies how to apply style for the value of the cell.

Specifies a cell value type.

Represents all color type

Represents consolidation function.

The content disposition type.

Represents type of copying format when inserting rows.

Represents Excel country identifiers.

Specifies the axis position for a range of cells with conditional formatting as data bars.

Specifies the border type of a data bar.

Specifies how a data bar is filled with color.

Specifies whether to use the same border and fill color as postive data bars.

Specifies how to group dateTime values.

Represents the default edit language.

Represents the directory type of the file name.

Represents whether and how to show objects in the workbook.

Dynamic filter type.

Setting for rendering Emf metafile.

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.

Represents all error check type.

Represents custom exception type code.

Represents the type of external link.

Enumerates spreadsheet file format types

InnerCustom Filter operator type.

The filter type.

Represents the scheme type of the font.

Specifies the type of a font source.

Enumerates the font underline types.

Conditional format rule type.

Condition value type.

Enumerates grid line Type.

Represents the command type of header and footer.

Represents five types of html corss string.

Represents the options for exporting html data.

Represents two types of showing the hidden col in html.

Represents two types of showing the hidden row in html.

Represents the type of target attribute in HTML tag.

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.

Represents the options to filter data when loading workbook from template.

Represents the load file format.

Represents look at type.

Represents look in type.

Memory usage options.

Represents category type of cell's number formatting.

Allows to specify which OOXML specification will be used when saving in the Xlsx format.

The Ooxml compression type

Represents the operator type of conditional format and data validation.

Enumerates page layout alignment types.

Represents print orientation constants.

Represents state of the sheet's pane.

Represents paper size constants.

Represents all parameters' type or return value type of function.

Represents the paste special type.

Represents the way comments are printed with the sheet.

Represents print errors constants.

Indicates which pages will not be printed.

Represent print order constants.

Represents the printed chart size.

Represents workbook/worksheet protection type.

Represents the regex type for seaching string.

Renames strategy when columns contains the duplicate names.

Represents how to loading the linked resource.

Represents the format in which the workbook is saved.

Specifies the worksheet type.

Represent the shift options when deleting a range of cells.

Sorted value type.

Represents sort order for the data range.

The style mofied flags.

Represents the type of target mode.

Enumerates text alignment types.

This type specifies the cap types of the text.

Enumerates displaying text type when the text width is larger than cell width.

Represents the direction of the text flow for this paragraph.

Enumerates text orientation types.

This type specifies the strike type.

Enumerates the theme color types.

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.

Specifies how to apply style for parsed values when converting string value to number or datetime.

Specifies the type of using quotation marks for values in text format files.

Represents how to update links to other workbooks when the workbook is opened.

Represents the data validation alert style.

Represents data validation type.

Represents the view type of the worksheet.

Represents the states for sheet visibility.

WaringType