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
|
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.
|
Axis |
Encapsulates the object that represents a chart's axis.
|
AxisBins |
Represents axis bins
|
BaseShapeGuide | |
Bevel |
Represents a bevel of a shape
|
Border |
Encapsulates the object that represents the cell border.
|
BorderCollection |
Encapsulates a collection of |
BuiltInDocumentPropertyCollection |
A collection of built-in document properties.
|
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.
|
CellsDrawing |
Represents the auto shape and drawing object.
|
CellsException |
The exception that is thrown when Aspose.Cells specified error occurs.
|
CellsFactory |
Utility for instantiating classes of Cells model.
|
CellsHelper |
Provides helper functions.
|
CellWatch |
Represents Cell Watch Item in the 'watch window'.
|
CellWatchCollection |
Represents the collection of cells on this worksheet being watched in the 'watch window'.
|
Chart |
Encapsulates the object that represents a single Excel chart.
|
ChartArea |
Encapsulates the object that represents the chart area in the worksheet.
|
ChartCollection |
Encapsulates a collection of |
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.
|
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 the color filter.
|
ColorHelper |
Provides helper functions about color.
|
ColorScale |
Describe the ColorScale conditional formatting rule.
This conditional formatting rule creates a gradated color scale on the cells.
|
Column |
Represents a single column in a worksheet.
|
ColumnCollection |
Collection of the objects that represent the individual column(setting)s in a worksheet.
The Column object only represents the settings such as column width, styles, .etc. for the whole column,
has nothing to do with the fact that there are non-empty cells(data) or not in corresponding column.
And the "Count" of this collection only represents the count Column objects that have been instantiated in this collection,
has nothing to do with the fact that there are non-empty cells(data) or not in the worksheet.
|
ComboBox |
Represents the control form ComboBox.
|
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.
|
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.
|
CustomGeometry |
Represents a custom geometric shape.
|
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.
|
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.
|
DefaultStyleSettings |
Settings for the default values of workbook's style properties.
|
DeleteOptions |
Represents the setting of deleting rows/columns.
|
DialogBox |
Represents the dialog box.
|
DifSaveOptions |
Represents the options of saving dif file.
|
DigitalSignature |
Signature in file.
|
DigitalSignatureCollection |
Provides a collection of digital signatures attached to a document.
|
DisplayUnitLabel |
Represents the display unit label.
|
DocumentProperty |
Represents a custom or built-in document property.
|
DocumentPropertyCollection |
Base class for |
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.
|
Encoding |
Represents a character encoding.
|
ErrorBar |
Represents error bar of data series.
|
ErrorCheckOption |
Error check setting applied on certain ranges.
|
ErrorCheckOptionCollection |
Represents all error check option.
|
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.
|
FontSourceBase |
This is an abstract base class for the classes that allow the user to specify various font sources
|
Format3D |
This class specifies the 3D shape properties for a chart element or shape.
|
FormatCondition |
Represents conditional formatting condition.
|
FormatConditionCollection |
Represents conditional formatting.
The FormatConditions can contain up to three conditional formats.
|
FormulaParseOptions |
Represents options when parsing formula.
|
FormulaSettings |
Settings of formulas and calculation.
|
Geometry |
Represents a geometric shape.
|
GlobalizationSettings |
Represents the globalization settings.
|
GlowEffect |
This class specifies a glow effect, in which a color blurred outline
is added outside the edges of the object.
|
GradientFill |
Represents the gradient fill.
|
GradientStop |
Represents the gradient stop.
|
GradientStopCollection |
Represents the gradient stop collection.
|
GroupBox |
Encapsulates the object that represents a groupbox in a spreadsheet.
|
GroupFill |
Represents this fill format should inherit the fill properties of the group.
|
GroupShape |
Represents the group shape which contains the individual shapes.
|
HeaderFooterCommand |
Represents the command of header/footer
|
HorizontalPageBreak |
Encapsulates the object that represents a horizontal page break.
|
HorizontalPageBreakCollection |
Encapsulates a collection of |
HtmlLoadOptions |
Represents options when importing a html file.
|
HtmlSaveOptions |
Represents the options for saving html file.
|
Hyperlink |
Encapsulates the object that represents a hyperlink.
|
HyperlinkCollection |
Encapsulates a collection of |
IconFilter |
Represents icon filter.
|
IconSet |
Describe the IconSet conditional formatting rule.
This conditional formatting rule applies icons to cells
according to their values.
|
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
|
IndividualFontConfigs |
Font configs for each |
InsertOptions |
Represents the options of inserting.
|
JsonLoadOptions |
Represents the options of loading json files
|
JsonSaveOptions |
Represents the options of saving the workbook as a json file.
|
Label |
Encapsulates the object that represents a label in a spreadsheet.
|
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.
|
ListColumn |
Represents a column in a list.
|
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.
|
MemoryFontSource |
Represents the single TrueType font file stored in memory.
|
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 |
NegativeBarFormat |
Represents the color settings of the data bars for negative values that are defined by a data bar conditional formatting rule.
|
NoneFill |
Represents no fill.
|
OdsLoadOptions |
Represents the options of loading ods file.
|
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.
|
PaneCollection |
Represents all Pane objects shown in the specified window.
|
PasteOptions |
Represents the paste special options.
|
PatternFill |
Encapsulates the object that represents pattern fill format
|
PdfBookmarkEntry |
PdfBookmarkEntry is an entry in pdf bookmark.
if Text property of current instance is null or "",
current instance will be hidden and children will be inserted on current level.
|
PdfSaveOptions |
Represents the options for saving pdf file.
|
PdfSecurityOptions |
Settings of pdf when converting excel to pdf, PDF/A does not allow security setting.
|
PicFormatOption |
Represents picture format option
|
Picture |
Encapsulates the object that represents a single picture in a spreadsheet.
|
PictureCollection |
Encapsulates a collection of |
PivotField |
Represents a field in a PivotTable report.
|
PivotFieldCollection |
Represents a collection of all the PivotField objects
in the PivotTable's specific PivotFields type.
|
PivotFilter |
Represents a PivotFilter in PivotFilter Collection.
|
PivotFilterCollection |
Represents a collection of all the PivotFilter objects
|
PivotFormatCondition |
Represents a PivotTable Format Condition in PivotFormatCondition Collection.
|
PivotFormatConditionCollection |
Represents PivotTable Format Conditions.
|
PivotItem |
Represents a item in a PivotField report.
|
PivotItemCollection |
Represents a collection of all the PivotItem objects in the PivotField's
|
PivotOptions |
Represents a complex type that specifies the pivot controls that appear on the chart
|
PivotPageFields |
Represents the pivot page field items
if the pivot table data source is consolidation ranges.
It only can contain up to 4 fields.
|
PivotTable |
Summary description for PivotTable.
|
PivotTableCollection |
Represents the collection of all the PivotTable objects on the specified worksheet.
|
PlotArea |
Encapsulates the object that represents the plot area in a chart.
|
PptxSaveOptions |
Represents the pptx save options.
|
ProtectedRange |
A specified range to be allowed to edit when the sheet protection is ON.
|
ProtectedRangeCollection |
Encapsulates a collection of |
Protection |
Represents the various types of protection options available for a worksheet.
|
QueryTable |
Represents QueryTable information.
|
QueryTableCollection |
A collection of |
RadioButton |
Represents a radio button.
|
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.
|
ReplaceOptions |
Represent the replace options.
|
Row |
Represents a single row in a worksheet.
|
RowCollection |
Collects the objects that represent the individual rows in a worksheet.
|
SaveOptions |
Represents all save options
|
Scenario |
Represents an individual scenario.
|
ScenarioCollection |
Represents the list of scenarios.
|
ScenarioInputCell |
Represents input cell for the scenario.
|
ScenarioInputCellCollection |
Represents the list of the scenario's input cells.
|
ScrollBar |
Represents a scroll bar object.
|
Series |
Encapsulates the object that represents a single data series in a chart.
|
SeriesCollection |
Encapsulates a collection of |
SeriesLayoutProperties | |
ShadowEffect |
This class specifies the shadow effect of the chart element or shape.
|
Shape |
Represents the msodrawing object.
|
ShapeCollection |
Represents all the shape in a worksheet/chart.
|
ShapeFormat |
Represents the format of the shape or text.
|
ShapeGuide |
Encapsulates a shape guide specifies the presence of a shape guide that will be used to
govern the geometry of the specified shape
|
ShapeGuideCollection |
Encapsulates a collection of shape guide
|
ShapePath |
Represents a creation path consisting of a series of moves, lines and curves that when combined will form a geometric shape.
|
ShapePathCollection |
Represents path collection information in NotPrimitive autoshape
|
ShapePathPoint |
Represents an x-y coordinate within the path coordinate space.
|
ShapePathPointCollection |
Represents all shape path points.
|
ShapePropertyCollection |
This class specifies the visual shape properties for a chart element or shape.
|
ShapeSegmentPath |
Represents a segment path in a path of the freeform.
|
ShapeSegmentPathCollection |
Represents a creation path consisting of a series of moves, lines and curves that when combined will form a geometric shape.
|
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.
|
SignatureLine |
Represent the signature line.
|
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.
Example: [C#] Workbook book = new Workbook(); Worksheet sheet = book.Worksheets[0]; sheet.Cells["A1"].PutValue(5); sheet.Cells["B1"].PutValue(2); sheet.Cells["C1"].PutValue(1); sheet.Cells["D1"].PutValue(3); // Define the CellArea CellArea ca = new CellArea(); ca.StartColumn = 4; ca.EndColumn = 4; ca.StartRow = 0; ca.EndRow = 0; int idx = sheet.SparklineGroupCollection.Add(Aspose.Cells.Charts.SparklineType.Line, sheet.Name + "!A1:D1", false, ca); SparklineGroup group = sheet.SparklineGroupCollection[idx]; idx = group.SparklineCollection.Add(sheet.Name + "!A1:D1", 0, 4); Sparkline line = group.SparklineCollection[idx]; Console.WriteLine($"Saprkline data range:{line.DataRange}, row:{line.Row}, column:{line.Column}"); line.ToImage("output.png", new ImageOrPrintOptions()); |
SparklineCollection |
Encapsulates a collection of |
SparklineGroup | |
SparklineGroupCollection |
Encapsulates a collection of |
Spinner |
Represents the Forms control: Spinner.
|
SpreadsheetML2003SaveOptions |
Represents the options for saving Excel 2003 spreadml file.
|
Style |
Represents display style of excel document,such as font,color,alignment,border,etc.
|
StyleFlag |
Represents flags which indicates applied formatting properties.
|
SubtotalSetting |
Represents the setting of the subtotal .
|
SvgSaveOptions |
Represents Svg save options
|
SxRng |
Represents Group Range in a PivotField.
|
TableStyle |
Represents the table style.
|
TableStyleCollection |
Represents all custom table styles.
|
TableStyleElement |
Represents the element of the table style.
|
TableStyleElementCollection |
Represents all elements of the table style.
|
TableToRangeOptions |
Represents the options when converting table to range.
|
TextBox |
Encapsulates the object that represents a textbox in a spreadsheet.
|
TextBoxCollection |
Encapsulates a collection of |
TextEffectFormat |
Contains properties and methods that apply to WordArt objects.
|
TextureFill |
Encapsulates the object that represents texture fill format
|
ThemeColor |
Represents a theme color.
|
ThreadedComment |
Represents the threaded comment.
|
ThreadedCommentAuthor |
Represents the person who creates the threaded comments;
|
ThreadedCommentAuthorCollection |
Represents all persons who .
|
ThreadedCommentCollection |
Represents the list of threaded comments.
|
ThreeDFormat |
Represents a shape's three-dimensional formatting.
|
TickLabelItem |
Include information of a Ticklabel item
|
TickLabels |
Represents the tick-mark labels associated with tick marks on a chart axis.
|
TilePicOption |
Represents tile picture as texture.
|
Title |
Encapsulates the object that represents the title of chart or axis.
|
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 |
TxtLoadOptions |
Represents the options for loading text file.
|
TxtSaveOptions |
Represents the save options for csv/tab delimited/other text format.
|
UnionRange |
Represents union range.
|
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.
|
WebExtensionShape |
Represents the shape of web extension.
|
Workbook |
Represents a root object to create an Excel spreadsheet.
|
WorkbookDesigner |
Encapsulates the object that represents a designer spreadsheet.
|
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.
|
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 type
|
CalcModeType | Utility class containing constants.
Represents the mode type of calculating formulas.
|
CalculationPrecisionStrategy | Utility class containing constants.
Enumerates strategies for handling calculation precision.
Because of the precision issue of IEEE 754 Floating-Point Arithmetic, some "seemingly simple" formulas may not be calculated as the expected result.
Such as formula "=-0.45+0.43+0.02", when calculating operands by '+' operator directly, the result is not zero. For such kind of precision issue,
some special strategies may give the expected result.
|
CategoryType | Utility class containing constants.
Represents the category axis type.
|
CellBorderType | Utility class containing constants.
Enumerates a cell's border type.
|
CellValueFormatStrategy | Utility class containing constants.
Specifies how to apply style for the value of the cell.
|
CellValueType | Utility class containing constants.
Specifies a cell value type.
|
ChartLineFormattingType | Utility class containing constants.
Represents line format type of chart line.
|
ChartMarkerType | Utility class containing constants.
Represents the marker style in a line chart, scatter chart, or radar chart.
|
ChartSplitType | Utility class containing constants.
Represents the way the two sections of either a pie of pie chart or a bar of pie chart are split.
|
ChartTextDirectionType | Utility class containing constants.
Represents the text direction type of the chart.
|
ChartType | Utility class containing constants.
Enumerates all chart types used in Excel.
|
CheckValueType | Utility class containing constants.
Represents the check value type of the check box.
|
ColorDepth | Utility class containing constants.
Enumerates Bit Depth Type for tiff image.
|
ColorType | Utility class containing constants.
Represents all color type
|
CommentTitleType | Utility class containing constants.
Represents comment title type while rendering when comment is set to display at end of sheet.
|
ConsolidationFunction | Utility class containing constants.
Represents consolidation function.
|
CopyFormatType | Utility class containing constants.
Represents type of copying format when inserting rows.
|
CountryCode | Utility class containing constants.
Represents Excel country identifiers.
|
CrossType | Utility class containing constants.
Represents the axis cross type.
|
DataBarAxisPosition | Utility class containing constants.
Specifies the axis position for a range of cells with conditional formatting as data bars.
|
DataBarBorderType | Utility class containing constants.
Specifies the border type of a data bar.
|
DataBarFillType | Utility class containing constants.
Specifies how a data bar is filled with color.
|
DataBarNegativeColorType | Utility class containing constants.
Specifies whether to use the same border and fill color as positive data bars.
|
DataLabelShapeType | Utility class containing constants.
Specifies the preset shape geometry that is to be used for a chart.
|
DataLabelsSeparatorType | Utility class containing constants.
Represents the separator type of DataLabels.
|
DataLablesSeparatorType | Utility class containing constants.
Represents the separator type of DataLabels.
|
DateTimeGroupingType | Utility class containing constants.
Specifies how to group dateTime values.
|
DefaultEditLanguage | Utility class containing constants.
Represents the default edit language.
|
DirectoryType | Utility class containing constants.
Represents the directory type of the file name.
|
DisplayDrawingObjects | Utility class containing constants.
Represents whether and how to show objects in the workbook.
|
DisplayUnitType | Utility class containing constants.
Represents the type of display unit.
|
DynamicFilterType | Utility class containing constants.
Dynamic filter type.
|
EmfRenderSetting | Utility class containing constants.
Setting for rendering Emf metafile.
|
EncryptionType | Utility class containing constants.
Encryption Type.
Only used by excel2003.
We will encrypt 2007/2010 workbook using SHA AES the same as Excel does, and this EncryptionType will be ignored.
|
ErrorBarDisplayType | Utility class containing constants.
Represents error bar display type.
|
ErrorBarType | Utility class containing constants.
Represents error bar amount type.
|
ErrorCheckType | Utility class containing constants.
Represents all error check type.
|
ExceptionType | Utility class containing constants.
Represents custom exception type code.
|
ExternalLinkType | Utility class containing constants.
Represents the type of external link.
|
FileFormatType | Utility class containing constants.
Represents the file format types.
|
FillPattern | Utility class containing constants.
Enumerates shape fill pattern types.
|
FillPictureType | Utility class containing constants.
Represents the picture fill type.
|
FillType | Utility class containing constants.
Fill format type.
|
FilterOperatorType | Utility class containing constants.
Custom Filter operator type.
|
FilterType | Utility class containing constants.
The filter type.
|
FontSchemeType | Utility class containing constants.
Represents the scheme type of the font.
|
FontSourceType | Utility class containing constants.
Specifies the type of a font source.
|
FontUnderlineType | Utility class containing constants.
Enumerates the font underline types.
|
FormatConditionType | Utility class containing constants.
Conditional format rule type.
|
FormatConditionValueType | Utility class containing constants.
Condition value type.
|
FormatSetType | Utility class containing constants.
Fill format set type.
|
FormattingType | |
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.
|
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.
|
ImageType | Utility class containing constants.
Specifies the type (format) of an image.
|
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.
|
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.
|
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.
|
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.
|
OoxmlCompliance | Utility class containing constants.
Allows to specify which OOXML specification will be used when saving in the Xlsx format.
|
OoxmlCompressionType | Utility class containing constants.
The Ooxml compression type
|
OperatorType | Utility class containing constants.
Represents the operator type of conditional format and data validation.
|
PageLayoutAlignmentType | Utility class containing constants.
Enumerates page layout alignment types.
|
PageOrientationType | Utility class containing constants.
Represents print orientation constants.
|
PaneStateType | Utility class containing constants.
Represents state of the sheet's pane.
|
PaperSizeType | Utility class containing constants.
Represents paper size constants.
|
ParameterType | Utility class containing constants.
Represents all parameters' type or return value type of function.
|
PasteOperationType | Utility class containing constants.
Represents operation type when pasting range.
|
PasteType | Utility class containing constants.
Represents the paste special type.
|
PdfCompliance | Utility class containing constants.
Allowing user to set PDF conversion's Compatibility
|
PdfCompressionCore | Utility class containing constants.
Specifies a type of compression applied to all content in the PDF file except images.
|
PdfCustomPropertiesExport | Utility class containing constants.
Specifies the way |
PdfFontEncoding | Utility class containing constants.
Represents pdf embedded font encoding.
|
PdfOptimizationType | Utility class containing constants.
Specifies a type of optimization.
|
PivotConditionFormatRuleType | Utility class containing constants.
Represents PivotTable condition formatting rule type.
|
PivotConditionFormatScopeType | Utility class containing constants.
Represents PivotTable condition formatting scope type.
|
PivotFieldDataDisplayFormat | Utility class containing constants.
Represents data display format in the PivotTable data field.
|
PivotFieldSubtotalType | Utility class containing constants.
Summary description for PivotFieldSubtotalType.
|
PivotFieldType | Utility class containing constants.
Represents PivotTable field type.
|
PivotFilterType | Utility class containing constants.
Represents PivotTable Filter type.
|
PivotGroupByType | Utility class containing constants.
Represents PivotTable groupby type.
|
PivotItemPosition | Utility class containing constants.
Represents PivotTable base item Next/Previous/All position in the base field .
|
PivotMissingItemLimitType | Utility class containing constants.
Represents number of items to retain per field.
|
PivotTableAutoFormatType | Utility class containing constants.
Represents PivotTable auto format type.
|
PivotTableStyleType | Utility class containing constants.
Represents the pivot table style type.
|
PlacementType | Utility class containing constants.
Represents the way the drawing object is attached to the cells below it.
|
PlotDataByType | Utility class containing constants.
Represents the type of data plot by row or column.
|
PlotEmptyCellsType | Utility class containing constants.
Represents all plot empty cells type of a chart.
|
PresetCameraType | Utility class containing constants.
Represent different algorithmic methods for setting all camera properties, including position.
|
PresetMaterialType | Utility class containing constants.
Describes surface appearance of a shape.
|
PresetShadowType | Utility class containing constants.
Represents preset shadow type.
|
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.
|
RectangleAlignmentType | Utility class containing constants.
Represents how to position two rectangles relative to each other.
|
ReflectionEffectType | Utility class containing constants. |
RenameStrategy | Utility class containing constants.
Strategy option for duplicate names of columns.
|
ResourceLoadingType | Utility class containing constants.
Represents how to loading the linked resource.
|
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.
|
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.
|
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.
|
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.
|
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.
|
TextureType | Utility class containing constants.
Represents the preset texture type.
|
ThemeColorType | Utility class containing constants.
Enumerates the theme color types.
|
TickLabelPositionType | Utility class containing constants.
Represents the position type of tick-mark labels on the specified axis.
|
TickMarkType | Utility class containing constants.
Represents the tick mark type for the specified axis.
|
TiffCompression | Utility class containing constants.
Specifies what type of compression to apply when saving images into TIFF format file.
|
TimePeriodType | Utility class containing constants.
Used in a FormatConditionType.TimePeriod conditional formatting rule.
These are dynamic time periods, which change based on
the date the conditional formatting is refreshed / applied.
|
TimeUnit | Utility class containing constants.
Represents the base unit for the category axis.
|
TotalsCalculation | Utility class containing constants.
Determines the type of calculation in the Totals row of the list column.
|
TrendlineType | Utility class containing constants.
Represents the trendline type.
|
TxtLoadStyleStrategy | Utility class containing constants.
Specifies how to apply style for parsed values when converting string value to number or datetime.
|
TxtValueQuoteType | Utility class containing constants.
Specifies the type of using quotation marks for values in text format files.
|
UpdateLinksType | Utility class containing constants.
Represents how to update links to other workbooks when the workbook is opened.
|
ValidationAlertType | Utility class containing constants.
Represents the data validation alert style.
|
ValidationType | Utility class containing constants.
Represents data validation type.
|
VbaModuleType | Utility class containing constants.
Represents the type of VBA module.
|
VbaProjectReferenceType | Utility class containing constants.
Represents the type of VBA project reference.
|
ViewType | Utility class containing constants.
Represents the view type of the worksheet.
|
VisibilityType | Utility class containing constants.
Represents the states for sheet visibility.
|
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).
|