Package com.aspose.cells

Class Summary
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
ActiveXControl	Represents the ActiveX control.
ActiveXControlBase	Represents the ActiveX control.
ArcShape	Represents the arc shape.
Area	Encapsulates the object that represents an area format.
AutoFilter	Represents autofiltering for the specified worksheet.
AutoFitterOptions	Represents all auto fitter options.
AutomaticFill	represents automatic fill.
AutoNumberedBulletValue	Represents automatic numbered bullet.
Axis	Encapsulates the object that represents a chart's axis.
AxisBins	Represents axis bins
BaseShapeGuide	Represents the shape guide.
Bevel	Represents a bevel of a shape
Border	Encapsulates the object that represents the cell border.
BorderCollection	Encapsulates a collection of Border objects.
BuiltInDocumentPropertyCollection	A collection of built-in document properties.
Bullet	Represents the bullet.
BulletValue	Represents the value of the bullet.
Button	Represents the Forms control: Button
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.
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.
CellsDrawing	Represents the auto shape and drawing object.
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'.
CharacterBulletValue	Represents the character bullet.
Chart	Encapsulates the object that represents a single Excel chart.
ChartArea	Encapsulates the object that represents the chart area in the worksheet.
ChartCollection	Encapsulates a collection of Chart objects.
ChartDataTable	Represents a chart data table.
ChartFrame	Encapsulates the object that represents the frame object in a chart.
ChartGlobalizationSettings	Represents the globalization settings for chart.
ChartPoint	Represents a single point in a series in a chart.
ChartPointCollection	Represents a collection that contains all the points in one series.
ChartShape	Represents the shape of the chart. Properties and methods for the ChartObject object control the appearance and size of the embedded chart on the worksheet.
ChartTextFrame	Encapsulates the object that represents the frame object which contains text.
CheckBox	Represents a check box object in a worksheet.
CheckBoxActiveXControl	Represents a CheckBox ActiveX control.
CheckBoxCollection	Represents a collection of CheckBox objects in a worksheet.
CollectionBase	Provides the abstract base class for a strongly typed collection.
Color	Represents an ARGB (alpha, red, green, blue) color.
ColorFilter	Represents the color filter.
ColorHelper	Provides helper functions about 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 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.
ComboBox	Represents the control form ComboBox.
ComboBoxActiveXControl	Represents a ComboBox ActiveX control.
CommandButtonActiveXControl	Represents a command button.
Comment	Encapsulates the object that represents a cell comment.
CommentCollection	Encapsulates a collection of Comment objects.
CommentShape	Represents the shape of the comment.
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.
ConnectionParameter	Specifies properties about any parameters used with external data connections Parameters are valid for ODBC and web queries.
ConnectionParameterCollection	Specifies the ConnectionParameter collection
ContentTypeProperty	Represents identifier information.
ContentTypePropertyCollection	A collection of ContentTypeProperty objects that represent additional information.
CopyOptions	Represents the copy options.
CustomDocumentPropertyCollection	A collection of custom document properties.
CustomFilter	Represents the custom filter.
CustomFilterCollection	Represents the custom filters.
CustomGeometry	Represents a custom geometric shape.
CustomImplementationFactory	Factory to create some instances which may be re-implemented by user for special purpose.
CustomProperty	Represents identifier information.
CustomPropertyCollection	A collection of CustomProperty objects that represent additional information.
CustomXmlPart	Represents a Custom XML Data Storage Part (custom XML data within a package).
CustomXmlPartCollection	Represents a Custom XML Data Storage Part (custom XML data within a package).
CustomXmlShape	Represents Custom xml shape ,such as Ink.
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.
DataLabels	Encapsulates a collection of all the DataLabel objects for the specified Series.
DataModelConnection	Specifies a data model connection
DataSorter	Summary description for DataSorter.
DataSorterKey	Represents the key of the data sorter.
DataSorterKeyCollection	Represents the key list of data sorter.
DateTime	Represents an instant in time, typically expressed as a date and time of day.
DateTimeGroupItem	Represents the datetime's group setting.
DBConnection	Specifies all properties associated with an ODBC or OLE DB external data connection.
DefaultStyleSettings	Settings for the default values of workbook's style properties.
DeleteOptions	Represents the setting of deleting rows/columns.
DialogBox	Represents the dialog box.
DifSaveOptions	Represents the options of saving dif file.
DigitalSignature	Signature in file.
DigitalSignatureCollection	Provides a collection of digital signatures attached to a document.
DisplayUnitLabel	Represents the display unit label.
DocumentProperty	Represents a custom or built-in document property.
DocumentPropertyCollection	Base class for BuiltInDocumentPropertyCollection and CustomDocumentPropertyCollection collections.
DocxSaveOptions	Represents options of saving .docx file.
DrawObject	DrawObject will be initialized and returned when rendering.
DrawObjectEventHandler	Interface to get DrawObject and Bound when rendering.
DropBars	Represents the up/down bars in a chart.
DxfCollection	Represents the master differential formatting records.
DynamicFilter	Represents the dynamic filter.
Encoding	Represents a character encoding.
ErrorBar	Represents error bar of data series.
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.
ExportRangeToJsonOptions	Indicates the options that exporting range to json.
ExportTableOptions	Represents all export table options.
ExternalConnection	Specifies an external data connection
ExternalConnectionCollection	Specifies the ExternalConnection collection
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.
Fill	Represents the fill format of the shape.
FillFormat	Encapsulates the object that represents fill formatting for a shape.
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.
Floor	Encapsulates the object that represents the floor of a 3-D chart.
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.
FontSettingCollection	Represents the list of FontSetting.
FontSourceBase	This is an abstract base class for the classes that allow the user to specify various font sources
Format3D	This class specifies the 3D shape properties for a chart element or shape.
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.
Geometry	Represents a geometric shape.
GlobalizationSettings	Represents the globalization settings.
GlowEffect	This class specifies a glow effect, in which a color blurred outline is added outside the edges of the object.
GradientFill	Represents the gradient fill.
GradientStop	Represents the gradient stop.
GradientStopCollection	Represents the gradient stop collection.
GroupBox	Encapsulates the object that represents a groupbox in a spreadsheet.
GroupFill	Represents this fill format should inherit the fill properties of the group.
GroupShape	Represents the group shape which contains the individual shapes.
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.
ImageActiveXControl	Represents the image control.
ImageFormat	Specifies the file format of the image.
ImageOrPrintOptions	Allows to specify options when rendering worksheet to images, printing worksheet or rendering chart to image.
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.
JsonLayoutOptions	Represents the options of json layout type.
JsonLoadOptions	Represents the options of loading json files
JsonSaveOptions	Represents the options of saving the workbook as a json file.
JsonUtility	Represents the utility class of processing json.
Label	Encapsulates the object that represents a label in a spreadsheet.
LabelActiveXControl	Represents the label ActiveX control.
Legend	Encapsulates the object that represents the chart legend.
LegendEntry	Represents a legend entry in a chart legend.
LegendEntryCollection	Represents a collection of all the LegendEntry objects in the specified chart legend.
License	Provides methods to license the component.
Line	Encapsulates the object that represents the line format.
LineFormat	Represents all setting of the line.
LineShape	Represents the line shape.
ListBox	Represents a list box object.
ListBoxActiveXControl	Represents a ListBox ActiveX control.
ListColumn	Represents a column in a list.
ListColumnCollection	Represents A collection of all the ListColumn objects in the specified ListObject object.
ListObject	Represents a list object on a worksheet. The ListObject object is a member of the ListObjects collection. The ListObjects collection contains all the list objects on a worksheet.
ListObjectCollection	Represents a collection of ListObject objects in the worksheet.
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.
Marker	Represents the marker in a line chart, scatter chart, or radar chart.
MemoryFontSource	Represents the single TrueType font file stored in memory.
MetadataOptions	Represents the options of loading metadata of the file.
Metered	Provides methods to set metered key.
MsoFillFormat	Represents fill formatting for a shape.
MsoFillFormatHelper	Represents fill formatting for a shape.
MsoFormatPicture	Represents the picture format.
MsoLineFormat	Represents line and arrowhead formatting.
MsoLineFormatHelper	Represents line and arrowhead formatting.
MsoTextFrame	Represents the text frame in a Shape object.
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.
NoneBulletValue	Represents no bullet.
NoneFill	Represents no fill.
NumbersLoadOptions	Represents the options of loading Apple Numbers files.
OdsCellField	Represents the cell field of ods.
OdsCellFieldCollection	Represents the fields of ODS.
OdsLoadOptions	Represents the options of loading ods file.
OdsPageBackground	Represents the page background of ods.
OdsSaveOptions	Represents the options of saving ods file.
OleObject	Represents an OleObject in a worksheet.
OleObjectCollection	Represents embedded OLE objects.
OoxmlSaveOptions	Represents the options of saving office open xml file.
Outline	Represents an outline on a worksheet.
Oval	Represents the oval shape.
PageEndSavingArgs	Info for a page ends saving process.
PageSavingArgs	Info for a page saving process.
PageSetup	Encapsulates the object that represents the page setup description. The PageSetup object contains all page setup options.
PageStartSavingArgs	Info for a page starts saving process.
PaginatedSaveOptions	Represents the options for pagination.
PaneCollection	Represents all Pane objects shown in the specified window.
PasteOptions	Represents the paste special options.
PatternFill	Encapsulates the object that represents pattern fill format
PdfBookmarkEntry	PdfBookmarkEntry is an entry in pdf bookmark. if Text property of current instance is null or "", current instance will be hidden and children will be inserted on current level.
PdfSaveOptions	Represents the options for saving pdf file.
PdfSecurityOptions	Settings of pdf when converting excel to pdf, PDF/A does not allow security setting.
PicFormatOption	Represents picture format option
Picture	Encapsulates the object that represents a single picture in a spreadsheet.
PictureBulletValue	Represents the value of the image bullet.
PictureCollection	Encapsulates a collection of Picture objects.
PivotField	Represents a field in a PivotTable report.
PivotFieldCollection	Represents a collection of all the PivotField objects in the PivotTable's specific PivotFields type.
PivotFilter	Represents a PivotFilter in PivotFilter Collection.
PivotFilterCollection	Represents a collection of all the PivotFilter objects
PivotFormatCondition	Represents a PivotTable Format Condition in PivotFormatCondition Collection.
PivotFormatConditionCollection	Represents PivotTable Format Conditions.
PivotItem	Represents a item in a PivotField report.
PivotItemCollection	Represents a collection of all the PivotItem objects in the PivotField's
PivotOptions	Represents a complex type that specifies the pivot controls that appear on the chart
PivotPageFields	Represents the pivot page field items if the pivot table data source is consolidation ranges. It only can contain up to 4 fields.
PivotTable	Summary description for PivotTable.
PivotTableCollection	Represents the collection of all the PivotTable objects on the specified worksheet.
PlotArea	Encapsulates the object that represents the plot area in a chart.
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.
RadioButton	Represents a radio button.
RadioButtonActiveXControl	Represents a RadioButton ActiveX control.
Range	Encapsulates the object that represents a range of cells within a spreadsheet.
RangeCollection	Encapsulates a collection of Range objects.
RectangleShape	Represents the rectangle shape.
ReferredArea	Represents a referred area by the formula.
ReferredAreaCollection	Represents all referred cells and areas.
ReflectionEffect	This class specifies a reflection effect.
ReplaceOptions	Represent the replace options.
Revision	Represents the revision.
RevisionAutoFormat	represents a revision record of information about a formatting change.
RevisionCellChange	Represents the revision that changing cells.
RevisionCellComment	Represents a revision record of a cell comment change.
RevisionCellMove	Represents a revision record on a cell(s) that moved.
RevisionCollection	Represents all revision logs.
RevisionCustomView	Represents a revision record of adding or removing a custom view to the workbook
RevisionDefinedName	Represents a revision record of a defined name change.
RevisionFormat	represents a revision record of information about a formatting change.
RevisionInsertDelete	Represents a revision record of a row/column insert/delete action.
RevisionInsertSheet	Represents a revision record of a sheet that was inserted.
RevisionLog	Represents the revision log.
RevisionLogCollection	Represents all revision logs.
RevisionMergeConflict	Represents a revision record which indicates that there was a merge conflict.
RevisionQueryTable	Represents a revision of a query table field change.
RevisionRenameSheet	Represents a revision of renaming sheet.
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.
ScrollBar	Represents a scroll bar object.
ScrollBarActiveXControl	Represents the ScrollBar control.
Series	Encapsulates the object that represents a single data series in a chart.
SeriesCollection	Encapsulates a collection of Series objects.
SeriesLayoutProperties	Represents the properties of series layout.
ShadowEffect	This class specifies the shadow effect of the chart element or shape.
Shape	Represents the msodrawing object.
ShapeCollection	Represents all the shape in a worksheet/chart.
ShapeFormat	Represents the format of the shape or text.
ShapeGuide	Encapsulates a shape guide specifies the presence of a shape guide that will be used to govern the geometry of the specified shape
ShapeGuideCollection	Encapsulates a collection of shape guide
ShapePath	Represents a creation path consisting of a series of moves, lines and curves that when combined will form a geometric shape.
ShapePathCollection	Represents path collection information in NotPrimitive autoshape
ShapePathPoint	Represents an x-y coordinate within the path coordinate space.
ShapePathPointCollection	Represents all shape path points.
ShapePropertyCollection	This class specifies the visual shape properties for a chart element or shape.
ShapeSegmentPath	Represents a segment path in a path of the freeform.
ShapeSegmentPathCollection	Represents a creation path consisting of a series of moves, lines and curves that when combined will form a geometric shape.
ShapeTextAlignment	Represents the setting of shape's text alignment;
SheetPrintingPreview	Worksheet printing preview.
SheetRender	Represents a worksheet render which can render worksheet to various images such as (BMP, PNG, JPEG, TIFF..) The constructor of this class , must be used after modification of pagesetup, cell style.
SheetSet	Describes a set of sheets.
SignatureLine	Represent the signature line.
Slicer	summary description of Slicer View
SlicerCache	summary description of slicer cache
SlicerCacheItem	Represent slicer data source item
SlicerCacheItemCollection	Represent the collection of SlicerCacheItem
SlicerCollection	Specifies the collection of all the Slicer objects on the specified worksheet.
SmartArtShape	Represents the smart art.
SmartTag	Represents a smart tag.
SmartTagCollection	Represents all smart tags in the cell.
SmartTagOptions	Represents the options of the smart tag.
SmartTagProperty	Represents the property of the cell smart tag.
SmartTagPropertyCollection	Represents all properties of cell smart tag.
SmartTagSetting	Represents all SmartTagCollection object in the worksheet.
SolidFill	Encapsulates the object that represents solid fill format
Sparkline	A sparkline represents a tiny chart or graphic in a worksheet cell that provides a visual representation of data.
SparklineCollection	Encapsulates a collection of Sparkline objects.
SparklineGroup	Sparkline is organized into sparkline group. A SparklineGroup contains a variable number of sparkline items. A sparkline group specifies the type, display settings and axis settings for the sparklines.
SparklineGroupCollection	Encapsulates a collection of SparklineGroup objects.
SpinButtonActiveXControl	Represents the SpinButton control.
Spinner	Represents the Forms control: Spinner.
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.
SxRng	Represents Group Range in a PivotField.
TableStyle	Represents the table style.
TableStyleCollection	Represents all custom table styles.
TableStyleElement	Represents the element of the table style.
TableStyleElementCollection	Represents all elements of the table style.
TableToRangeOptions	Represents the options when converting table to range.
TextBox	Encapsulates the object that represents a textbox in a spreadsheet.
TextBoxActiveXControl	Represents a text box ActiveX control.
TextBoxCollection	Encapsulates a collection of TextBox objects.
TextEffectFormat	Contains properties and methods that apply to WordArt objects.
TextOptions	Represents the text options.
TextParagraph	Represents the text paragraph setting.
TextParagraphCollection	Represents all text paragraph.
TextTabStop	Represents tab stop.
TextTabStopCollection	Represents the list of all tab stops.
TextureFill	Encapsulates the object that represents texture fill format
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.
ThreeDFormat	Represents a shape's three-dimensional formatting.
TickLabelItem	Include information of a Ticklabel item
TickLabels	Represents the tick-mark labels associated with tick marks on a chart axis.
TilePicOption	Represents tile picture as texture.
Timeline	Summary description of Timeline View Due to MS Excel, Excel 2003 does not support Timeline
TimelineCollection	Specifies the collection of all the Timeline objects on the specified worksheet. Due to MS Excel, Excel 2003 does not support Timeline.
Title	Encapsulates the object that represents the title of chart or axis.
ToggleButtonActiveXControl	Represents a ToggleButton ActiveX control.
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.
Trendline	Represents a trendline in a chart.
TrendlineCollection	Represents a collection of all the Trendline objects for the specified data series.
TxtLoadOptions	Represents the options for loading text file.
TxtSaveOptions	Represents the save options for csv/tab delimited/other text format.
UnionRange	Represents union range.
UnknownControl	Unknow control.
Validation	Represents data validation.settings.
ValidationCollection	Represents data validation collection.
VbaModule	Represents the module in VBA project.
VbaModuleCollection	Represents the list of VbaModule
VbaProject	Represents the VBA project.
VbaProjectReference	Represents the reference of VBA project.
VbaProjectReferenceCollection	Represents all references of VBA project.
VerticalPageBreak	Encapsulates the object that represents a vertical page break.
VerticalPageBreakCollection	Encapsulates a collection of VerticalPageBreak objects.
VmlShapeGuide	just for vml Encapsulates a shape guide specifies the presence of a shape guide that will be used to govern the geometry of the specified shape
Walls	Encapsulates the object that represents the walls of a 3-D chart.
WarningInfo	Warning info
WebExtension	Represents an Office Add-in instance.
WebExtensionBinding	Represents a binding relationship between an Office Add-in and the data in the document.
WebExtensionBindingCollection	Represents the list of binding relationships between an Office Add-in and the data in the document.
WebExtensionCollection	Represents the list of web extension.
WebExtensionProperty	Represents an Office Add-in custom property.
WebExtensionPropertyCollection	Represents the list of web extension properties.
WebExtensionReference	Represents identify the provider location and version of the extension.
WebExtensionReferenceCollection	Represents the list of web extension reference.
WebExtensionShape	Represents the shape of web extension.
WebExtensionTaskPane	Represents a persisted taskpane object.
WebExtensionTaskPaneCollection	Represents the list of task pane.
WebQueryConnection	Specifies the properties for a web query source. A web query will retrieve data from HTML tables, and can also supply HTTP "Get" parameters to be processed by the web server in generating the HTML by including the parameters and parameter elements.
Workbook	Represents a root object to create an Excel spreadsheet.
WorkbookDesigner	Encapsulates the object that represents a designer spreadsheet.
WorkbookMetadata	Represents the meta data.
WorkbookPrintingPreview	Workbook printing preview.
WorkbookRender	Represents a Workbook render. The constructor of this class , must be used after modification of pagesetup, cell style.
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.

 

