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.
|
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.
|
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.
|
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 |
Collects the objects that represent the individual columns in a 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.
|
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.
|
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.
|
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.
Only used in ExcelXP and above version.
|
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.
|
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.
|
StyleCollection |
Encapsulates a collection of |
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.
|
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 module that is contained 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 |
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.
|
XmlMap |
Represents Xml map information.
|
XmlMapCollection |
A collection of |
XpsSaveOptions |
Represents the additional options when saving the file as the Xps.
|
Constant Summary | |
---|---|
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
|
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.
Enumerates spreadsheet 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 col in html.
|
HtmlHiddenRowDisplayType | Utility class containing constants.
Represents two types of showing the hidden row 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.
|
NumberCategoryType | Utility class containing constants.
Represents category type of cell's number formatting.
|
OleFileType | Utility class containing constants.
Ole object file type.
|
OoxmlCompliance | Utility class containing constants.
Allows to specify which OOXML specification will be used when saving in the Xlsx format.
|
OoxmlCompressionType | Utility class containing constants.
The Ooxml compression type
|
OperatorType | Utility class containing constants.
Represents the operator type of conditional format and data validation.
|
PageLayoutAlignmentType | Utility class containing constants.
Enumerates page layout alignment types.
|
PageOrientationType | Utility class containing constants.
Represents print orientation constants.
|
PaneStateType | Utility class containing constants.
Represents state of the sheet's pane.
|
PaperSizeType | Utility class containing constants.
Represents paper size constants.
|
ParameterType | Utility class containing constants.
Represents all parameters' type or return value type of function.
|
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 |
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.
Renames strategy when columns contains the duplicate names.
|
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).
|