| 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.
|
| 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
|
| AccentEquationNode |
This class specifies an accent equation, consisting of a base component and a combining diacritic.
|
| ActiveXControl |
Represents the ActiveX control.
|
| ActiveXControlBase |
Represents the ActiveX control.
|
| AdvancedFilter |
Represents the settings of advanced filter.
|
| 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 an axis of chart.
|
| AxisBins |
Represents axis bins
|
| BarEquationNode |
This class specifies the bar equation, consisting of a base argument and an overbar or underbar.
|
| BaseShapeGuide |
Represents the shape guide.
|
| Bevel |
Represents a bevel of a shape
|
| Border |
Encapsulates the object that represents the cell border.
|
| BorderBoxEquationNode |
This class specifies the Border Box function, consisting of a border drawn around an equation.
|
| BorderCollection |
Encapsulates a collection of |
| BoxEquationNode |
This class specifies the box function, which is used to group components of an equation.
|
| BuiltInDocumentPropertyCollection |
A collection of built-in document properties.
|
| Bullet |
Represents the bullet points should be applied to a paragraph.
|
| 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 | |
| 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.
|
| CellValue |
Represents the cell value and corresponding type.
|
| 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.
|
| ChartCalculateOptions |
Represents the options for calculating chart.
|
| ChartCollection |
Encapsulates a collection of |
| 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 |
| CollectionBase |
Provides the abstract base class for a strongly typed collection.
|
| Color |
Represents an ARGB (alpha, red, green, blue) color.
|
| ColorFilter |
Represents filtering the range by color.
|
| 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 |
| 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 |
| CommentShape |
Represents the shape of the comment.
|
| ConditionalFormattingCollection |
Encapsulates a collection of |
| ConditionalFormattingIcon |
Represents the custom icon of conditional formatting rule.
|
| ConditionalFormattingIconCollection |
Represents a collection of |
| 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 |
| ContentTypeProperty |
Represents identifier information.
|
| ContentTypePropertyCollection |
A collection of |
| CopyOptions |
Represents the copy options.
|
| CustomDocumentPropertyCollection |
A collection of custom document properties.
|
| CustomFilter |
Represents the custom filter.
|
| CustomFilterCollection |
Represents the custom filters.
|
| CustomFunctionDefinition |
Definition of custom function for calculating with user's custom engine.
|
| CustomGeometry |
Represents a custom geometric shape.
|
| CustomPiovtFieldGroupItem |
Represents an item of custom grouped field.
|
| CustomProperty |
Represents identifier information.
|
| CustomPropertyCollection |
A collection of |
| 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.
|
| DataMashup |
Represents mashup data.
|
| 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.
|
| DeleteBlankOptions |
Represents the setting of deleting blank cells/rows/columns.
|
| DeleteOptions |
Represents the setting of deleting rows/columns.
|
| DelimiterEquationNode |
This class specifies the delimiter equation, consisting of opening and closing delimiters (such as parentheses, braces, brackets, and vertical bars), and a component contained inside.
The delimiter may have more than one component, with a designated separator character between each component.
|
| 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 |
| DocxSaveOptions |
Represents options of saving .docx file.
|
| DropBars |
Represents the up/down bars in a chart.
|
| DxfCollection |
Represents the master differential formatting records.
|
| DynamicFilter |
Represents the dynamic filter.
|
| EbookLoadOptions |
Represents options when importing an ebook file.
|
| EbookSaveOptions |
Represents the options for saving ebook file.
|
| Encoding |
Represents a character encoding.
|
| EquationComponentNode |
This class specifies the components of an equation or mathematical expression.
Different types of components combined into different equations.
For example, a fraction consists of two parts, a numerator component and a denominator component.
For more component types, please refer to 'EquationNodeType'.
|
| EquationNode |
Abstract class for deriving other equation nodes.
|
| EquationNodeParagraph |
This class specifies a mathematical paragraph containing one or more MathEquationNode(OMath) elements.
|
| ErrorBar |
Represents error bar of data series.
|
| ErrorCheckOption |
Error check setting applied on certain ranges.
|
| ErrorCheckOptionCollection |
Represents all error check option.
|
| ExportRangeToJsonOptions |
Indicates the options that exporting range to json.
|
| ExternalConnection |
Specifies an external data connection
|
| ExternalConnectionCollection |
Specifies the |
| 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 |
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 |
| 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.
|
| FractionEquationNode |
This class specifies the fraction equation, consisting of a numerator and denominator separated by a fraction bar. The fraction bar can be horizontal or diagonal, depending on the fraction properties. The fraction equation is also used to represent the stack function, which places one element above another, with no fraction bar.
|
| FunctionEquationNode |
This class specifies the Function-Apply equation, which consists of a function name and an argument acted upon.
The types of the name and argument components are 'EquationNodeType.FunctionName' and 'EquationNodeType.Base' respectively.
|
| 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.
|
| GroupCharacterEquationNode |
This class specifies the Group-Character function, consisting of a character drawn above or below text, often with the purpose of visually grouping items.
|
| 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
|
| HighlightChangesOptions |
Represents options of highlighting revsions or changes of shared Excel files.
|
| HorizontalPageBreak |
Encapsulates the object that represents a horizontal page break.
|
| HorizontalPageBreakCollection |
Encapsulates a collection of |
| HtmlLoadOptions |
Represents options when importing a html file.
|
| HtmlSaveOptions |
Represents the options for saving html file.
|
| HtmlTableLoadOption |
Represents the option when import table from html.
|
| HtmlTableLoadOptionCollection |
Represents the table options when importing html.
|
| Hyperlink |
Encapsulates the object that represents a hyperlink.
|
| HyperlinkCollection |
Encapsulates a collection of |
| 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 |
| IndividualFontConfigs |
Font configs for each |
| InsertOptions |
Represents the options of inserting.
|
| 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 |
| 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 Table.
|
| ListColumnCollection |
Represents A collection of all the |
| 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 |
| 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.
|
| MathematicalEquationNode |
This class specifies an equation or mathematical expression. All mathematical text of equations or mathematical expressions are contained by this class.
|
| MatrixEquationNode |
This class specifies the Matrix equation, consisting of one or more elements laid out in one or more rows and one or more columns.
|
| 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 |
| NaryEquationNode |
This class specifies an n-ary operator equation consisting of an n-ary operator, a base (or operand), and optional upper and lower bounds.
|
| 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 |
Options for encrypting and access permissions for a PDF document.
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 |
| PivotArea |
Presents the selected area of the PivotTable.
|
| PivotAreaFilter |
Represents the filter of |
| PivotAreaFilterCollection |
Represents the list of filters for |
| PivotDateTimeRangeGroupSettings |
Represents the field grouped by date time range.
|
| PivotDiscreteGroupSettings |
Rrepsents the discrete group of pivot field
|
| PivotField |
Represents a field in a PivotTable report.
|
| PivotFieldCollection |
Represents a collection of all the PivotField objects
in the PivotTable's specific PivotFields type.
|
| PivotFieldGroupSettings |
Represents the group setting of pivot field.
|
| 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.
|
| PivotGlobalizationSettings |
Represents the globalization settings for pivot tables.
|
| PivotItem |
Represents a item in a PivotField report.
|
| PivotItemCollection |
Represents a collection of all the PivotItem objects in the PivotField's
|
| PivotNumbericRangeGroupSettings |
Represents the numberic range group of the pivot field.
|
| 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.
|
| PivotShowValuesSetting |
Represents the settings about showing values as when the ShowDataAs calculation is in use.
|
| PivotTable |
Summary description for PivotTable.
|
| PivotTableCollection |
Represents the collection of all the PivotTable objects on the specified worksheet.
|
| PivotTableFormat |
Represents the format defined in the PivotTable.
|
| PivotTableFormatCollection |
Represents the collection of formats applied to PivotTable.
|
| PivotTableRefreshOption |
Represents the options of refreshing data source of the pivot table.
|
| PlotArea |
Encapsulates the object that represents the plot area in a chart.
|
| PowerQueryFormula |
Represents the definition of power query formula.
|
| PowerQueryFormulaCollection |
Represents all power query formulas in the mashup data.
|
| PowerQueryFormulaFunction |
Represents the function of power query.
|
| PowerQueryFormulaItem |
Represents the item of the power query formula.
|
| PowerQueryFormulaItemCollection |
Represents all item of the power query formula.
|
| PowerQueryFormulaParameter |
Represents the parameter of power query formula.
|
| PowerQueryFormulaParameterCollection |
Represents the parameters of power query formula.
|
| 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 |
| Protection |
Represents the various types of protection options available for a worksheet.
|
| QueryTable |
Represents QueryTable information.
|
| QueryTableCollection |
A collection of |
| RadicalEquationNode |
This class specifies the radical equation, consisting of an optional degree deg(EquationNodeType.Degree) and a base.
|
| 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 |
| 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.
|
| RenderingFont |
Font for rendering.
|
| RenderingWatermark |
Watermark for rendering.
|
| 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.
|
| RevisionHeader |
Represents a list of specific changes that have taken place for this workbook.
|
| 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 |
| 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 |
| SeriesLayoutProperties |
Represents the properties of series layout.
|
| SettableChartGlobalizationSettings |
Implementation of PivotGlobalizationSettings that supports user to set/change pre-defined texts.
|
| SettableGlobalizationSettings |
Implementation of GlobalizationSettings that supports user to set/change pre-defined texts.
|
| SettablePivotGlobalizationSettings |
Implementation of PivotGlobalizationSettings that supports user to set/change pre-defined texts.
|
| 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.
|
| 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 |
| 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 |
| SparklineGroup | |
| SparklineGroupCollection |
Encapsulates a collection of |
| SpinButtonActiveXControl |
Represents the SpinButton control.
|
| Spinner |
Represents the Forms control: Spinner.
|
| SpreadsheetML2003SaveOptions |
Represents the options for saving Excel 2003 spreadml file.
|
| SqlScriptColumnTypeMap |
Represents column type map.
|
| SqlScriptSaveOptions |
Represents the options of saving sql.
|
| 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.
|
| SubSupEquationNode |
This class specifies an equation that can optionally be superscript or subscript.
There are four main forms of this equation, superscript，subscript，superscript and subscript placed to the left of the base, superscript and subscript placed to the right of the base.
|
| SubtotalSetting |
Represents the setting of the subtotal .
|
| SvgSaveOptions |
Represents Svg save options.
For advanced usage, please use |
| SxRng |
Represents Group Range in a PivotField.
|
| SystemTimeInterruptMonitor |
Simple implementation of |
| 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 |
| 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.
|
| TextRunEquationNode |
This class in the equation node is used to store the actual content(a sequence of mathematical text) of the equation.
Usually a node object per character.
|
| 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.
|
| ThreadInterruptMonitor |
Simple implementation of |
| ThreeDFormat |
Represents a shape's three-dimensional formatting.
|
| TickLabelItem |
Represents a tick label in the chart.
|
| 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 |
| TwoColorGradient |
Represents two color gradient.
|
| TxtLoadOptions |
Represents the options for loading text file.
|
| TxtSaveOptions |
Represents the save options for csv/tab delimited/other text format.
|
| UnionRange |
Represents union range.
|
| UnknowEquationNode |
Equation node class of unknown type
|
| 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 |
| 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 |
| 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.
|
| 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 |
| 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 |
| XmlSaveOptions |
Represents the options of saving the workbook as an xml file.
|
| XpsSaveOptions |
Represents the additional options when saving the file as the Xps.
|
| Constant Summary | |
|---|---|
| AccessCacheOptions | Utility class containing constants.
Cache options for data access. Can be combined with | operator for multiple options together.
|
| AdjustFontSizeForRowType | Utility class containing constants.
Represents which kind of rows should be ajusted.
|
| 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.
|
| CellsUnitType | Utility class containing constants.
Specifies the unit of measurement.
|
| 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.
|
| 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.
|
| 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 of chart's axis.
|
| 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.
|
| EquationCharacterPositionType | Utility class containing constants.
Specifies the position of a particular subobject within its parent
|
| EquationCombiningCharacterType | Utility class containing constants.
Type of combining characters.
|
| EquationDelimiterShapeType | Utility class containing constants.
This specifies the shape of delimiters in the delimiter object.
|
| EquationFractionType | Utility class containing constants.
This specifies the display style of the fraction bar.
|
| EquationHorizontalJustificationType | Utility class containing constants.
This specifies the default horizontal justification of equations in the document.
|
| EquationLimitLocationType | Utility class containing constants.
Specifies the limit location on an operator.
|
| EquationMathematicalOperatorType | Utility class containing constants.
Mathematical Operators Type
|
| EquationNodeType | Utility class containing constants.
Equation node type.
Notice:
(1)[1-99] Currently there is only one node in the scope, and its enumeration value is 1. The node it specifies is used to store mathematical text.
(2)[100-199] Indicates that the node is a component of some special function nodes.
(3)[200-] Indicates that the node has some special functions(Usually with 'Equation' suffix. 'EquationParagraph' is a special case.).
|
| EquationVerticalJustificationType | Utility class containing constants.
This specifies the default vertical justification of equations in the document.
|
| 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 | |
| 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 | |
| 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.
|
| ImageBinarizationMethod | Utility class containing constants.
Specifies the method used to binarize image.
|
| 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.
|
| JsonExportHyperlinkType | Utility class containing constants.
Represents type of exporting hyperlinks to json.
|
| 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 | |
| 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.
|
| MergeEmptyTdType | Utility class containing constants.
Represents the merge type for empty TD element when exporting file to html.
|
| 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
|
| OpenDocumentFormatVersionType | Utility class containing constants.
Open Document Format version 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 |
| PdfFontEncoding | Utility class containing constants.
Represents pdf embedded font encoding.
|
| PdfOptimizationType | Utility class containing constants.
Specifies a type of optimization.
|
| PivotAreaType | Utility class containing constants.
Indicates the type of rule being used to describe an area or aspect of the PivotTable.
|
| 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.
|
| PivotFieldGroupType | Utility class containing constants.
Represents the group type of pivot 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 group by type.
|
| PivotItemPosition | Utility class containing constants.
Represents PivotTable base item Next/Previous/All position in the base field .
|
| PivotItemPositionType | Utility class containing constants.
Represents the position type of the pivot base item in the base field when the ShowDataAs calculation is in use.
|
| PivotMissingItemLimitType | Utility class containing constants.
Represents number of items to retain per field.
|
| PivotTableAutoFormatType | Utility class containing constants.
Represents PivotTable auto format type.
|
| PivotTableSelectionType | Utility class containing constants.
Specifies what can be selected in a PivotTable during a structured selection.
These constants can be combined to select multiple types.
|
| 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.
|
| ReserveMissingPivotItemType | Utility class containing constants.
Represents how to keep the missing pivot items.
|
| 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
|
| SlideViewType | Utility class containing constants.
Represents the type when exporting to slides.
|
| 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.
|
| SqlScriptOperatorType | Utility class containing constants.
Represents the type of operating data.
|
| 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.
|
| TickLabelAlignmentType | Utility class containing constants.
Represents the text alignment type for the tick labels on the axis
|
| 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.
|
| 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).
|