aspose.cells

This reference page lists all types in the aspose.cells namespace, which provides the core functionality for workbook manipulation, formula evaluation, globalization, and UI control integration. Use these classes to programmatically build, analyze, and render Excel files.

Classes

ClassDescription
AboveAverageDescribe the AboveAverage conditional formatting rule. This conditional formatting rule highlights cells that are above
AbstractCalculationMonitorMonitor for user to track the progress of formula calculation.
AbstractFormulaChangeMonitor
AbstractGlobalizationSettingsRepresents the globalization settings.
AbstractInterruptMonitorMonitor for interruption requests in all time-consuming operations.
AbstractTextLoadOptionsCommon options for loading text values
AccentEquationNodeThis class specifies an accent equation, consisting of a base component and a combining diacritic.
ActiveXControlRepresents the ActiveX control.
ActiveXControlBaseRepresents the ActiveX control.
AdvancedFilterRepresents the settings of advanced filter.
ArcShapeRepresents the arc shape.
AreaEncapsulates the object that represents an area format.
ArrayEquationNode
AutoFilterRepresents autofiltering for the specified worksheet.
AutoFitterOptionsRepresents all auto fitter options.
AutoNumberedBulletValueRepresents automatic numbered bullet.
AutomaticFillrepresents automatic fill.
AxisEncapsulates the object that represents an axis of chart.
AxisBinsRepresents axis bins
BarEquationNodeThis class specifies the bar equation, consisting of a base argument and an overbar or underbar.
BaseShapeGuideRepresents the shape guide.
BevelRepresents a bevel of a shape
BorderEncapsulates the object that represents the cell border.
BorderBoxEquationNodeThis class specifies the Border Box function, consisting of a border drawn around an equation.
BorderCollectionEncapsulates a collection of Border objects.
BoxEquationNodeThis class specifies the box function, which is used to group components of an equation.
BuiltInDocumentPropertyCollectionA collection of built-in document properties. Provides access to DocumentProperty objects by their names (using an index
BulletRepresents the bullet points should be applied to a paragraph.
BulletValueRepresents the value of the bullet.
ButtonRepresents the Forms control: Button
CalculationCellRepresents the calculation relevant data about one cell which is being calculated. All objects provided by this class ar
CalculationDataRepresents the required data when calculating one function, such as function name, parameters, …etc. All objects provi
CalculationOptionsRepresents options for calculation.
CellEncapsulates the object that represents a single Workbook cell.
CellAreaRepresent an area of cells.
CellRichValue
CellValueRepresents the cell value and corresponding type.
CellWatchRepresents Cell Watch Item in the ‘watch window’.
CellWatchCollectionRepresents the collection of cells on this worksheet being watched in the ‘watch window’.
CellsEncapsulates a collection of cell relevant objects, such as Cell, Row, …etc.
CellsColorRepresents all types of color.
CellsDataTableFactoryUtility to build ICellsDataTable from custom objects for user’s convenience.
CellsDrawingRepresents the auto shape and drawing object.
CellsExceptionThe exception that is thrown when Aspose.Cells specified error occurs.
CellsFactoryUtility for instantiating classes of Cells model.
CellsHelperProvides helper functions.
CharacterBulletValueRepresents the character bullet.
ChartEncapsulates the object that represents a single Excel chart.
ChartAreaEncapsulates the object that represents the chart area in the worksheet.
ChartCalculateOptionsRepresents the options for calculating chart.
ChartCollectionEncapsulates a collection of Chart objects.
ChartDataTableRepresents a chart data table.
ChartDataValueEncapsulates chart data value
ChartFrameEncapsulates the object that represents the frame object in a chart.
ChartGlobalizationSettingsRepresents the globalization settings for chart.
ChartPointRepresents a single point in a series in a chart.
ChartPointCollectionRepresents a collection that contains all the points in one series.
ChartShapeRepresents the shape of the chart. Properties and methods for the ChartObject object control the appearance and size of
ChartTextFrameEncapsulates the object that represents the frame object which contains text.
CheckBoxRepresents a check box object in a worksheet.
CheckBoxActiveXControlRepresents a CheckBox ActiveX control.
CheckBoxCollectionRepresents a collection of CheckBox objects in a worksheet.
CollectionBaseProvides the abstract base class for a strongly typed collection.
ColorRepresents an ARGB (alpha, red, green, blue) color.
ColorFilterRepresents filtering the range by color.
ColorHelperProvides helper functions about color.
ColorScaleDescribe the ColorScale conditional formatting rule. This conditional formatting rule creates a gradated color scale on
ColumnRepresents a single column in a worksheet.
ColumnCollectionCollection of the Column objects that represent the individual column(setting)s in a worksheet. The Column object only r
ComboBoxRepresents the control form ComboBox.
ComboBoxActiveXControlRepresents a ComboBox ActiveX control.
CommandButtonActiveXControlRepresents a command button.
CommentEncapsulates the object that represents a cell comment.
CommentCollectionEncapsulates a collection of Comment objects.
CommentShapeRepresents the shape of the comment.
ConditionalFormattingCollectionEncapsulates a collection of FormatCondition objects.
ConditionalFormattingIconRepresents the custom icon of conditional formatting rule.
ConditionalFormattingIconCollectionRepresents a collection of ConditionalFormattingIcon objects.
ConditionalFormattingResultRepresents the result of conditional formatting which applies to a cell.
ConditionalFormattingValueDescribes the values of the interpolation points in a gradient scale, dataBar or iconSet.
ConditionalFormattingValueCollectionDescribes a collection of CFValueObject. Use only for icon sets.
ConnectionParameterSpecifies properties about any parameters used with external data connections Parameters are valid for ODBC and web quer
ConnectionParameterCollectionSpecifies the ConnectionParameter collection
ContentTypePropertyRepresents identifier information.
ContentTypePropertyCollectionA collection of ContentTypeProperty objects that represent additional information.
ConversionUtility
CopyOptionsRepresents the copy options.
CustomDocumentPropertyCollectionA collection of custom document properties. Each DocumentProperty object represents a custom property of a container doc
CustomFilterRepresents the custom filter.
CustomFilterCollectionRepresents the custom filters.
CustomFunctionDefinitionDefinition of custom function for calculating with user’s custom engine.
CustomGeometryRepresents a custom geometric shape.
CustomPiovtFieldGroupItemRepresents an item of custom grouped field.
CustomPropertyRepresents identifier information.
CustomPropertyCollectionA collection of CustomProperty objects that represent additional information.
CustomRenderSettings
CustomXmlShapeRepresents Custom xml shape ,such as Ink.
DBConnectionSpecifies all properties associated with an ODBC or OLE DB external data connection.
DataBarDescribe the DataBar conditional formatting rule. This conditional formatting rule displays a gradated data bar in the r
DataBarBorderRepresents the border of the data bars specified by a conditional formatting rule.
DataLabelsEncapsulates a collection of all the DataLabel objects for the specified Series.
DataMashupRepresents mashup data.
DataModelConnectionSpecifies a data model connection
DataSorterSummary description for DataSorter.
DataSorterKeyRepresents the key of the data sorter.
DataSorterKeyCollectionRepresents the key list of data sorter.
DateTimeRepresents an instant in time, typically expressed as a date and time of day.
DateTimeGroupItemRepresents the datetime’s group setting.
DbfLoadOptions
DbfSaveOptions
DefaultStyleSettingsSettings for the default values of workbook’s style properties.
DeleteBlankOptionsRepresents the setting of deleting blank cells/rows/columns.
DeleteOptionsRepresents the setting of deleting rows/columns.
DelimiterEquationNodeThis class specifies the delimiter equation, consisting of opening and closing delimiters (such as parentheses, braces,
DialogBoxRepresents the dialog box.
DifLoadOptions
DifSaveOptionsRepresents the options of saving dif file.
DigitalSignatureSignature in file.
DigitalSignatureCollectionProvides a collection of digital signatures attached to a document.
DisplayUnitLabelRepresents the display unit label.
DocumentPropertyRepresents a custom or built-in document property.
DocumentPropertyCollectionBase class for BuiltInDocumentPropertyCollection and CustomDocumentPropertyCollection collections.
DocxSaveOptionsRepresents options of saving .docx file.
DropBarsRepresents the up/down bars in a chart.
DxfCollectionRepresents the master differential formatting records.
DynamicFilterRepresents the dynamic filter.
EbookLoadOptionsRepresents options when importing an ebook file.
EbookSaveOptionsRepresents the options for saving ebook file.
EncodingRepresents a character encoding.
EquationComponentNodeThis class specifies the components of an equation or mathematical expression. Different types of components combined in
EquationNodeAbstract class for deriving other equation nodes.
EquationNodeParagraphThis class specifies a mathematical paragraph containing one or more MathEquationNode(OMath) elements.
ErrorBarRepresents error bar of data series.
ErrorCheckOptionError check setting applied on certain ranges.
ErrorCheckOptionCollectionRepresents all error check option.
ExportRangeToJsonOptionsIndicates the options that exporting range to json.
ExternalConnectionSpecifies an external data connection
ExternalConnectionCollectionSpecifies the ExternalConnection collection
ExternalLinkRepresents an external link in a workbook.
ExternalLinkCollectionRepresents external links collection in a workbook.
FileFontSourceRepresents the single TrueType font file stored in the file system.
FileFormatInfoContains data returned by FileFormatUtil file format detection methods.
FileFormatUtilProvides utility methods for converting file format enums to strings or file extensions and back.
FillRepresents the fill format of the shape.
FillFormatEncapsulates the object that represents fill formatting for a shape.
FilterColumnRepresents a filter for a single column. The Filter object is a member of the Filters collection
FilterColumnCollectionA collection of Filter objects that represents all the filters in an autofiltered range.
FilterValue
FilterValueCollection
FindOptionsRepresents find options.
FloorEncapsulates the object that represents the floor of a 3-D chart.
FolderFontSourceRepresents the folder that contains TrueType font files.
FontEncapsulates the font object used in a spreadsheet.
FontConfigsSpecifies font settings
FontFileDataInfo
FontSettingRepresents a range of characters within the cell text.
FontSettingCollectionRepresents the list of FontSetting.
FontSourceBaseThis is an abstract base class for the classes that allow the user to specify various font sources
Format3DThis class specifies the 3D shape properties for a chart element or shape.
FormatConditionRepresents conditional formatting condition.
FormatConditionCollectionRepresents conditional formatting. The FormatConditions can contain up to three conditional formats.
FormulaParseOptionsRepresents options when parsing formula.
FormulaSettingsSettings of formulas and calculation.
FractionEquationNodeThis class specifies the fraction equation, consisting of a numerator and denominator separated by a fraction bar. The f
FunctionEquationNodeThis class specifies the Function-Apply equation, which consists of a function name and an argument acted upon. The type
GeometryRepresents a geometric shape.
GlobalizationSettingsRepresents the globalization settings.
GlowEffectThis class specifies a glow effect, in which a color blurred outline is added outside the edges of the object.
GradientFillRepresents the gradient fill.
GradientStopRepresents the gradient stop.
GradientStopCollectionRepresents the gradient stop collection.
GroupBoxEncapsulates the object that represents a groupbox in a spreadsheet.
GroupCharacterEquationNodeThis class specifies the Group-Character function, consisting of a character drawn above or below text, often with the p
GroupFillRepresents this fill format should inherit the fill properties of the group.
GroupShapeRepresents the group shape which contains the individual shapes.
HeaderFooterCommandRepresents the command of header/footer
HighlightChangesOptionsRepresents options of highlighting revsions or changes of shared Excel files.
HorizontalPageBreakEncapsulates the object that represents a horizontal page break.
HorizontalPageBreakCollectionEncapsulates a collection of HorizontalPageBreak objects.
HtmlLoadOptionsRepresents options when importing a html file.
HtmlSaveOptionsRepresents the options for saving html file.
HtmlTableLoadOptionRepresents the option when import table from html.
HtmlTableLoadOptionCollectionRepresents the table options when importing html.
HyperlinkEncapsulates the object that represents a hyperlink.
HyperlinkCollectionEncapsulates a collection of Hyperlink objects.
IconFilterRepresents icon filter.
IconSetDescribe the IconSet conditional formatting rule. This conditional formatting rule applies icons to cells according to t
ImageActiveXControlRepresents the image control.
ImageFormatSpecifies the file format of the image.
ImageOrPrintOptionsAllows to specify options when rendering worksheet to images, printing worksheet or rendering chart to image.
ImageSaveOptionsRepresents image save options. For advanced usage, please use WorkbookRender or SheetRender.
IndividualFontConfigsFont configs for each Workbook object.
InsertOptionsRepresents the options of inserting.
JsonLayoutOptionsRepresents the options of json layout type.
JsonLoadOptionsRepresents the options of loading json files
JsonSaveOptionsRepresents the options of saving the workbook as a json file.
JsonUtilityRepresents the utility class of processing json.
LabelEncapsulates the object that represents a label in a spreadsheet.
LabelActiveXControlRepresents the label ActiveX control.
LegendEncapsulates the object that represents the chart legend.
LegendEntryRepresents a legend entry in a chart legend.
LegendEntryCollectionRepresents a collection of all the LegendEntry objects in the specified chart legend.
LicenseProvides methods to license the component.
LimLowUppEquationNode
LineEncapsulates the object that represents the line format.
LineFormatRepresents all setting of the line.
LineShapeRepresents the line shape.
ListBoxRepresents a list box object.
ListBoxActiveXControlRepresents a ListBox ActiveX control.
ListColumnRepresents a column in a Table.
ListColumnCollectionRepresents A collection of all the ListColumn objects in the specified ListObject object.
ListObjectRepresents a list object on a worksheet. The ListObject object is a member of the ListObjects collection. The ListObject
ListObjectCollectionRepresents a collection of ListObject objects in the worksheet.
LoadFilterRepresents the filter that provides options for loading data when loading workbook from template. User may specify the f
LoadOptionsRepresents the options of loading the file.
MarkdownLoadOptionsRepresents the options for loading markdown document.
MarkdownSaveOptionsRepresents the save options for markdown.
MarkerRepresents the marker in a line chart, scatter chart, or radar chart.
MathematicalEquationNodeThis class specifies an equation or mathematical expression. All mathematical text of equations or mathematical expressi
MatrixEquationNodeThis class specifies the Matrix equation, consisting of one or more elements laid out in one or more rows and one or mor
MemoryFontSourceRepresents the single TrueType font file stored in memory.
MetadataOptionsRepresents the options of loading metadata of the file.
MeteredProvides methods to set metered key.
MsoFillFormatRepresents fill formatting for a shape.
MsoFillFormatHelperRepresents fill formatting for a shape.
MsoFormatPictureRepresents the picture format.
MsoLineFormatRepresents line and arrowhead formatting.
MsoLineFormatHelperRepresents line and arrowhead formatting.
MsoTextFrameRepresents the text frame in a Shape object.
MultipleFilterCollectionRepresents the multiple filter collection.
NameRepresents a defined name for a range of cells.
NameCollectionRepresents a collection of all the Name objects in the spreadsheet.
NaryEquationNodeThis class specifies an n-ary operator equation consisting of an n-ary operator, a base (or operand), and optional upper
NegativeBarFormatRepresents the color settings of the data bars for negative values that are defined by a data bar conditional formatting
NoneBulletValueRepresents no bullet.
NoneFillRepresents no fill.
NumbersLoadOptionsRepresents the options of loading Apple Numbers files.
OdsCellFieldRepresents the cell field of ods.
OdsCellFieldCollectionRepresents the fields of ODS.
OdsLoadOptionsRepresents the options of loading ods file.
OdsPageBackgroundRepresents the page background of ods.
OdsSaveOptionsRepresents the options of saving ods file.
OfdSaveOptions
OleObjectRepresents an OleObject in a worksheet.
OleObjectCollectionRepresents embedded OLE objects.
OoxmlSaveOptionsRepresents the options of saving office open xml file.
OutlineRepresents an outline on a worksheet.
OvalRepresents the oval shape.
PageEndSavingArgsInfo for a page ends saving process.
PageSavingArgsInfo for a page saving process.
PageSetupEncapsulates the object that represents the page setup description. The PageSetup object contains all page setup options
PageStartSavingArgsInfo for a page starts saving process.
PaginatedSaveOptionsRepresents the options for pagination.
PaneCollectionRepresents all Pane objects shown in the specified window.
PasteOptionsRepresents the paste special options.
PatternFillEncapsulates the object that represents pattern fill format
PclSaveOptions
PdfBookmarkEntryPdfBookmarkEntry is an entry in pdf bookmark. if Text property of current instance is null or “”, current instance will
PdfSaveOptionsRepresents the options for saving pdf file.
PdfSecurityOptionsOptions for encrypting and access permissions for a PDF document. PDF/A does not allow security setting.
PicFormatOptionRepresents picture format option
PictureEncapsulates the object that represents a single picture in a spreadsheet.
PictureBulletValueRepresents the value of the image bullet.
PictureCollectionEncapsulates a collection of Picture objects.
PivotAreaPresents the selected area of the PivotTable.
PivotAreaCollection
PivotAreaFilterRepresents the filter of PivotArea for PivotTable.
PivotAreaFilterCollectionRepresents the list of filters for PivotArea
PivotCacheRepresents the memory cache for a PivotTable report.
PivotCacheCollectionRepresents the collection of memory caches from the PivotTable reports in a workbook.
PivotConditionalFormat
PivotConditionalFormatCollection
PivotDateTimeRangeGroupSettingsRepresents the field grouped by date time range.
PivotDiscreteGroupSettingsRrepsents the discrete group of pivot field
PivotFieldRepresents a field in a PivotTable report.
PivotFieldCollectionRepresents a collection of all the PivotField objects in the PivotTable’s specific PivotFields type.
PivotFieldGroupSettingsRepresents the group setting of pivot field.
PivotFieldSortSetting
PivotFilterRepresents a PivotFilter in PivotFilter Collection.
PivotFilterCollectionRepresents a collection of all the PivotFilter objects
PivotFormatConditionRepresents a PivotTable Format Condition in PivotFormatCondition Collection.
PivotFormatConditionCollectionRepresents PivotTable Format Conditions.
PivotGlobalizationSettingsRepresents the globalization settings for pivot tables.
PivotItemRepresents a item in a PivotField report.
PivotItemCollectionRepresents a collection of all the PivotItem objects in the PivotField’s
PivotNumbericRangeGroupSettingsRepresents the numberic range group of the pivot field.
PivotOptionsRepresents a complex type that specifies the pivot controls that appear on the chart
PivotPageFieldsRepresents the pivot page field items if the pivot table data source is consolidation ranges. It only can contain up to
PivotShowValuesSettingRepresents the settings about showing values as when the ShowDataAs calculation is in use.
PivotTableSummary description for PivotTable.
PivotTableCalculateOption
PivotTableCollectionRepresents the collection of all the PivotTable objects on the specified worksheet.
PivotTableFormatRepresents the format defined in the PivotTable.
PivotTableFormatCollectionRepresents the collection of formats applied to PivotTable.
PivotTableRefreshOptionRepresents the options of refreshing data source of the pivot table.
PlotAreaEncapsulates the object that represents the plot area in a chart.
PowerQueryFormulaRepresents the definition of power query formula.
PowerQueryFormulaCollectionRepresents all power query formulas in the mashup data.
PowerQueryFormulaFunctionRepresents the function of power query.
PowerQueryFormulaItemRepresents the item of the power query formula.
PowerQueryFormulaItemCollectionRepresents all item of the power query formula.
PowerQueryFormulaParameterRepresents the parameter of power query formula.
PowerQueryFormulaParameterCollectionRepresents the parameters of power query formula.
PptxSaveOptionsRepresents the pptx save options.
ProtectedRangeA specified range to be allowed to edit when the sheet protection is ON.
ProtectedRangeCollectionEncapsulates a collection of ProtectedRange objects.
ProtectionRepresents the various types of protection options available for a worksheet.
QueryTableRepresents QueryTable information.
QueryTableCollectionA collection of QueryTableCollection objects that represent QueryTable collection information.
RadicalEquationNodeThis class specifies the radical equation, consisting of an optional degree deg(EquationNodeType.Degree) and a base.
RadioButtonRepresents a radio button.
RadioButtonActiveXControlRepresents a RadioButton ActiveX control.
RangeEncapsulates the object that represents a range of cells within a spreadsheet. The Range class denotes a region of Excel
RangeCollectionEncapsulates a collection of Range objects.
RectangleShapeRepresents the rectangle shape.
ReferredAreaRepresents a referred area by the formula.
ReferredAreaCollectionRepresents all referred cells and areas.
ReflectionEffectThis class specifies a reflection effect.
RenderingFontFont for rendering.
RenderingWatermarkWatermark for rendering.
ReplaceOptionsRepresent the replace options.
RevisionRepresents the revision.
RevisionAutoFormatrepresents a revision record of information about a formatting change.
RevisionCellChangeRepresents the revision that changing cells.
RevisionCellCommentRepresents a revision record of a cell comment change.
RevisionCellMoveRepresents a revision record on a cell(s) that moved.
RevisionCollectionRepresents all revision logs.
RevisionCustomViewRepresents a revision record of adding or removing a custom view to the workbook
RevisionDefinedNameRepresents a revision record of a defined name change.
RevisionFormatRepresents a revision record of information about a formatting change.
RevisionHeaderRepresents a list of specific changes that have taken place for this workbook.
RevisionInsertDeleteRepresents a revision record of a row/column insert/delete action.
RevisionInsertSheetRepresents a revision record of a sheet that was inserted.
RevisionLogRepresents the revision log.
RevisionLogCollectionRepresents all revision logs.
RevisionMergeConflictRepresents a revision record which indicates that there was a merge conflict.
RevisionQueryTableRepresents a revision of a query table field change.
RevisionRenameSheetRepresents a revision of renaming sheet.
RowRepresents a single row in a worksheet.
RowCollectionCollects the Row objects that represent the individual rows in a worksheet.
SaveOptionsRepresents all save options
ScenarioRepresents an individual scenario.
ScenarioCollectionRepresents the list of scenarios.
ScenarioInputCellRepresents input cell for the scenario.
ScenarioInputCellCollectionRepresents the list of the scenario’s input cells.
ScrollBarRepresents a scroll bar object. Scroll value must be between 0 and 30000.
ScrollBarActiveXControlRepresents the ScrollBar control.
SeriesEncapsulates the object that represents a single data series in a chart.
SeriesCollectionEncapsulates a collection of Series objects.
SeriesLayoutPropertiesRepresents the properties of series layout.
SettableChartGlobalizationSettingsImplementation of PivotGlobalizationSettings that supports user to set/change pre-defined texts.
SettableGlobalizationSettingsImplementation of GlobalizationSettings that supports user to set/change pre-defined texts.
SettablePivotGlobalizationSettingsImplementation of PivotGlobalizationSettings that supports user to set/change pre-defined texts.
ShadowEffectThis class specifies the shadow effect of the chart element or shape.
ShapeRepresents the msodrawing object.
ShapeCollectionRepresents all the shape in a worksheet/chart.
ShapeGuideEncapsulates a shape guide specifies the presence of a shape guide that will be used to govern the geometry of the speci
ShapeGuideCollectionEncapsulates a collection of shape guide
ShapePathRepresents a creation path consisting of a series of moves, lines and curves that when combined will form a geometric sh
ShapePathCollectionRepresents path collection information in NotPrimitive autoshape
ShapePathPointRepresents an x-y coordinate within the path coordinate space.
ShapePathPointCollectionRepresents all shape path points.
ShapePropertyCollectionThis class specifies the visual shape properties for a chart element or shape.
ShapeSegmentPathRepresents a segment path in a path of the freeform.
ShapeSegmentPathCollectionRepresents a creation path consisting of a series of moves, lines and curves that when combined will form a geometric sh
ShapeTextAlignmentRepresents the setting of shape’s text alignment;
SheetPrintingPreviewWorksheet printing preview.
SheetRenderRepresents a worksheet render which can render worksheet to various images such as (BMP, PNG, JPEG, TIFF..) The construc
SheetSetDescribes a set of sheets.
SignatureLineRepresent the signature line.
Slicersummary description of Slicer View
SlicerCachesummary description of slicer cache
SlicerCacheItemRepresent slicer data source item
SlicerCacheItemCollectionRepresent the collection of SlicerCacheItem
SlicerCollectionSpecifies the collection of all the Slicer objects on the specified worksheet.
SlicerShapeRepresents the slicer msodrawing object.
SmartArtShapeRepresents the smart art.
SmartTagRepresents a smart tag.
SmartTagCollectionRepresents all smart tags in the cell.
SmartTagOptionsRepresents the options of the smart tag.
SmartTagPropertyRepresents the property of the cell smart tag.
SmartTagPropertyCollectionRepresents all properties of cell smart tag.
SmartTagSettingRepresents all SmartTagCollection object in the worksheet.
SolidFillEncapsulates the object that represents solid fill format
SparklineA sparkline represents a tiny chart or graphic in a worksheet cell that provides a visual representation of data.
SparklineCollectionEncapsulates a collection of Sparkline objects.
SparklineGroupSparkline is organized into sparkline group. A SparklineGroup contains a variable number of sparkline items. A sparkline
SparklineGroupCollectionEncapsulates a collection of SparklineGroup objects.
SpinButtonActiveXControlRepresents the SpinButton control.
SpinnerRepresents the Forms control: Spinner. Scroll value must be between 0 and 30000.
SpreadsheetML2003SaveOptionsRepresents the options for saving Excel 2003 spreadml file.
SqlScriptColumnTypeMapRepresents column type map.
SqlScriptSaveOptionsRepresents the options of saving sql.
StyleRepresents display style of excel document,such as font,color,alignment,border,etc. The Style object contains all style
StyleFlagRepresents flags which indicates applied formatting properties.
SubSupEquationNodeThis class specifies an equation that can optionally be superscript or subscript. There are four main forms of this equa
SubtotalSettingRepresents the setting of the subtotal .
SvgImageOptions
SvgSaveOptionsRepresents Svg save options. For advanced usage, please use WorkbookRender or SheetRender. NOTE: This class is now obsol
SxRngRepresents Group Range in a PivotField. NOTE: This class is now obsolete. Instead, please use PivotFieldGroupSettings cl
SystemTimeInterruptMonitorSimple implementation of AbstractInterruptMonitor by checking and comparing current system time with user specified limi
TableStyleRepresents the table style.
TableStyleCollectionRepresents all custom table styles.
TableStyleElementRepresents the element of the table style.
TableStyleElementCollectionRepresents all elements of the table style.
TableToRangeOptionsRepresents the options when converting table to range.
TextBoxEncapsulates the object that represents a textbox in a spreadsheet.
TextBoxActiveXControlRepresents a text box ActiveX control.
TextBoxCollectionEncapsulates a collection of TextBox objects.
TextBoxOptions
TextEffectFormatContains properties and methods that apply to WordArt objects.
TextOptionsRepresents the text options.
TextParagraphRepresents the text paragraph setting.
TextParagraphCollectionRepresents all text paragraph.
TextRunEquationNodeThis class in the equation node is used to store the actual content(a sequence of mathematical text) of the equation. Us
TextTabStopRepresents tab stop.
TextTabStopCollectionRepresents the list of all tab stops.
TextureFillEncapsulates the object that represents texture fill format
ThemeColorRepresents a theme color.
ThreadInterruptMonitorSimple implementation of AbstractInterruptMonitor by starting another thread to require the interruption after sleeping
ThreadedCommentRepresents the threaded comment.
ThreadedCommentAuthorRepresents the person who creates the threaded comments;
ThreadedCommentAuthorCollectionRepresents all persons who .
ThreadedCommentCollectionRepresents the list of threaded comments.
ThreeDFormatRepresents a shape’s three-dimensional formatting.
TickLabelItemRepresents a tick label in the chart.
TickLabelsRepresents the tick-mark labels associated with tick marks on a chart axis.
TilePicOptionRepresents tile picture as texture.
TimelineSummary description of Timeline View Due to MS Excel, Excel 2003 does not support Timeline
TimelineCollectionSpecifies the collection of all the Timeline objects on the specified worksheet. Due to MS Excel, Excel 2003 does not su
TimelineShapeRepresents the Timeline msodrawing object.
TitleEncapsulates the object that represents the title of chart or axis.
ToggleButtonActiveXControlRepresents a ToggleButton ActiveX control.
Top10Describe the Top10 conditional formatting rule. This conditional formatting rule highlights cells whose values fall in t
Top10FilterRepresents the top 10 filter.
TrendlineRepresents a trendline in a chart.
TrendlineCollectionRepresents a collection of all the Trendline objects for the specified data series.
TwoColorGradientRepresents two color gradient.
TxtLoadOptionsRepresents the options for loading text file.
TxtSaveOptionsRepresents the save options for csv/tab delimited/other text format.
UnionRangeRepresents union range.
UnknowEquationNodeEquation node class of unknown type
UnknownControlUnknow control.
ValidationRepresents data validation.settings.
ValidationCollectionRepresents data validation collection.
VbaModuleRepresents the module in VBA project.
VbaModuleCollectionRepresents the list of VbaModule
VbaProjectRepresents the VBA project.
VbaProjectReferenceRepresents the reference of VBA project.
VbaProjectReferenceCollectionRepresents all references of VBA project.
VerticalPageBreakEncapsulates the object that represents a vertical page break.
VerticalPageBreakCollectionEncapsulates a collection of VerticalPageBreak objects.
VmlShapeGuidejust for vml Encapsulates a shape guide specifies the presence of a shape guide that will be used to govern the geometry
WallsEncapsulates the object that represents the walls of a 3-D chart.
WebExtensionRepresents an Office Add-in instance.
WebExtensionBindingRepresents a binding relationship between an Office Add-in and the data in the document.
WebExtensionBindingCollectionRepresents the list of binding relationships between an Office Add-in and the data in the document.
WebExtensionCollectionRepresents the list of web extension.
WebExtensionPropertyRepresents an Office Add-in custom property.
WebExtensionPropertyCollectionRepresents the list of web extension properties.
WebExtensionReferenceRepresents identify the provider location and version of the extension.
WebExtensionReferenceCollectionRepresents the list of web extension reference.
WebExtensionShapeRepresents the shape of web extension.
WebExtensionTaskPaneRepresents a persisted taskpane object.
WebExtensionTaskPaneCollectionRepresents the list of task pane.
WebQueryConnectionSpecifies the properties for a web query source. A web query will retrieve data from HTML tables, and can also supply HT
WorkbookRepresents a root object to create an Excel spreadsheet. The Workbook class denotes an Excel spreadsheet. Each spreadshe
WorkbookDesignerEncapsulates the object that represents a designer spreadsheet.
WorkbookMetadataRepresents the meta data.
WorkbookPrintingPreviewWorkbook printing preview.
WorkbookRenderRepresents a Workbook render. The constructor of this class , must be used after modification of pagesetup, cell style.
WorkbookSettingsRepresents all settings of the workbook.
WorksheetEncapsulates the object that represents a single worksheet.
WorksheetCollectionEncapsulates a collection of Worksheet objects.
WriteProtectionSpecifies write protection settings for a workbook.
XlsSaveOptionsRepresents the save options for the Excel 97-2003 file format: xls and xlt.
XlsbSaveOptionsRepresents the options for saving xlsb file.
XmlDataBindingRepresents Xml Data Binding information.
XmlLoadOptionsRepresents the options of loading xml.
XmlMapRepresents Xml map information.
XmlMapCollectionA collection of XmlMap objects that represent XmlMap information.
XmlSaveOptionsRepresents the options of saving the workbook as an xml file.
XpsSaveOptionsRepresents the additional options when saving the file as the Xps.