Click or drag to resize

Aspose.Cells Namespace

Contains all basic classes of Aspose.Cells.
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 exampleAbstractCalculationMonitor
Monitor for user to track the progress of formula calculation.
Public classAbstractInterruptMonitor
Monitor for interruption requests in all time-consuming operations.
Public classAbstractTextLoadOptions
Common options for loading text values
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 classCalculationCell
Represents the calculation relevant data about one cell which is being calculated.
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 relevant objects, such as Cell, Row, ...etc.
Public classCellsColor
Represents all types of color.
Public classCellsException
The exception that is thrown when Aspose.Cells specified error occurs.
Public classCellsFactory
Utility for instantiating classes of Cells model.
Public classCellsHelper
Provides helper functions.
Public classCellWatch
Represents Cell Watch Item in the 'watch window'.
Public classCellWatchCollection
Represents the collection of cells on this worksheet being watched in the 'watch window'.
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 classDataSorterKey
Represents the key of the data sorter.
Public classDataSorterKeyCollection
Represents the key list of data sorter.
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 classDocxSaveOptions
Represents options of saving .docx 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 error 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 classFormulaParseOptions
Represents options when parsing formula.
Public classGlobalizationSettings
Represents 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 classIndividualFontConfigs
Font configs for each Workbook object.
Public classInsertOptions
Represents the options of inserting.
Public classInterruptMonitor
Represents all operator about the interrupt.
Public classJsonLoadOptions
Represents the options of loading json files
Public classJsonSaveOptions
Represents the options of saving the workbook as a json file.
Public classCode exampleLicense
Provides methods to license the component.
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 classMarkdownSaveOptions
Represents the save options for markdown.
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 filter 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 formatting rule.
Public classOdsLoadOptions
Represents the options of loading ods file.
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 classPptxSaveOptions
Represents the pptx save options.
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 classSubtotalSetting
Represents the setting of the subtotal .
Public classSvgSaveOptions
Represents Svg save options
Public classCode exampleThemeColor
Represents a theme color.
Public classThreadedComment
Represents the threaded comment.
Public classThreadedCommentAuthor
Represents the person who creates the threaded comments;
Public classThreadedCommentAuthorCollection
Represents all persons who .
Public classThreadedCommentCollection
Represents the list of threaded comments.
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
Represents the save options for csv/tab delimited/other text format.
Public classUnionRange
Represents union range.
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 settings 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 classXmlDataBinding
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.
Public structureCode exampleCellArea
Represent an area of cells.
Public interfaceICellsDataTable
Represents data table.
Public interfaceICustomFunction Obsolete.
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.
Public enumerationAccessCacheOptions
Cache options for data access. Can be combined with | operator for multiple options together.
Public enumerationAutoFillType
Represents the auto fill type.
Public enumerationAutoFitMergedCellsType
Represents the type of auto fitting merged cells.
Public enumerationAutoFitWrappedTextType
Represents the type of auto fitting wrapped text.
Public enumerationBackgroundType
Enumerates cell background pattern types.
Public enumerationBorderType
Enumerates the border line and diagonal line types.
Public enumerationBuiltinStyleType
Represents all built-in 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 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.
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 enumerationCopyFormatType
Represents type of copying format when inserting rows.
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 positive data bars.
Public enumerationDateTimeGroupingType
Specifies how to group dateTime values.
Public enumerationDefaultEditLanguage
Represents the default edit language.
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 enumerationEmfRenderSetting
Setting for rendering Emf metafile.
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 enumerationExternalLinkType
Represents the type of external link.
Public enumerationFileFormatType
Represents the file format types.
Public enumerationFilterOperatorType
Custom Filter operator type.
Public enumerationFilterType
The filter type.
Public enumerationFontSchemeType
Represents the scheme type of the font.
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 enumerationGridlineType
Enumerates grid line Type.
Public enumerationHeaderFooterCommandType
Represents the command type of header and footer.
Public enumerationHtmlCrossType
Represents five types of html cross string.
Public enumerationHtmlExportDataOptions
Represents the options for exporting html data.
Public enumerationHtmlHiddenColDisplayType
Represents two types of showing the hidden columns in html.
Public enumerationHtmlHiddenRowDisplayType
Represents two types of showing the hidden rows 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 enumerationOoxmlCompliance
Allows to specify which OOXML specification will be used when saving in the Xlsx format.
Public enumerationOoxmlCompressionType
The Ooxml compression type
Public enumerationOperatorType
Represents the operator type of conditional format and data validation.
Public enumerationPageLayoutAlignmentType
Enumerates page layout alignment types.
Public enumerationPageOrientationType
Represents print orientation constants.
Public enumerationPaneStateType
Represents state of the sheet's pane.
Public enumerationPaperSizeType
Represents paper size constants.
Public enumerationParameterType
Represents all parameters' type or return value type of function.
Public enumerationPasteOperationType
Represents operation type when pasting range.
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 enumerationResourceLoadingType
Represents how to loading the linked resource.
Public enumerationSaveFormat
Represents the format in which the workbook is saved.
Public enumerationSheetType
Specifies the worksheet type.
Public enumerationShiftType
Represent the shift options when deleting a range of cells.
Public enumerationSortOnType
Sorted value type.
Public enumerationSortOrder
Represents sort order for the data range.
Public enumerationStyleModifyFlag
The style modified flags.
Public enumerationTargetModeType
Represents the type of target mode.
Public enumerationTextAlignmentType
Enumerates text alignment types.
Public enumerationTextCapsType
This type specifies the cap types of the text.
Public enumerationTextCrossType
Enumerates displaying text type when the text width is larger than cell width.
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