Click or drag to resize
Aspose.Cells Namespace
Contains all basic classes of Aspose.Cells.
Classes
  ClassDescription
Public classAboveAverage
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.
Public classCode exampleAbstractCalculationEngine
Represents user's custom calculation engine to extend the default calculation engine of Aspose.Cells.
Public classCode exampleAutoFilter
Represents autofiltering for the specified worksheet.
Public classAutoFitterOptions
Represents all auto fitter options.
Public classCode exampleBorder
Encapsulates the object that represents the cell border.
Public classCode exampleBorderCollection
Encapsulates a collection of Border objects.
Public classCalculationData
Represents the required data when calculating one function, such as function name, parameters, ...etc.
Public classCalculationOptions
Represents options for calculation.
Public classCode exampleCell
Encapsulates the object that represents a single Workbook cell.
Public classCode exampleCells
Encapsulates a collection of Cell objects.
Public classCellsColor
Represents all types of color.
Public classCellsException
The exception that is thrown when Aspose.Cells specified error occurs.
Public classCellsFactory
Represents the factory of the cells's classes
Public classCellsHelper
Provides helper functions.
Public classColorFilter
Represents the color filter.
Public classColorScale
Describe the ColorScale conditional formatting rule. This conditional formatting rule creates a gradated color scale on the cells.
Public classCode exampleColumn
Represents a single column in a worksheet.
Public classCode exampleColumnCollection
Collects the objects that represent the individual columns in a worksheet.
Public classCode exampleComment
Encapsulates the object that represents a cell comment.
Public classCode exampleCommentCollection
Encapsulates a collection of Comment objects.
Public classCode exampleConditionalFormattingCollection
Encapsulates a collection of FormatCondition objects.
Public classConditionalFormattingIcon
Represents the custom icon of conditional formatting rule.
Public classCode exampleConditionalFormattingIconCollection
Represents a collection of ConditionalFormattingIcon objects.
Public classConditionalFormattingResult
Represents the result of conditional formatting which applies to a cell.
Public classConditionalFormattingValue
Describes the values of the interpolation points in a gradient scale, dataBar or iconSet.
Public classConditionalFormattingValueCollection
Describes a collection of CFValueObject. Use only for icon sets.
Public classCopyOptions
Represents the copy options.
Public classCustomFilter
Represents the custom filter.
Public classCustomFilterCollection
Represents the custom filters.
Public classCustomImplementationFactory
Factory to create some instances which may be re-implemented by user for special purpose.
Public classCode exampleDataBar
Describe the DataBar conditional formatting rule. This conditional formatting rule displays a gradated data bar in the range of cells.
Public classDataBarBorder
Represents the border of the data bars specified by a conditional formatting rule.
Public classCode exampleDataSorter
Summary description for DataSorter.
Public classDateTimeGroupItem
Represents the datetime's group setting.
Public classDeleteOptions
Represents the setting of deleting rows/columns.
Public classDifSaveOptions
Represents the options of saving dif file.
Public classDxfCollection
Represents the master differential formatting records.
Public classDynamicFilter
Represents the dynamic filter.
Public classCode exampleErrorCheckOption
Error check setting applied on certain ranges.
Public classErrorCheckOptionCollection
Represents all erorr check option.
Public classExportObjectEvent
The event triggered when exporting an object, such as Picture.
Public classExportTableOptions
Represents all export table options.
Public classCode exampleExternalLink
Represents an external link in a workbook.
Public classCode exampleExternalLinkCollection
Represents external links collection in a workbook.
Public classFileFontSource
Represents the single TrueType font file stored in the file system.
Public classFileFormatInfo
Contains data returned by FileFormatUtil file format detection methods.
Public classFileFormatUtil
Provides utility methods for converting file format enums to strings or file extensions and back.
Public classFilterColumn
Represents a filter for a single column. The Filter object is a member of the Filters collection
Public classFilterColumnCollection
A collection of Filter objects that represents all the filters in an autofiltered range.
Public classCode exampleFindOptions
Represents find options.
Public classFolderFontSource
Represents the folder that contains TrueType font files.
Public classCode exampleFont
Encapsulates the font object used in a spreadsheet.
Public classFontConfigs
Specifies font settings
Public classCode exampleFontSetting
Represents a range of characters within the cell text.
Public classFontSourceBase
This is an abstract base class for the classes that allow the user to specify various font sources
Public classCode exampleFormatCondition
Represents conditional formatting condition.
Public classCode exampleFormatConditionCollection
Represents conditional formatting. The FormatConditions can contain up to three conditional formats.
Public classGlobalizationSettings
Repsents the globalization settings.
Public classHeaderFooterCommand
Represents the command of header/footer
Public classCode exampleHorizontalPageBreak
Encapsulates the object that represents a horizontal page break.
Public classCode exampleHorizontalPageBreakCollection
Encapsulates a collection of HorizontalPageBreak objects.
Public classHTMLLoadOptions
Represents options when importing a html file.
Public classHtmlSaveOptions
Represents the options for saving html file.
Public classCode exampleHyperlink
Encapsulates the object that represents a hyperlink.
Public classCode exampleHyperlinkCollection
Encapsulates a collection of Hyperlink objects.
Public classIconFilter
Represents icon filter.
Public classCode exampleIconSet
Describe the IconSet conditional formatting rule. This conditional formatting rule applies icons to cells according to their values.
Public classImageSaveOptions
Represents image save options
Public classImportTableOptions
Represents the options of importing data into cells.
Public classInterruptMonitor
Represents all operator about the interrupt.
Public classCode exampleLicense
Provides methods to license the component.
Public classLoadDataOption Obsolete.
Public classCode exampleLoadFilter
Represents the filter that provides options for loading data when loading workbook from template.
Public classLoadOptions
Represents the options of loading the file.
Public classMemoryFontSource
Represents the single TrueType font file stored in memory.
Public classCode exampleMetered
Provides methods to set metered key.
Public classMultipleFilterCollection
Represents the multiple filte collection.
Public classCode exampleName
Represents a defined name for a range of cells.
Public classNameCollection
Represents a collection of all the Name objects in the spreadsheet.
Public classNegativeBarFormat
Represents the color settings of the data bars for negative values that are defined by a data bar conditional formating rule.
Public classOdsSaveOptions
Represents the options of saving ods file.
Public classOoxmlSaveOptions
Represents the options of saving office open xml file.
Public classOutline
Represents an outline on a worksheet.
Public classCode examplePageSetup
Encapsulates the object that represents the page setup description. The PageSetup object contains all page setup options.
Public classPaneCollection
Represents all Pane objects shown in the specified window.
Public classPasteOptions
Represents the paste special options.
Public classPdfSaveOptions
Represents the options for saving pdf file.
Public classProtectedRange
A specified range to be allowed to edit when the sheet protection is ON.
Public classProtectedRangeCollection
Encapsulates a collection of ProtectedRange objects.
Public classCode exampleProtection
Represents the various types of protection options available for a worksheet. Only used in ExcelXP and above version.
Public classQueryTable
Represents QueryTable information.
Public classQueryTableCollection
A collection of QueryTableCollection objects that represent QueryTable collection information.
Public classRange
Encapsulates the object that represents a range of cells within a spreadsheet.
Public classRangeCollection
Encapsulates a collection of Range objects.
Public classReferredArea
Represents a referred area by the formula.
Public classReferredAreaCollection
Represents all referred cells and areas.
Public classReplaceOptions
Represent the replace options.
Public classRow
Represents a single row in a worksheet.
Public classRowCollection
Collects the objects that represent the individual rows in a worksheet.
Public classSaveOptions
Represents all save options
Public classScenario
Represents an individual scenario.
Public classScenarioCollection
Represents the list of scenarios.
Public classScenarioInputCell
Represents input cell for the scenario.
Public classScenarioInputCellCollection
Represents the list of the scenario's input cells.
Public classSpreadsheetML2003SaveOptions
Represents the options for saving Excel 2003 spreadml file.
Public classStreamProviderOptions
Represents the stream options.
Public classCode exampleStyle
Represents display style of excel document,such as font,color,alignment,border,etc.
Public classStyleCollection Obsolete.
Public classStyleFlag
Represents flags which indicates applied formatting properties.
Public classSvgSaveOptions
Represents Svg save options
Public classCode exampleThemeColor
Represents a theme color.
Public classTop10
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.
Public classTop10Filter
Represents the top 10 filter.
Public classTxtLoadOptions
Represents the options for loading text file.
Public classTxtSaveOptions
Repesents the save options for csv/tab delimitered/other text format.
Public classCode exampleValidation
Represents data validation.settings.
Public classValidationCollection
Represents data validation collection.
Public classCode exampleVerticalPageBreak
Encapsulates the object that represents a vertical page break.
Public classVerticalPageBreakCollection
Encapsulates a collection of VerticalPageBreak objects.
Public classWarningInfo
Warning info
Public classCode exampleWorkbook
Represents a root object to create an Excel spreadsheet.
Public classCode exampleWorkbookDesigner
Encapsulates the object that represents a designer spreadsheet.
Public classWorkbookSettings
Represents all seetings of the workbook.
Public classCode exampleWorksheet
Encapsulates the object that represents a single worksheet.
Public classCode exampleWorksheetCollection
Encapsulates a collection of Worksheet objects.
Public classWriteProtection
Specifies write protection settings for a workbook.
Public classXlsbSaveOptions
Represents the options for saving xlsb file.
Public classXlsSaveOptions
Represents the save options for the Excel 97-2003 file format: xls and xlt.
Public classXmlColumnProperty
Represents Xml Data Binding information.
Public classXmlMap
Represents Xml map information.
Public classXmlMapCollection
A collection of XmlMap objects that represent XmlMap information.
Public classXpsSaveOptions
Represents the additional options when saving the file as the Xps.
Structures
  StructureDescription