Interface Summary
ICellsDataTable	Represents data table.
ICustomFunction	Allows users to add their custom formula calculation functions to extend the calculation engine.
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.
IPageSavingCallback	Control/Indicate progress of page saving process.
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.

 

Constant Summary
AccessCacheOptions	Utility class containing constants. Cache options for data access. Can be combined with | operator for multiple options together.
ActiveXPersistenceType	Utility class containing constants. Represents the persistence method to persist an ActiveX control.
AutoFillType	Utility class containing constants. Represents the auto fill type.
AutoFitMergedCellsType	Utility class containing constants. Represents the type of auto fitting merged cells.
AutoFitWrappedTextType	Utility class containing constants. Represents the type of auto fitting wrapped text.
AutoShapeType	Utility class containing constants. Represents all built-in auto shape type.
AxisType	Utility class containing constants. Represents the axis type.
BackgroundMode	Utility class containing constants. Represents the display mode of the background.
BackgroundType	Utility class containing constants. Enumerates cell background pattern types.
Bar3DShapeType	Utility class containing constants. Represents the shape used with the 3-D bar or column chart.
BevelPresetType	Utility class containing constants. Represents a preset for a type of bevel which can be applied to a shape in 3D.
BevelType	Utility class containing constants. Represents a preset for a type of bevel which can be applied to a shape in 3D.
BorderType	Utility class containing constants. Enumerates the border line and diagonal line types.
BubbleSizeRepresents	Utility class containing constants. Represents what the bubble size represents on a bubble chart.
BuiltinStyleType	Utility class containing constants. Represents all built-in style types.
BulletType	Utility class containing constants. Represents the type of the bullet.
CalcModeType	Utility class containing constants. Represents the mode type of calculating formulas.
CalculationPrecisionStrategy	Utility class containing constants. 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.
CategoryType	Utility class containing constants. Represents the category axis type.
CellBorderType	Utility class containing constants. Enumerates a cell's border type.
CellValueFormatStrategy	Utility class containing constants. Specifies how to apply style for the value of the cell.
CellValueType	Utility class containing constants. Specifies a cell value type.
ChartLineFormattingType	Utility class containing constants. Represents line format type of chart line.
ChartMarkerType	Utility class containing constants. Represents the marker style in a line chart, scatter chart, or radar chart.
ChartSplitType	Utility class containing constants. Represents the way the two sections of either a pie of pie chart or a bar of pie chart are split.
ChartTextDirectionType	Utility class containing constants. Represents the text direction type of the chart.
ChartType	Utility class containing constants. Enumerates all chart types used in Excel.
CheckValueType	Utility class containing constants. Represents the check value type of the check box.
ColorDepth	Utility class containing constants. Enumerates Bit Depth Type for tiff image.
ColorType	Utility class containing constants. Represents all color type
CommentTitleType	Utility class containing constants. Represents comment title type while rendering when comment is set to display at end of sheet.
ConnectionDataSourceType	Utility class containing constants. Specifies external database source type
ConnectionParameterType	Utility class containing constants. Specifies the parameter type of external connection
ConsolidationFunction	Utility class containing constants. Represents consolidation function.
ControlBorderType	Utility class containing constants. Represents the border type of the ActiveX control.
ControlCaptionAlignmentType	Utility class containing constants. Represents the position of the Caption relative to the control.
ControlListStyle	Utility class containing constants. Represents the visual appearance of the list in a ListBox or ComboBox.
ControlMatchEntryType	Utility class containing constants. Represents how a ListBox or ComboBox searches its list as the user types.
ControlMousePointerType	Utility class containing constants. Represents the type of icon displayed as the mouse pointer for the control.
ControlPictureAlignmentType	Utility class containing constants. Represents the alignment of the picture inside the Form or Image.
ControlPicturePositionType	Utility class containing constants. Represents the location of the control's picture relative to its caption.
ControlPictureSizeMode	Utility class containing constants. Represents how to display the picture.
ControlScrollBarType	Utility class containing constants. Represents the type of scroll bar.
ControlScrollOrientation	Utility class containing constants. Represents type of scroll orientation
ControlSpecialEffectType	Utility class containing constants. Represents the type of special effect.
ControlType	Utility class containing constants. Represents all type of ActiveX control.
CopyFormatType	Utility class containing constants. Represents type of copying format when inserting rows.
CountryCode	Utility class containing constants. Represents Excel country identifiers.
CredentialsMethodType	Utility class containing constants. Specifies Credentials method used for server access.
CrossType	Utility class containing constants. Represents the axis cross type.
DataBarAxisPosition	Utility class containing constants. Specifies the axis position for a range of cells with conditional formatting as data bars.
DataBarBorderType	Utility class containing constants. Specifies the border type of a data bar.
DataBarFillType	Utility class containing constants. Specifies how a data bar is filled with color.
DataBarNegativeColorType	Utility class containing constants. Specifies whether to use the same border and fill color as positive data bars.
DataLabelShapeType	Utility class containing constants. Specifies the preset shape geometry that is to be used for a chart.
DataLabelsSeparatorType	Utility class containing constants. Represents the separator type of DataLabels.
DataLablesSeparatorType	Utility class containing constants. Represents the separator type of DataLabels.
DateTimeGroupingType	Utility class containing constants. Specifies how to group dateTime values.
DefaultEditLanguage	Utility class containing constants. Represents the default edit language.
DirectoryType	Utility class containing constants. Represents the directory type of the file name.
DisplayDrawingObjects	Utility class containing constants. Represents whether and how to show objects in the workbook.
DisplayUnitType	Utility class containing constants. Represents the type of display unit.
DrawObjectEnum	Utility class containing constants. Indicate Cell or Image of DrawObject.
DropButtonStyle	Utility class containing constants. Represents the symbol displayed on the drop button.
DynamicFilterType	Utility class containing constants. Dynamic filter type.
EmfRenderSetting	Utility class containing constants. Setting for rendering Emf metafile.
EncryptionType	Utility class containing constants. 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.
ErrorBarDisplayType	Utility class containing constants. Represents error bar display type.
ErrorBarType	Utility class containing constants. Represents error bar amount type.
ErrorCheckType	Utility class containing constants. Represents all error check type.
ExceptionType	Utility class containing constants. Represents custom exception type code.
ExternalLinkType	Utility class containing constants. Represents the type of external link.
FileFormatType	Utility class containing constants. Represents the file format types.
FillPattern	Utility class containing constants. Enumerates shape fill pattern types.
FillPictureType	Utility class containing constants. Represents the picture fill type.
FillType	Utility class containing constants. Fill format type.
FilterOperatorType	Utility class containing constants. Custom Filter operator type.
FilterType	Utility class containing constants. The filter type.
FontSchemeType	Utility class containing constants. Represents the scheme type of the font.
FontSourceType	Utility class containing constants. Specifies the type of a font source.
FontUnderlineType	Utility class containing constants. Enumerates the font underline types.
FormatConditionType	Utility class containing constants. Conditional format rule type.
FormatConditionValueType	Utility class containing constants. Condition value type.
FormatSetType	Utility class containing constants. Fill format set type.
FormattingType	Utility class containing constants. Represents the type of formatting applied to an Area object or a Line object.
GradientColorType	Utility class containing constants. Represents the gradient color type for the specified fill.
GradientDirectionType	Utility class containing constants. Represents all direction type of gradient.
GradientFillType	Utility class containing constants. Represents all Gradient fill type.
GradientPresetType	Utility class containing constants. Represents gradient preset color type.
GradientStyleType	Utility class containing constants. Represents gradient shading style.
GridlineType	Utility class containing constants. Enumerates grid line Type.
HeaderFooterCommandType	Utility class containing constants. Represents the command type of header and footer.
HtmlCrossType	Utility class containing constants. Represents five types of html cross string.
HtmlExportDataOptions	Utility class containing constants. Represents the options for exporting html data.
HtmlFormatHandlingType	Utility class containing constants. Specifies how to handle formatting from the HTML source
HtmlHiddenColDisplayType	Utility class containing constants. Represents two types of showing the hidden columns in html.
HtmlHiddenRowDisplayType	Utility class containing constants. Represents two types of showing the hidden rows in html.
HtmlLinkTargetType	Utility class containing constants. Represents the type of target attribute in HTML tag.
IconSetType	Utility class containing constants. 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.
ImageType	Utility class containing constants. Specifies the type (format) of an image.
InputMethodEditorMode	Utility class containing constants. Represents the default run-time mode of the Input Method Editor.
LabelPositionType	Utility class containing constants. Represents data label position type.
LegendPositionType	Utility class containing constants. Enumerates the legend position types.
LightRigDirectionType	Utility class containing constants. Represents the light rig direction type.
LightRigType	Utility class containing constants. Represents a preset light right that can be applied to a shape
LineCapType	Utility class containing constants. Represents the caps of a line
LineJoinType	Utility class containing constants. Represents the join styles of a line.
LineSpaceSizeType	Utility class containing constants. Represents the unit type of line space size.
LineType	Utility class containing constants. Enumerates the type of Picture border or Chart line.
LoadDataFilterOptions	Utility class containing constants. Represents the options to filter data when loading workbook from template.
LoadFormat	Utility class containing constants. Represents the load file format.
LoadNumbersTableType	Utility class containing constants. Indicates type of loading tables when some tables are in a sheet.
LookAtType	Utility class containing constants. Represents look at type.
LookInType	Utility class containing constants. Represents look in type.
MapChartLabelLayout	Utility class containing constants. Represents the layout of map chart's labels.
MapChartProjectionType	Utility class containing constants. Represents projection type of the map chart.
MapChartRegionType	Utility class containing constants. Represents the region type of the map chart.
MemorySetting	Utility class containing constants. Memory usage options.
MetadataType	Utility class containing constants. Represents the type of metadata.
MirrorType	Utility class containing constants. Represents mirror type of texture fill
MsoArrowheadLength	Utility class containing constants. Enumerates the line end width of the shape border line.
MsoArrowheadStyle	Utility class containing constants. Enumerates the line end type of the shape border line.
MsoArrowheadWidth	Utility class containing constants. Enumerates the line end width of the shape border line.
MsoDrawingType	Utility class containing constants. Represents office drawing objects type.
MsoLineDashStyle	Utility class containing constants. Represents style of dash drawing lines.
MsoLineStyle	Utility class containing constants. Represents style of drawing lines.
MsoPresetTextEffect	Utility class containing constants. Represents preset text effect type of WordArt.
MsoPresetTextEffectShape	Utility class containing constants. Represents preset text effect shape type of WordArt.
NameScopeType	Utility class containing constants. Represents the scope type of defined names.
NumberCategoryType	Utility class containing constants. Represents category type of cell's number formatting.
OdsCellFieldType	Utility class containing constants. Represents the cell field type of ods.
OdsGeneratorType	Utility class containing constants. Represents the type of ODS generator.
OdsPageBackgroundGraphicPositionType	Utility class containing constants. Represents the position.
OdsPageBackgroundGraphicType	Utility class containing constants. Represents the type of formatting page background with image.
OdsPageBackgroundType	Utility class containing constants. Represents the page background type of ods.
OLEDBCommandType	Utility class containing constants. Specifies the OLE DB command type.
OoxmlCompliance	Utility class containing constants. Allows to specify which OOXML specification will be used when saving in the Xlsx format.
OoxmlCompressionType	Utility class containing constants. The Ooxml compression type
OperatorType	Utility class containing constants. Represents the operator type of conditional format and data validation.
PageLayoutAlignmentType	Utility class containing constants. Enumerates page layout alignment types.
PageOrientationType	Utility class containing constants. Represents print orientation constants.
PaneStateType	Utility class containing constants. Represents state of the sheet's pane.
PaperSizeType	Utility class containing constants. Represents paper size constants.
ParameterType	Utility class containing constants. Represents all parameters' type or return value type of function.
PasteOperationType	Utility class containing constants. Represents operation type when pasting range.
PasteType	Utility class containing constants. Represents the paste special type.
PdfCompliance	Utility class containing constants. Allowing user to set PDF conversion's Compatibility
PdfCompressionCore	Utility class containing constants. Specifies a type of compression applied to all content in the PDF file except images.
PdfCustomPropertiesExport	Utility class containing constants. Specifies the way CustomDocumentPropertyCollection are exported to PDF file.
PdfFontEncoding	Utility class containing constants. Represents pdf embedded font encoding.
PdfOptimizationType	Utility class containing constants. Specifies a type of optimization.
PivotConditionFormatRuleType	Utility class containing constants. Represents PivotTable condition formatting rule type.
PivotConditionFormatScopeType	Utility class containing constants. Represents PivotTable condition formatting scope type.
PivotFieldDataDisplayFormat	Utility class containing constants. Represents data display format in the PivotTable data field.
PivotFieldSubtotalType	Utility class containing constants. Summary description for PivotFieldSubtotalType.
PivotFieldType	Utility class containing constants. Represents PivotTable field type.
PivotFilterType	Utility class containing constants. Represents PivotTable Filter type.
PivotGroupByType	Utility class containing constants. Represents PivotTable groupby type.
PivotItemPosition	Utility class containing constants. Represents PivotTable base item Next/Previous/All position in the base field .
PivotMissingItemLimitType	Utility class containing constants. Represents number of items to retain per field.
PivotTableAutoFormatType	Utility class containing constants. Represents PivotTable auto format type.
PivotTableStyleType	Utility class containing constants. Represents the pivot table style type.
PlacementType	Utility class containing constants. Represents the way the drawing object is attached to the cells below it.
PlotDataByType	Utility class containing constants. Represents the type of data plot by row or column.
PlotEmptyCellsType	Utility class containing constants. Represents all plot empty cells type of a chart.
PresetCameraType	Utility class containing constants. Represent different algorithmic methods for setting all camera properties, including position.
PresetMaterialType	Utility class containing constants. Describes surface appearance of a shape.
PresetShadowType	Utility class containing constants. Represents preset shadow type.
PresetThemeGradientType	Utility class containing constants. Represents the preset theme gradient type.
PresetWordArtStyle	Utility class containing constants. Represents the preset WordArt styles.
PrintCommentsType	Utility class containing constants. Represents the way comments are printed with the sheet.
PrintErrorsType	Utility class containing constants. Represents print errors constants.
PrintingPageType	Utility class containing constants. Indicates which pages will not be printed.
PrintOrderType	Utility class containing constants. Represent print order constants.
PrintSizeType	Utility class containing constants. Represents the printed chart size.
PropertyType	Utility class containing constants. Specifies data type of a document property.
ProtectionType	Utility class containing constants. Represents workbook/worksheet protection type.
QuartileCalculationType	Utility class containing constants. Represents quartile calculation methods.
ReConnectionMethodType	Utility class containing constants. Specifies what the spreadsheet application should do when a connection fails.
RectangleAlignmentType	Utility class containing constants. Represents how to position two rectangles relative to each other.
ReflectionEffectType	Utility class containing constants. Represents the effect type of reflection.
RenameStrategy	Utility class containing constants. Strategy option for duplicate names of columns.
ResourceLoadingType	Utility class containing constants. Represents how to loading the linked resource.
RevisionActionType	Utility class containing constants. Represents the type of revision action.
RevisionType	Utility class containing constants. Represents the revision type.
SaveFormat	Utility class containing constants. Represents the format in which the workbook is saved.
SelectionType	Utility class containing constants. The selection type of list box.
ShapeAnchorType	Utility class containing constants. Represents the anchor type.
ShapeLockType	Utility class containing constants. Represents type of the property to be locked.
ShapePathType	Utility class containing constants. Represents path segment type.
SheetType	Utility class containing constants. Specifies the worksheet type.
ShiftType	Utility class containing constants. Represent the shift options when deleting a range of cells.
ShowDropButtonType	Utility class containing constants. Specifies when to show the drop button
SlicerCacheCrossFilterType	Utility class containing constants. Represent the type of SlicerCacheCrossFilterType
SlicerCacheItemSortType	Utility class containing constants. Specify the sort type of SlicerCacheItem
SlicerStyleType	Utility class containing constants. Specify the style of slicer view
SmartTagShowType	Utility class containing constants. Represents the show type of the smart tag.
SortOnType	Utility class containing constants. Sorted value type.
SortOrder	Utility class containing constants. Represents sort order for the data range.
SparklineAxisMinMaxType	Utility class containing constants. Represents the minimum and maximum value types for the sparkline vertical axis.
SparklinePresetStyleType	Utility class containing constants. Represents the preset style types for sparkline.
SparklineType	Utility class containing constants. Represents the sparkline types.
SqlDataType	Utility class containing constants. Specifies SQL data type of the parameter. Only valid for ODBC sources.
StyleModifyFlag	Utility class containing constants. The style modified flags.
TableDataSourceType	Utility class containing constants. Represents the table's data source type.
TableStyleElementType	Utility class containing constants. Represents the Table or PivotTable style element type.
TableStyleType	Utility class containing constants. Represents the built-in table style type.
TargetModeType	Utility class containing constants. Represents the type of target mode.
TextAlignmentType	Utility class containing constants. Enumerates text alignment types.
TextAutonumberScheme	Utility class containing constants. Represents all automatic number scheme.
TextCapsType	Utility class containing constants. This type specifies the cap types of the text.
TextCrossType	Utility class containing constants. Enumerates displaying text type when the text width is larger than cell width.
TextDirectionType	Utility class containing constants. Represents the direction of the text flow for this paragraph.
TextFontAlignType	Utility class containing constants. Represents the different types of font alignment.
TextNodeType	Utility class containing constants. Represents the node type.
TextOrientationType	Utility class containing constants. Enumerates text orientation types.
TextOverflowType	Utility class containing constants. Represents the way the text vertical or horizontal overflow.
TextStrikeType	Utility class containing constants. This type specifies the strike type.
TextTabAlignmentType	Utility class containing constants. Represents the text tab alignment types.
TextureType	Utility class containing constants. Represents the preset texture type.
TextVerticalType	Utility class containing constants. Represents the text direct type.
ThemeColorType	Utility class containing constants. Enumerates the theme color types.
TickLabelPositionType	Utility class containing constants. Represents the position type of tick-mark labels on the specified axis.
TickMarkType	Utility class containing constants. Represents the tick mark type for the specified axis.
TiffCompression	Utility class containing constants. Specifies what type of compression to apply when saving images into TIFF format file.
TimePeriodType	Utility class containing constants. 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.
TimeUnit	Utility class containing constants. Represents the base unit for the category axis.
TotalsCalculation	Utility class containing constants. Determines the type of calculation in the Totals row of the list column.
TrendlineType	Utility class containing constants. Represents the trendline type.
TxtLoadStyleStrategy	Utility class containing constants. Specifies how to apply style for parsed values when converting string value to number or datetime.
TxtValueQuoteType	Utility class containing constants. Specifies the type of using quotation marks for values in text format files.
UpdateLinksType	Utility class containing constants. Represents how to update links to other workbooks when the workbook is opened.
ValidationAlertType	Utility class containing constants. Represents the data validation alert style.
ValidationType	Utility class containing constants. Represents data validation type.
VbaModuleType	Utility class containing constants. Represents the type of VBA module.
VbaProjectReferenceType	Utility class containing constants. Represents the type of VBA project reference.
ViewType	Utility class containing constants. Represents the view type of the worksheet.
VisibilityType	Utility class containing constants. Represents the states for sheet visibility.
WarningType	Utility class containing constants. WaringType
WebExtensionStoreType	Utility class containing constants. Represents the store type of web extension.
WeightType	Utility class containing constants. Enumerates the weight types for a picture border or a chart line.
XAdESType	Utility class containing constants. Type of XML Advanced Electronic Signature (XAdES).

 

See Also:
          Aspose.Cells Documentation - the home page for the Aspose.Cells Product Documentation.
          Aspose.Cells Support Forum - our preferred method of support.