Namespace Syncfusion.XlsIO

Classes

ConditionValue Represents implementation of single condition value for iconset, databar, colorscale conditions.

ConnectionPassword Represents the connection password of the data source.

ExcelConstants Summary description for _constants.

ExcelEngine This class gives access to the XlsIO IApplication interface.

ExcelImportDataOptions Import Data options class

ExcelUtils ExcelUtils is a helper class that is used for easy usage of direct XlsIO API in performing repetitive tasks.[The usage of this class is not recommended, Please refer to the documentation for updated sample code.]

ExcelWorkbookNotSavedException Exception that will be thrown when the user tries to dispose XlsIO application without saving it.

ExportEventArgs The ExpotEvent args for the TypeMismatchOnExport event which is raised whenever there is a data type mismatch on exporting to CLR objects.

ExportImageFormat Specifes the image export format in Worksheet to image conversion.

ExportImageOptions Represents Export Image Options

IconConditionValue Represents the implementation of Icon condition value

PasswordRequiredEventArgs Event arguments for PasswordRequired event.

ProgressEventArgs Event arguments for notifying read progress.

ReadOnlyFileEventArgs Event arguments for ReadOnlyFile event.

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.

StringEnumerations Represent the string value which are for LineStyle

TemplateMarkerAttributes This class represents the marker attributes.

WarningInfo Represents the warning details with type and description.

XlsIOConfig Represents config xls class.

Structs

TextFrameColumns Represent columns in the Text frame.

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.

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.

IShadow Represents shadow in the chart

IShape Represents a shape.

IShapeLineFormat Represents interface for shape line format.

IShapes Represents shapes collection in the workbook.

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.

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.

IXlsIORenderer Represents XlsIORender used for conversions

Enums

AutoShapeType Represent different auto shapes types.

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.

ConditionValueType

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.

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

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.

ExcelErrorBarInclude Specifies error-bar parts to be included.

ExcelErrorBarType Specifies the range marked by error bars.

ExcelErrorStyle Possible error style values:

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.

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.

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

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.

FilterOperator Filter operator

FilterOperator2007 Filter operator

FontScheme Font Scheme.

HtmlImportOptions Represents the HTML import option.

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.

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.

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.

SortingAlgorithms Represents the algorithm to sort.

SortOn Represents the sort by in the range.

SortOrientation Represents the sort orientation.

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.

TableBuiltInStyles Excel 2007 table built in styles.

TextDirection Represents different text direction.

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.

WarningType Specifies the warning type for the specific warning.

WorksheetVisibility Enumeration which controls visibility of worksheet in Excel.

Delegates

ConnectionPasswordEventHandler Represents the method that will handle the PasswordRequired event.

ExportEventHandler Represents the delegate that handles TypeMismatchOnExport event that is raised whenever there is a data type mismatch while exporting data to CLR objects.

PasswordRequiredEventHandler Represents the method that will handle the PasswordRequired event.

ProgressEventHandler Progress event handler delegate

ReadOnlyFileEventHandler Represents the method that will handle the ReadOnlyFile event.