Namespace Syncfusion.XlsIO
Classes
AutoShapeType
Represent different auto shapes types. |
BindableAttribute
Specifies the Bindable Attribute for a property. |
BuiltInStyles
Specifies the existing built-in styles. |
CellPropertyExtensionType
Represents the extension property data. |
CFTextRuleType
Conditional format type of Text rule. |
CFTimePeriods
Specifies the time periods for date time conditional formatting in Excel. |
ChartParagraphType
MS Chart Font preservation Type (Internal use) |
ConditionalFormatOperator
Specifies the type of conditions that can be used for Icon sets |
ConditionalFormatScope
Represents the scope of conditional formatting applied in the PivotTable. |
ConditionalFormatTemplate
Conditional format template. |
ConditionalTopNType
Represents the possible types that defines the values for the Top N conditional formatting evaluation for the PivotTable. |
ConditionValue
Represents implementation of single condition value for iconset, databar, colorscale conditions.
|
ConditionValueType |
ConnectionPassword
Represents the connection password of the data source.
|
ConnectionPasswordEventHandler
Represents the method that will handle the PasswordRequired event.
|
ConsolidationFunction
Represents a possible consolidation functions in Excel. |
DataBarAxisPosition
Specifies the axis position for a range of cells with conditional formatting as data bars. |
DataBarDirection
Defines the directions of data bar in conditional formatting. |
DateTimeGroupingType
Represents grouping type applied for DateTime filter. |
DisplayFormatAttribute
Specifies the display format for a property. |
DisplayNameAttribute
Specifies the display name for a property. |
DVAspect
Represents the OleObject Display Behaviour. |
DynamicFilterType
Represent relative date filter type. |
Excel2007BorderJoinType
shape border join type (Supported in Excel 2007 and higher) |
Excel2007ChartBevelProperties
This enumeration value indicates the bevel properties for both Top nad Bottom Bevel |
Excel2007ChartLightingProperties
This enumeration value indicates the Lighting properties for the Chart |
Excel2007ChartMaterialProperties
This Enumeration value indicates the Material property values fro the chart |
Excel2007ChartPresetsInner
This enumeration value indicates the Inner Shadow Values |
Excel2007ChartPresetsOuter
This Enumeration values Indicates the Outer Shadow values |
Excel2007ChartPresetsPrespective
This Enumeration values gives the Perspective shadow Values |
Excel2007CommentHAlign
Enumeration to align the excel comment Horizontally. |
Excel2007CommentVAlign
This type specifies a list of available anchoring types for text. |
Excel2007Function
Represents functions added in Excel 2007. |
Excel2007ShapeLineStyle
Represents line style. |
Excel2007TextAlign
Represents Excel 2007 Text alignment. |
Excel2007TextRotation
If there is vertical text, determines what type of vertical text is going to be used. |
ExcelAutoFormat
Represents auto format values. |
ExcelAutoFormatOptions
Represents auto format options. |
ExcelAutoType
Enumeration of the Border Pattern setting for Chart formatting in Excel. |
ExcelAxisLineIdentifier
Enumeration which represents axis line identifier. |
ExcelAxisTextDirection
Represents the axis title direction. |
ExcelAxisType
Specifies the axis types for charts in Excel. |
ExcelAxisUsed
Enumeration of the axes used for Charts in Excel. |
ExcelBaseFormat
Base format options. |
ExcelBordersIndex
Enumeration of the border and diagonal line types in Excel. |
ExcelBorderWeight
Enumeration of the border weight types for lines/pictures in Excel. |
ExcelBubbleSize
Specifies what the bubble size represents on a bubble chart. |
ExcelBuiltInProperty
Property IDs for the SummaryInformation Property Set. |
ExcelCalculationMode
Enum that defines different types of the formula calculations. |
ExcelCategoriesLabelLevel
Specifies the category labels for the category label levels. |
ExcelCategoryType
Specifies the type of the category axis. |
ExcelCellType
Enumeration to specify an excel cell type. |
ExcelCFAverageType
Specifies whether the AboveBelowAverage conditional formatting rule looks for cell values above or below the average. |
ExcelCFTopBottomType
Specifies whether the TopBottom conditional formatting rule looks for ranking from the top or bottom. |
ExcelCFType
Specifies whether the conditional format is based on a cell value or an expression. |
ExcelChartBackgroundMode
Enumeration of the background mode for Charts in Excel. |
ExcelChartBaseUnit
Represents chart base unit. |
ExcelChartDisplayUnit
Represents excel chart uint to display. |
ExcelChartHorzAlignment
Enumeration of the horizontal alignment options for Charts in Excel. |
ExcelChartLinePattern
Specifies the line pattern for the border. |
ExcelChartLineWeight
Represents allowed line weight values for charts in Excel. |
ExcelChartMarkerType
Specifies the marker style for a point or series in a line chart, scatter chart, or radar chart. |
ExcelChartPictureType
Gets or Sets the way picture are displayed on the walls and Faces of 3D-chart. |
ExcelChartPlotEmpty
Specifies how blank cells are plotted on a chart. |
ExcelChartType
Specifies the chart types. |
ExcelChartVertAlignment
Enumeration of the vertical alignment options for Charts in Excel. |
ExcelCheckState
Specifies check state of the check box. |
ExcelClearOptions
Specifies the possible directions to clear the cell formats, content, comments,conditional format,data validation or clear all of them. |
ExcelColorFilterType
Specifies the type of color filter |
ExcelColorIndex
Enumeration of the Color Index in Excel. |
ExcelCombinationFilterType
Represents different type of combinational filter. |
ExcelComboType
Represents possible combo box type values.. |
ExcelCommandType
Represent different command types of external connections. |
ExcelCommentHAlign
Enumeration to align the excel comment Horizontally. |
ExcelCommentVAlign
Enumeration to align the excel comment vertically |
ExcelComparisonOperator
Specifies the comparison operator for conditional formatting in Excel. |
ExcelConnectionsType
It's Define the connection type |
ExcelConstants
Summary description for _constants.
|
ExcelCopyRangeOptions
Enumeration to specify the options to update formulas and merged ranges during copy range operation. |
ExcelCredentialsMethod
It's represent the cretential for connect the server |
ExcelDataLabelPosition
Represents the data label positioning. |
ExcelDataProviderType
Possible types for row data storage. |
ExcelDataSourceType
Data source type. |
ExcelDataType
Specifies the type of validation test to be performed in conjunction with values. |
ExcelDataValidationComparisonOperator
Specifies the comparison operators for data validation. |
ExcelDownloadType
Enumeration to specify if the spreadsheet should be opened inside browser or saved as an attachment to disk. |
ExcelDropLineStyle
Represents the drop line style type. |
ExcelEncryptionType
Represents encryption algorithm that will be used for encryption. |
ExcelEngine
This class gives access to the XlsIO IApplication interface. |
ExcelErrorBarInclude
Specifies error-bar parts to be included. |
ExcelErrorBarType
Specifies the range marked by error bars. |
ExcelErrorStyle
Possible error style values: |
ExcelExportDataOptions
Represents a class for exporting data options. |
ExcelExportDataTableOptions
Specifies the possible ExportDataTable options. |
ExcelExportType
Indicates what property will be used for export. |
ExcelFillType
Represents shape fill type. |
ExcelFilterAction
Specifies whether data is to be copied or left in place during a filter operation. |
ExcelFilterCondition
Possible conditions in autofilter. |
ExcelFilterDataType
Data type for autofilters. |
ExcelFilterType
Specifies the type of filter applied. |
ExcelFindOptions
Specifies the possible type of finding options. |
ExcelFindType
Specifies the type of data to search. |
ExcelFontVertialAlignment
Defines the possible settings for vertical alignment of a run of text. This is used to get superscript or subscript text without altering the font size properties of the rest of the text run. |
ExcelFormatType
Possible format types. |
ExcelFormulaLabel
Enumeration of the label types for formula in Excel. |
ExcelFunction
Enumeration of Worksheet functions in Excel. |
ExcelGradientColor
Represents gradient color type. |
ExcelGradientPattern
Represents excel gradient pattern. |
ExcelGradientPreset
Represents preset gradient type. |
ExcelGradientStyle
Represents excel shape shading style. |
ExcelGradientVariants
Represents shape shading variants. |
ExcelGroupBy
Specifies the Group types in Excel. |
ExcelHAlign
Enumeration of the horizontal alignment options for cell formatting in Excel. |
ExcelHorizontalAlignment
Represents different horizontal alignments |
ExcelHttpContentType
HttpContent type. |
ExcelHyperlinkAttachedType
Specify the hyperlink attached object name. |
ExcelHyperLinkType
Possible types of hyperlinks. |
ExcelIconSetType
Specifies the type of icon set. |
ExcelIgnoreError
Specifies the flags of excel ignore error indicator. |
ExcelImageFormat
Possible image formats. |
ExcelImportDataOptions
Import Data options class |
ExcelInsertOptions
Represents a possible insert options in Excel. |
ExcelKnownColors
Specifies the possible colors in Excel. |
ExcelLegendPosition
Specifies the position of the legend on a chart. |
ExcelLegendSpacing
Represents the ExcelLegendSpacing options. |
ExcelLineStyle
Specifies the line style for the border in Excel. |
ExcelListObjectSourceType
Represents different list object source type for external connection |
ExcelMergeOperation
Enumeration of merge operation types in Excel. |
ExcelMoveDirection
Specifies the possible directions to shift cells after clearing a range. |
ExcelNamesMergeOptions
Enumeration to specify Names Merge options. |
ExcelNestedDataGroupOptions
Specifies whether the grouping is added with Collapse or Expand while importing nested collection CLR objects. |
ExcelNestedDataLayoutOptions
Specifies how to fill the group field values while importing nested collection CLR objects. |
ExcelObjectTextLink
Object text is linked to. |
ExcelOpenType
Represents excel open type. |
ExcelOrder
Enumeration of page order for sheet in Excel. |
ExcelPageBreak
Enumeration of page break types in Excel. |
ExcelPageBreakExtent
Enumeration of page break extent types in Excel. |
ExcelPageOrientation
Enumeration of page orientation types in Excel. |
ExcelPagesOrder
The order in which page fields are added to the PivotTable report's layout. |
ExcelPaperSize
Enumeration of paper size types in Excel. |
ExcelParameterDataType
Represents Excel Parameter Data Type |
ExcelParameterType
Represents Excel Parameter Type |
ExcelParseFormulaOptions
Enumeration to specify the options of excel formula |
ExcelParseOptions
Parsing options. |
ExcelPattern
Enumeration of Patterns available in Excel. |
ExcelPieType
Enumeration limits values which can be set by user. |
ExcelPrintedChartSize
Enumeration of the print size of charts in Excel. |
ExcelPrintErrors
Enumeration of Replace Error Values when printing in Excel. |
ExcelPrintLocation
Enumeration representing print comments in Excel. |
ExcelQuartileCalculation
It represents Quartile calculation used for Box and Whisker Chart series |
ExcelRangeIndexerMode
Specifies whether the range should be accessed from worksheet or within the range object scope. |
ExcelReadingOrderType
Possible types of direction order. |
ExcelRectangleStyle
Excel rectangle style. Used in chart frames. |
ExcelSaveAsAccessMode
Enumeration of Save as Access mode types in Excel. |
ExcelSaveType
Enumeration of the Save types in Excel. |
ExcelSeriesNameLevel
Specifies the series labels for the series label levels. |
ExcelShapeArrowLength
Represents arrow head length. |
ExcelShapeArrowStyle
Represents shape arrow style type. |
ExcelShapeArrowWidth
Represents arrow head width. |
ExcelShapeArrowWidthLength
Represents shape arrow width length. |
ExcelShapeDashLineStyle
Represents shape dash line style. |
ExcelShapeLineStyle
Represents line style. |
ExcelShapeType
Enumeration of shapes available in Excel. |
ExcelSheetProtection
Represents sheet protection flags enums. |
ExcelSheetType
Enumeration of the sheet types in Excel. |
ExcelSlicerStyle
Represents Slicer style |
ExcelSplitType
Specifies the values displayed in the second chart in a pie chart or a bar of pie chart. |
ExcelStyleMergeOptions
Enumeration to specify the style merge options. |
ExcelTableStyleElementType
Element type of Excel Table Style |
ExcelTableType
It's represent the table type |
ExcelTextRotation
Enumeration to specify the possible Text Rotation options. |
ExcelTexture
Represents gradient texture. |
ExcelTickLabelPosition
Specifies the position of tick-mark labels on the axis. |
ExcelTickMark
Specifies the position of major and minor tick marks for an axis. |
ExcelTopFormat
Top format options. |
ExcelTotalsCalculation
Specifies the type of calculation in the Totals row of a list column. |
ExcelTreeMapLabelOption
It represents the Label position in Tree Map chart |
ExcelTrendLineType
Represents trend line values. |
ExcelUnderline
Specifies the underline types for the fonts available in Excel. |
ExcelVAlign
Enumeration of the vertical alignment options for cell formatting in Excel. |
ExcelVersion
Represents possible excel versions. |
ExcelVerticalAlignment
Represents different vertical alignments |
ExcelWorkbookNotSavedException
Exception that will be thrown when the user tries to dispose XlsIO
application without saving it.
|
ExcelWorksheetCopyFlags
Enumeration to specify options when copying worksheets. |
ExcelXmlOpenType
Supported Xml open types. |
ExcelXmlSaveType
Supported Xml save types. |
ExpandCollapseFlags
Flags for expand/collapse settings. |
ExportDataTableActions
Specifies the export data table event actions. |
ExportEventArgs
The ExpotEvent args for the TypeMismatchOnExport event which is raised whenever there is a data type mismatch on exporting to CLR objects. |
ExportEventHandler
Represents the delegate that handles TypeMismatchOnExport event that is raised whenever there is a data type mismatch while exporting data to CLR objects. |
FilterOperator
Filter operator |
FilterOperator2007
Filter operator |
FontScheme
Font Scheme. |
HtmlImportOptions
Represents the HTML import option. |
IconConditionValue
Represents the implementation of Icon condition value |
Image
Represents the image class. |
ImageFormat
Specifies the image format. |
ImageType
Possible image types for image conversion. |
LayoutModes
Represents different modes of layout |
LayoutTargets
Represents different targets of layout. |
MeasureUnits
Represents the MeasureUnits types. |
OleLinkType
Defines types of the ole object field. |
OleObjectType
defines the types of OLE object |
OrderBy
Represents the sort order. |
PasswordRequiredEventArgs
Event arguments for PasswordRequired event. |
PasswordRequiredEventHandler
Represents the method that will handle the PasswordRequired event.
|
PivotAreaType
Indicates the type of rule being used to describe an area or aspect of the PivotTable. |
PivotAxisTypes
Represents Axis types in the pivot table. |
PivotAxisTypes2007
Represents Axis types in the pivot table equivalent to Excel 2007. |
PivotBuiltInStyles
Represents pivot table built in styles equivalent to Excel 2007. |
PivotDataType
Represent data types for pivot table cache fields. |
PivotFieldDataFormat
Represents the data formats for a field in the PivotTable |
PivotFieldGroupType
Represents data grouping that can be performed on a PivotTable. |
PivotFieldSortType
sort orders that can be applied to fields in a PivotTable. |
PivotFilterType
Pivot filter type |
PivotFilterType2007
Filter type |
PivotItemType
This simple type defines the pivot type for a pivotItem. |
PivotItemType2007
This simple type defines the Open Xml Pivot type for a pivotItem. |
PivotPageAreaFieldsOrder
Represents the Page field area order when there are multiple page fields in the page area |
PivotSubtotalItems2007
Axis types in Excel 2007 file format notation. |
PivotSubtotalTypes
Represents the Subtotal types. |
PivotSubtotalTypes2007
Axis types in Excel 2007 file format notation. |
PivotTableRowLayout
Specifies the pivot table row layout. |
ProgressEventArgs
Event arguments for notifying read progress.
|
ProgressEventHandler
Progress event handler delegate
|
ReadOnlyFileEventArgs
Event arguments for ReadOnlyFile event.
|
ReadOnlyFileEventHandler
Represents the method that will handle the ReadOnlyFile event.
|
ScalingMode
It represents the chart image Scaling. |
SheetView
Defines the view setting of the sheet. |
SkipExtRecords
This enumeration used for controlling output stream infill on save operation provided by Workbook. |
SlicerCrossFilterType
Represents Cross Filter type of the slicer |
SortingAlgorithms
Represents the algorithm to sort. |
SortOn
Represents the sort by in the range. |
SortOrientation
Represents the sort orientation. |
Sparkline
Represents a Sparkline.The Sparkline object is a member of the Sparklines Collection.
The Sparklines collection contains all the sparkline objects in a worksheet. |
SparklineEmptyCells
Defines the Display of the Empty Cells within the Sparkline Range. |
SparklineType
Defined types of Sparkline chart types. |
SparklineVerticalAxisOptions
Defines the Sparkline vertical axis type. |
StringEnumerations
Represent the string value which are for LineStyle
|
TableBuiltInStyles
Excel 2007 table built in styles. |
TemplateMarkerAttributes
This class represents the marker attributes.
|
TextDirection
Represents different text direction. |
TextFrameColumns
Represent columns in the Text frame.
|
TextHorzOverflowType
Represents different horizontal overflow types. |
TextVertOverflowType
Represents different vertical overflow types. |
UnknownVariableAction
Represents a possible action to be taken while encountering unknown variable during template markers processing. |
VariableTypeAction
Defines action for the unknown value type and numberformat in the template marker variable. |
WarningInfo
Represents the warning details with type and description. |
WarningType
Specifies the warning type for the specific warning. |
WorksheetVisibility
Enumeration which controls visibility of worksheet in Excel. |
XlsIOConfig
Represents config xls class.
|
Interfaces
IAboveBelowAverage
Represents the above or below conditional formatting rule. Applying this rule to a range helps you highlight the cells which contain values above or below the average of selected range. |
IAddInFunction
Represents an Custom Addin Function in Excel. |
IAddInFunctions
Represents a collection of custom Add In functions. |
IApplication
Represents the Excel application. |
IAutoFilter
Represents an Autofilter in an Excel worksheet. |
IAutoFilterCondition
Represents the autofilter conditions for CustomFilter. |
IAutoFilters
Represents a collection of Autofilters. |
IBorder
Represents the border of an object. |
IBorders
A collection of four Border objects that represent the four borders of a Range or Style object. |
IBuiltInDocumentProperties
Represents user interface for built-in document properties. |
ICalculationOptions
Represents the Calculation options in a Excel Workbook. |
IChart
Represents a chart sheet in the workbook. |
IChartAxis
Represents an axis on the chart. |
IChartBorder
Represents chart border. Provides Border options for Chart Area and Plot Area. |
IChartCategories
Represents a collection of chart categories. |
IChartCategory
Represents category in the chart. |
IChartCategoryAxis
Represents category axis of the chart. |
IChartDataLabels
Represents a collection of chart data labels. |
IChartDataPoint
Represents data point in the chart. |
IChartDataPoints
Represents a collection of data points in the series. |
IChartDataTable
Represents the chart data table. |
IChartDropBar
Represents up or down bars for the line chart. |
IChartErrorBars
Represent error bars on the chart series. Error bars indicate the degree of uncertainty for chart data. Only series in area, bar, column, line, and scatter groups on a 2-D chart can have error bars. Only series in scatter groups can have x and y error bars. |
IChartFillBorder
Provides formatting options for area elements in the chart. |
IChartFormat
Provides access to the formatting options for chart elements. |
IChartFrameFormat
Represent the borders and layout options of the chart elements. |
IChartGridLine
Represent grid lines of the chart. |
IChartInterior
Represents the chart interior. Interior of chart is supported in Chart area and Plot area only. |
IChartLayout
Provides layout options for plot area, legend and text area elements of the chart. |
IChartLegend
Represents the legend of the chart. |
IChartLegendEntries
Represents a collection of legend entries in the chart. |
IChartLegendEntry
Represents a legend entry in a chart legend. |
IChartManualLayout
Represent the chart manual layout |
IChartPageSetup
Represent page setup options for the chart sheet. |
IChartPlotArea
Represents plot area of the chart. |
IChartRichTextString
Represents rich text of the chart title. |
ICharts
Represents a collection of charts in the workbook. |
IChartSerie
Represents a series in the chart. |
IChartSerieDataFormat
Represents formatting options for the series data. |
IChartSeries
Represents the collection of chart series. |
IChartSeriesAxis
Represents the chart series Axis. |
IChartShape
Represents an embedded chart in the worksheet. |
IChartShapes
Represents a collection of embedded charts. |
IChartTextArea
Represents the Text Area in a chart. |
IChartToImageConverter
Represents the XlsIO Chart to image converter. |
IChartTrendLine
Represents ChartTrendLine interface. |
IChartTrendLines
Interface that represents trend line collection. |
IChartValueAxis
Represents the chart value axis. |
IChartWallOrFloor
Interface that represents chart wall or floor. |
ICheckBoxes
This interface represents CheckBoxes collection inside single worksheet. |
ICheckBoxShape
This interface represents TextBox form control shape. |
IColorConditionValue
Represents a condition value for color scale conditional format. |
IColorScale
Represents a color scale conditional formatting rule. |
ICombinedRange
Represents a combined Range. |
IComboBoxes
This interface represents collection of all combo box inside single worksheet. |
IComboBoxShape
This interface provides access to the combo box shape properties. |
IComment
Represents a cell comment. The Comment object is a member of the Comments collection. |
IComments
A collection of cell comments. Each comment is represented by a Comment object. |
ICommentShape
Represents an Excel comment. |
IConditionalFormat
Represents a conditional format. |
IConditionalFormats
Represents a collection of conditional formats. |
IConditionValue
Represents a condition value for IDataBar, IColorScale and IIconSet conditions. |
IConnection
Represent the connection source |
IConnections
Represent the connection collection. |
ICustomDocumentProperties
Summary description for ICustomDocumentProperties. |
ICustomProperty
Represents single worksheet custom property. |
ICustomXmlPart
Represent the custom xml part in excel |
ICustomXmlPartCollection
Represents custom xml part collection in excel. |
ICustomXmlSchemaCollection
A collection of all the Name objects in the application or workbook. Each Name object represents a defined name for a range of cells. |
IDataBar
Represents a data bar conditional formatting rule. Applying a data bar to a range helps you see the value of a cell relative to other cells. |
IDataSort
Represents the sort of range. |
IDataValidation
Represents data validation for a worksheet range. |
IErrorIndicator
Represents IErrorIndicator interface. |
IExtendedFormat
Contains the font attributes (font name, size, color, and so on) for an object. |
IFill
Represents fill format. |
IFont
Contains the font attributes (font name, font size, color and so on) for an object. |
IGroupShape
Represents the group shape in a worksheet. |
IHFEngine
Engine for parsing and creation of header/footer strings. |
IHPageBreak
Represents a horizontal page break. The HPageBreak object is a member of the HPageBreaks collection. |
IHPageBreaks
The collection of horizontal page breaks within the print area. Each horizontal page break is represented by an IHPageBreak object. |
IHyperLink
Represents a hyperlink. |
IHyperLinks
Represents collection of hyperlinks. |
IIconConditionValue
Represents a condition value for IIconSet conditions. |
IIconSet
Represents a set of icons that are used in an icon set conditional formatting rule. |
IListObject
Represents a table on a worksheet. |
IListObjectColumn
Represents a column in the table. |
IListObjects
Represents collection of IListObject in the worksheet. |
IMergeCells
Represents a Merged Cell. |
IMetaProperties
Represents meta properties in excel |
IMetaProperty
Represents a defined name for a range of cells. Names can be either built-in names such as Database, Print_Area, and Auto_Open or custom names. |
IMigrantRange
Represents range object for the single cell. Coordinates of such object can be changed. There should be only one such object for single worksheet. |
IName
Represents a defined name for a range of cells. Names can be either built-in names such as Database, Print_Area, and Auto_Open or custom names. |
INameIndexChangedEventProvider
Summary description for INameIndexChangedEventProvider. |
INames
A collection of all the Name objects in the application or workbook. Each Name object represents a defined name for a range of cells. |
INumberFormat
Represents settings of number format. |
IOleObject
Represent the Ole object shapes. |
IOleObjects
Represents the Ole objects shape collections. |
IOptionButtons
This interface represents OptionButton collection inside single worksheet. |
IOptionButtonShape
This interface represents TextBox form control shape. |
IPageSetup
Represents the page setup description. The PageSetup object contains all page setup attributes (left margin, bottom margin, paper size, and so on) as properties. |
IParameter
Represents the parameter used in a query table. |
IParameters
Represents a collection of parameters collection. |
IParentApplication
Represents parent application. |
IPictures
A collection of cell comments. Each comment is represented by a Comment object. |
IPictureShape
Represents an Image in a worksheet. |
IPivotCache
Represents the memory cache for a PivotTable report. |
IPivotCaches
Represents the collection of memory caches from the PivotTable reports in a workbook. |
IPivotCalculatedFields
Represents collection of calculated fields in the pivot table. |
IPivotCellFormat
Represents Pivot Cell Format |
IPivotDataField
Represents a data field in pivot table report. |
IPivotDataFields
Represents the collection of data fields from the PivotTable reports in a workbook. |
IPivotField
Represents a field in a PivotTable report. |
IPivotFieldGroup
Represents the pivot field group in pivot field. |
IPivotFieldItem
Represents an item in PivotTable field. The items are the individual data entries in a field category. |
IPivotFieldItems
Represents a collection of IPivotFieldItem in a PivotTable field. |
IPivotFields
Represents a collection of IPivotField in the pivot table. |
IPivotFilter
Represents a pivot filter which is applied to IPivotField. |
IPivotFilters
Represents a collection of IPivotFilter in the pivot table. |
IPivotTable
Represents a PivotTable on a worksheet. |
IPivotTableOptions
Represents the setting for the pivot table in the worksheet. |
IPivotTables
Represents collection of IPivotTable in the worksheet. |
IPivotValueLableFilter
Represents pivot value filter or pivot label filter object. |
IRange
Represents a cell, a row, a column, collection of cells or a 3-D Range. |
IRanges
Represents a collection of ranges. |
IRichTextString
Represents a Rich Text String that can be used to apply several styles inside a single cell. |
IScenario
Represents What-If analysis scenario in the worksheet. |
IScenarios
Represents the collection of What-If analysis scenarios in the worksheet. |
IShadow
Represents shadow in the chart |
IShape
Represents a shape. |
IShapeLineFormat
Represents interface for shape line format. |
IShapes
Represents shapes collection in the workbook. |
ISlicer
Represents the Slicer in a worksheet |
ISlicerCache
Represents the slicer cache of the slicer. |
ISlicerCacheItem
Respresents the slicer item of the slicer |
ISlicerCacheItems
Respresents the slicer item collection of the slicer |
ISlicers
Respresents the slicer collection of the worksheet |
ISortField
Represents the sort field based on which sorting is performed. |
ISortFields
Represents the sort field collections based on which sorting is performed. |
ISortingAlgorithm
Represents the Algorithm to be perform sorting. |
ISparkline
Represents the Sparkline chart. |
ISparklineGroup
Represents the Sparkline chart group. |
ISparklineGroups
Represents the collections of Sparkline chart group. |
ISparklines
Represents the Spraklines in Sprakline chart |
ISparklineVerticalAxis
Represents vertical axis of the Sprakline chart. |
IStyle
Represents a style description for a range. The Style object contains all style attributes (font, number format, alignment, and so on) as properties. There are several built-in styles, including Normal, Currency, and Percent. Using the Style object is a fast and efficient way to change several cell-formatting properties on multiple cells at the same time. For the Workbook object, the Style object is a member of the Styles collection. The Styles collection contains all the defined styles for the workbook |
IStyles
A collection of all the Style objects in the specified or active workbook. Each Style object represents a style description for a range. The Style object contains all style attributes (font, number format, alignment, and so on) as properties. There are several built-in styles including Normal, Currency, and Percent which are listed in the Style name box in the Style dialog box. (Format menu). |
ITableStyle
Represents Table Style |
ITableStyleElement
Represents Table Style Element |
ITableStyleElements
Represents Table Style Elements |
ITableStyles
Represents Table Styles |
ITabSheet
Represents worksheet and chartsheet tab in Excel. |
ITabSheets
Represents a collection of ITabSheets in the worksheet. |
ITemplateMarkers
Summary description for ITemplateMarkers. |
ITemplateMarkersProcessor
Represents the processing of a special marker symbol, that appends multiple records from data source into a worksheet. |
ITextBox
This interface represents TextBox form control. |
ITextBoxes
This interface represents TextBoxes collection inside single worksheet. |
ITextBoxShape
This interface represents TextBox form control shape. |
ITextBoxShapeEx
This interface represents TextBox form control shape. |
ITextFrame
Returns a TextFrame object that contains the alignment and anchoring properties for the specified shape. Read-only. |
ITextRange
Returns the TextRange object that represents the text in the object. Read-only. |
IThreadedComment
Represents the threaded comment for range. |
IThreadedComments
Represents the threaded comment collection for a worksheet. |
IThreeDFormat
Represents the three-dimensional chart format. |
ITopBottom
Represents the top or bottom conditional formatting rule. Applying this rule to a range helps you highlight the top or bottom �n� cells from the selected range. |
IVPageBreak
Represents a vertical page break. The VPageBreak object is a member of the VPageBreaks collection. |
IVPageBreaks
A collection of vertical page breaks within the print area. Each vertical page break is represented by a VPageBreak object. |
IWarning
Represents the Warning details for the unsupported and substituted elements. |
IWorkbook
Represents an MS Excel Workbook. |
IWorkbooks
A collection of all the Workbook objects that are currently open in the Excel application. |
IWorksheet
Represents a worksheet in a workbook. |
IWorksheetCustomProperties
Returns a CustomProperties object representing the identifier information associated with a worksheet. |
IWorksheetGroup
Represents a worksheet group. |
IWorksheets
A collection of all the Worksheet objects in the specified or active workbook. Each Worksheet object represents a worksheet. |