aspose.cells

Package aspose.cells

Class Summary
AboveAverage
Describe the AboveAverage conditional formatting rule. This conditional formatting rule highlights cells that are above or below the average for all values in the range.
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 Border objects.
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
Encapsulates a collection of cell relevant objects, such as Cell, Row, ...etc.
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 Chart objects.
ChartDataTable
Represents a chart data table.
ChartFrame
Encapsulates the object that represents the frame object in a chart.
ChartGlobalizationSettings
Represents the globalization settings for chart.
ChartPoint
Represents a single point in a series in a chart.
ChartPointCollection
Represents a collection that contains all the points in one series.
ChartShape
Represents the shape of the chart. Properties and methods for the ChartObject object control the appearance and size of the embedded chart on the worksheet.
ChartTextFrame
Encapsulates the object that represents the frame object which contains text.
CheckBox
Represents a check box object in a worksheet.
CheckBoxCollection
Represents a collection of CheckBox objects in a worksheet.
CollectionBase
Provides the abstract base class for a strongly typed collection.
Color
Represents an ARGB (alpha, red, green, blue) color.
ColorFilter
Represents the color filter.
ColorHelper
Provides helper functions about color.
ColorScale
Describe the ColorScale conditional formatting rule. This conditional formatting rule creates a gradated color scale on the cells.
Column
Represents a single column in a worksheet.
ColumnCollection
Collection of the objects that represent the individual column(setting)s in a worksheet. The Column object only represents the settings such as column width, styles, .etc. for the whole column, has nothing to do with the fact that there are non-empty cells(data) or not in corresponding column. And the "Count" of this collection only represents the count Column objects that have been instantiated in this collection, has nothing to do with the fact that there are non-empty cells(data) or not in the worksheet.
ComboBox
Represents the control form ComboBox.
Comment
Encapsulates the object that represents a cell comment.
CommentCollection
Encapsulates a collection of Comment objects.
CommentShape
Represents the shape of the comment.
ConditionalFormattingCollection
Encapsulates a collection of FormatCondition objects.
ConditionalFormattingIcon
Represents the custom icon of conditional formatting rule.
ConditionalFormattingIconCollection
Represents a collection of ConditionalFormattingIcon objects.
ConditionalFormattingResult
Represents the result of conditional formatting which applies to a cell.
ConditionalFormattingValue
Describes the values of the interpolation points in a gradient scale, dataBar or iconSet.
ConditionalFormattingValueCollection
Describes a collection of CFValueObject. Use only for icon sets.
ContentTypeProperty
Represents identifier information.
ContentTypePropertyCollection
A collection of ContentTypeProperty objects that represent additional information.
CopyOptions
Represents the copy options.
CustomDocumentPropertyCollection
A collection of custom document properties.
CustomFilter
Represents the custom filter.
CustomFilterCollection
Represents the custom filters.
CustomGeometry
Represents a custom geometric shape.
CustomProperty
Represents identifier information.
CustomPropertyCollection
A collection of CustomProperty objects that represent additional information.
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
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 file format detection methods.
FileFormatUtil
Provides utility methods for converting file format enums to strings or file extensions and back.
Fill
Represents the fill format of the shape.
FillFormat
Encapsulates the object that represents fill formatting for a shape.
FilterColumn
Represents a filter for a single column. The Filter object is a member of the Filters collection
FilterColumnCollection
A collection of Filter objects that represents all the filters in an autofiltered range.
FindOptions
Represents find options.
Floor
Encapsulates the object that represents the floor of a 3-D chart.
FolderFontSource
Represents the folder that contains TrueType font files.
Font
Encapsulates the font object used in a spreadsheet.
FontConfigs
Specifies font settings
FontSetting
Represents a range of characters within the cell text.
FontSourceBase
This is an abstract base class for the classes that allow the user to specify various font sources
Format3D
This class specifies the 3D shape properties for a chart element or shape.
FormatCondition
Represents conditional formatting condition.
FormatConditionCollection
Represents conditional formatting. The FormatConditions can contain up to three conditional formats.
FormulaParseOptions
Represents options when parsing formula.
FormulaSettings
Settings of formulas and calculation.
Geometry
Represents a geometric shape.
GlobalizationSettings
Represents the globalization settings.
GlowEffect
This class specifies a glow effect, in which a color blurred outline is added outside the edges of the object.
GradientFill
Represents the gradient fill.
GradientStop
Represents the gradient stop.
GradientStopCollection
Represents the gradient stop collection.
GroupBox
Encapsulates the object that represents a groupbox in a spreadsheet.
GroupFill
Represents this fill format should inherit the fill properties of the group.
GroupShape
Represents the group shape which contains the individual shapes.
HeaderFooterCommand
Represents the command of header/footer
HorizontalPageBreak
Encapsulates the object that represents a horizontal page break.
HorizontalPageBreakCollection
Encapsulates a collection of HorizontalPageBreak objects.
HtmlLoadOptions
Represents options when importing a html file.
HtmlSaveOptions
Represents the options for saving html file.
Hyperlink
Encapsulates the object that represents a hyperlink.
HyperlinkCollection
Encapsulates a collection of Hyperlink objects.
IconFilter
Represents icon filter.
IconSet
Describe the IconSet conditional formatting rule. This conditional formatting rule applies icons to cells according to their values.
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 Workbook object.
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 LegendEntry objects in the specified chart legend.
License
Provides methods to license the component.
Line
Encapsulates the object that represents the line format.
LineFormat
Represents all setting of the line.
LineShape
Represents the line shape.
ListBox
Represents a list box object.
ListColumn
Represents a column in a list.
ListColumnCollection
Represents A collection of all the ListColumn objects in the specified ListObject object.
ListObject
Represents a list object on a worksheet. The ListObject object is a member of the ListObjects collection. The ListObjects collection contains all the list objects on a worksheet.
ListObjectCollection
Represents a collection of ListObject objects in the worksheet.
LoadFilter
Represents the filter that provides options for loading data when loading workbook from template.
LoadOptions
Represents the options of loading the file.
MarkdownSaveOptions
Represents the save options for markdown.
Marker
Represents the marker in a line chart, scatter chart, or radar chart.
MemoryFontSource
Represents the single TrueType font file stored in memory.
Metered
Provides methods to set metered key.
MsoFillFormat
Represents fill formatting for a shape.
MsoFillFormatHelper
Represents fill formatting for a shape.
MsoFormatPicture
Represents the picture format.
MsoLineFormat
Represents line and arrowhead formatting.
MsoLineFormatHelper
Represents line and arrowhead formatting.
MsoTextFrame
Represents the text frame in a Shape object.
MultipleFilterCollection
Represents the multiple filter collection.
Name
Represents a defined name for a range of cells.
NameCollection
Represents a collection of all the Name objects in the spreadsheet.
NegativeBarFormat
Represents the color settings of the data bars for negative values that are defined by a data bar conditional formatting rule.
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 Picture objects.
PivotField
Represents a field in a PivotTable report.
PivotFieldCollection
Represents a collection of all the PivotField objects in the PivotTable's specific PivotFields type.
PivotFilter
Represents a PivotFilter in PivotFilter Collection.
PivotFilterCollection
Represents a collection of all the PivotFilter objects
PivotFormatCondition
Represents a PivotTable Format Condition in PivotFormatCondition Collection.
PivotFormatConditionCollection
Represents PivotTable Format Conditions.
PivotItem
Represents a item in a PivotField report.
PivotItemCollection
Represents a collection of all the PivotItem objects in the PivotField's
PivotOptions
Represents a complex type that specifies the pivot controls that appear on the chart
PivotPageFields
Represents the pivot page field items if the pivot table data source is consolidation ranges. It only can contain up to 4 fields.
PivotTable
Summary description for PivotTable.
PivotTableCollection
Represents the collection of all the PivotTable objects on the specified worksheet.
PlotArea
Encapsulates the object that represents the plot area in a chart.
PptxSaveOptions
Represents the pptx save options.
ProtectedRange
A specified range to be allowed to edit when the sheet protection is ON.
ProtectedRangeCollection
Encapsulates a collection of ProtectedRange objects.
Protection
Represents the various types of protection options available for a worksheet.
QueryTable
Represents QueryTable information.
QueryTableCollection
A collection of QueryTableCollection objects that represent QueryTable collection information.
RadioButton
Represents a radio button.
Range
Encapsulates the object that represents a range of cells within a spreadsheet.
RangeCollection
Encapsulates a collection of Range objects.
RectangleShape
Represents the rectangle shape.
ReferredArea
Represents a referred area by the formula.
ReferredAreaCollection
Represents all referred cells and areas.
ReflectionEffect
This class specifies a reflection effect.
ReplaceOptions
Represent the replace options.
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 Series objects.
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 SmartTagCollection object in the worksheet.
SolidFill
Encapsulates the object that represents solid fill format
Sparkline
A sparkline represents a tiny chart or graphic in a worksheet cell that provides a visual representation of data.

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 Sparkline objects.
SparklineGroup
Sparkline is organized into sparkline group. A SparklineGroup contains a variable number of sparkline items. A sparkline group specifies the type, display settings and axis settings for the sparklines.
SparklineGroupCollection
Encapsulates a collection of SparklineGroup objects.
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 TextBox objects.
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 Trendline objects for the specified data series.
TxtLoadOptions
Represents the options for loading text file.
TxtSaveOptions
Represents the save options for csv/tab delimited/other text format.
UnionRange
Represents union range.
Validation
Represents data validation.settings.
ValidationCollection
Represents data validation collection.
VbaModule
Represents the module in VBA project.
VbaModuleCollection
Represents the list of VbaModule
VbaProject
Represents the VBA project.
VbaProjectReference
Represents the reference of VBA project.
VbaProjectReferenceCollection
Represents all references of VBA project.
VerticalPageBreak
Encapsulates the object that represents a vertical page break.
VerticalPageBreakCollection
Encapsulates a collection of VerticalPageBreak objects.
VmlShapeGuide
just for vml Encapsulates a shape guide specifies the presence of a shape guide that will be used to govern the geometry of the specified shape
Walls
Encapsulates the object that represents the walls of a 3-D chart.
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 Worksheet objects.
WriteProtection
Specifies write protection settings for a workbook.
XlsbSaveOptions
Represents the options for saving xlsb file.
XlsSaveOptions
Represents the save options for the Excel 97-2003 file format: xls and xlt.
XmlColumnProperty
Represents Xml Data Binding information.
XmlDataBinding
Represents Xml Data Binding information.
XmlLoadOptions
Represents the options of loading xml.
XmlMap
Represents Xml map information.
XmlMapCollection
A collection of XmlMap objects that represent XmlMap information.
XmlSaveOptions
Represents the options of saving the workbook as an xml file.
XpsSaveOptions
Represents the additional options when saving the file as the Xps.
 

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
Utility class containing constants. Represents the type of formatting applied to an Area object or a Line object.
GradientColorType
Utility class containing constants. Represents the gradient color type for the specified fill.
GradientDirectionType
Utility class containing constants. Represents all direction type of gradient.
GradientFillType
Utility class containing constants. Represents all Gradient fill type.
GradientPresetType
Utility class containing constants. Represents gradient preset color type.
GradientStyleType
Utility class containing constants. Represents gradient shading style.
GridlineType
Utility class containing constants. Enumerates grid line Type.
HeaderFooterCommandType
Utility class containing constants. Represents the command type of header and footer.
HtmlCrossType
Utility class containing constants. Represents five types of html cross string.
HtmlExportDataOptions
Utility class containing constants. Represents the options for exporting html data.
HtmlHiddenColDisplayType
Utility class containing constants. Represents two types of showing the hidden columns in html.
HtmlHiddenRowDisplayType
Utility class containing constants. Represents two types of showing the hidden rows in html.
HtmlLinkTargetType
Utility class containing constants. Represents the type of target attribute in HTML tag.
IconSetType
Utility class containing constants. Icon set type for conditional formatting. The threshold values for triggering the different icons within a set are configurable, and the icon order is reversible.
ImageType
Utility class containing constants. Specifies the type (format) of an image.
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
Utility class containing constants. Enumerates the type of Picture border or Chart line.
LoadDataFilterOptions
Utility class containing constants. Represents the options to filter data when loading workbook from template.
LoadFormat
Utility class containing constants. Represents the load file format.
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 CustomDocumentPropertyCollection are exported to PDF file.
PdfFontEncoding
Utility class containing constants. Represents pdf embedded font encoding.
PdfOptimizationType
Utility class containing constants. Specifies a type of optimization.
PivotConditionFormatRuleType
Utility class containing constants. Represents PivotTable condition formatting rule type.
PivotConditionFormatScopeType
Utility class containing constants. Represents PivotTable condition formatting scope type.
PivotFieldDataDisplayFormat
Utility class containing constants. Represents data display format in the PivotTable data field.
PivotFieldSubtotalType
Utility class containing constants. Summary description for PivotFieldSubtotalType.
PivotFieldType
Utility class containing constants. Represents PivotTable field type.
PivotFilterType
Utility class containing constants. Represents PivotTable Filter type.
PivotGroupByType
Utility class containing constants. Represents PivotTable groupby type.
PivotItemPosition
Utility class containing constants. Represents PivotTable base item Next/Previous/All position in the base field .
PivotMissingItemLimitType
Utility class containing constants. Represents number of items to retain per field.
PivotTableAutoFormatType
Utility class containing constants. Represents PivotTable auto format type.
PivotTableStyleType
Utility class containing constants. Represents the pivot table style type.
PlacementType
Utility class containing constants. Represents the way the drawing object is attached to the cells below it.
PlotDataByType
Utility class containing constants. Represents the type of data plot by row or column.
PlotEmptyCellsType
Utility class containing constants. Represents all plot empty cells type of a chart.
PresetCameraType
Utility class containing constants. Represent different algorithmic methods for setting all camera properties, including position.
PresetMaterialType
Utility class containing constants. Describes surface appearance of a shape.
PresetShadowType
Utility class containing constants. Represents preset shadow type.
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).