Public structureCode exampleCellArea
Represent an area of cells.
Interfaces
  InterfaceDescription
Public interfaceICellsDataTable
Represents data table.
Public interfaceICustomFunction
Allows users to add their custom formula calculation functions to extend the calculation engine.
Public interfaceICustomParser
Allows users to add their custom value parser for parsing string values to other proper cell value object.
Public interfaceCode exampleIExportObjectListener
Allows users to manipulate objects while exporting.
Public interfaceIFilePathProvider
Represents the exported file path provider.
Public interfaceISmartMarkerCallBack
Represents callback interface of processing smartmarker.
Public interfaceIStreamProvider
Represents the exported stream provider.
Public interfaceIWarningCallback
Callback interface of warning.
Public interfaceLightCellsDataHandler
Represents cells data handler for reading large spreadsheet files in light weight mode.
Public interfaceLightCellsDataProvider
Represents Data provider for saving large spreadsheet files in light weight mode.
Enumerations
  EnumerationDescription
Public enumerationBackgroundType
Enumerates cell background pattern types.
Public enumerationBorderType
Enumerates the border line and diagonal line types.
Public enumerationBuiltinStyleType
Represents all builin style type
Public enumerationCalcModeType
Represents the mode type of calculating formulas.
Public enumerationCalculationPrecisionStrategy
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.
Public enumerationCellBorderType
Enumerates a cell's border type.
Public enumerationCellValueFormatStrategy
Specifies how to apply style for the value of the cell.
Public enumerationCellValueType
Specifies a cell value type.
Public enumerationColorType
Represents all color type
Public enumerationConsolidationFunction
Represents consolidation function.
Public enumerationContentDisposition
The content disposition type.
Public enumerationCountryCode
Represents Excel country identifiers.
Public enumerationDataBarAxisPosition
Specifies the axis position for a range of cells with conditional formatting as data bars.
Public enumerationDataBarBorderType
Specifies the border type of a data bar.
Public enumerationDataBarFillType
Specifies how a data bar is filled with color.
Public enumerationDataBarNegativeColorType
Specifies whether to use the same border and fill color as postive data bars.
Public enumerationDateTimeGroupingType
Specifies how to group dateTime values.
Public enumerationDirectoryType
Represents the directory type of the file name.
Public enumerationDisplayDrawingObjects
Represents whether and how to show objects in the workbook.
Public enumerationDynamicFilterType
Dynamic filter type.
Public enumerationEncryptionType
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.
Public enumerationErrorCheckType
Represents all error check type.
Public enumerationExceptionType
Represents custom exception type code.
Public enumerationFileFormatType
Enumerates spreadsheet file format types
Public enumerationFilterOperatorType
InnerCustom Filter operator type.
Public enumerationFilterType
The filter type.
Public enumerationFontSourceType
Specifies the type of a font source.
Public enumerationFontUnderlineType
Enumerates the font underline types.
Public enumerationFormatConditionType
Conditional format rule type.
Public enumerationFormatConditionValueType
Condition value type.
Public enumerationHeaderFooterCommandType
Represents the command type of header and footer.
Public enumerationHtmlCrossType
Represents three types of html corss string.
Public enumerationHtmlExportDataOptions
Represents the options for exporting html data.
Public enumerationHtmlHiddenColDisplayType
Represents two types of showing the hidden col in html.
Public enumerationHtmlHiddenRowDisplayType
Represents two types of showing the hidden row in html.
Public enumerationHtmlLinkTargetType
Represents the type of target attribute in HTML tag.
Public enumerationIconSetType
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.
Public enumerationLoadDataFilterOptions
Represents the options to filter data when loading workbook from template.
Public enumerationLoadFormat
Represents the load file format.
Public enumerationLookAtType
Represents look at type.
Public enumerationLookInType
Represents look in type.
Public enumerationMemorySetting
Memory usage options.
Public enumerationNumberCategoryType
Represents category type of cell's number formatting.
Public enumerationOperatorType
Represents the operator type of conditional format and data validation.
Public enumerationPageOrientationType
Represents print orientation constants.
Public enumerationPaperSizeType
Represents paper size constants.
Public enumerationParameterType
Represents all parameters' type or return value type of function.
Public enumerationPasteType
Represents the paste special type.
Public enumerationPrintCommentsType
Represents the way comments are printed with the sheet.
Public enumerationPrintErrorsType
Represents print errors constants.
Public enumerationPrintingPageType
Indicates which pages will not be printed.
Public enumerationPrintOrderType
Represent print order constants.
Public enumerationPrintSizeType
Represents the printed chart size.
Public enumerationProtectionType
Represents workbook/worksheet protection type.
Public enumerationRenameStrategy
Renames strategy when columns contains the duplicate names.
Public enumerationSaveFormat
Represents the format in which the workbook is saved.
Public enumerationSaveType
Enumerates spreadsheet creation and saving types.
Public enumerationSheetType
Specifies the worksheet type.
Public enumerationShiftType
Represent the shift options when deleting a range of cells.
Public enumerationSortOrder
Represents sort order for the data range.
Public enumerationStyleModifyFlag
The style mofied flags.
Public enumerationTextAlignmentType
Enumerates text alignment types.
Public enumerationTextCapsType
This type specifies the cap types of the text.
Public enumerationTextDirectionType
Represents the direction of the text flow for this paragraph.
Public enumerationTextOrientationType
Enumerates text orientation types.
Public enumerationTextStrikeType
This type specifies the strike type.
Public enumerationThemeColorType
Enumerates the theme color types.
Public enumerationTimePeriodType
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.
Public enumerationTxtLoadStyleStrategy
Specifies how to apply style for parsed values when converting string value to number or datetime.
Public enumerationTxtValueQuoteType
Specifies the type of using quotation marks for values in text format files.
Public enumerationUpdateLinksType
Represents how to update links to other workbooks when the workbook is opened.
Public enumerationValidationAlertType
Represents the data validation alert style.
Public enumerationValidationType
Represents data validation type.
Public enumerationViewType
Represents the view type of the worksheet.
Public enumerationVisibilityType
Represents the states for sheet visibility.
Public enumerationWarningType
WaringType