Syncfusion.XlsIO.Base
Inheritance Hierarchy

Syncfusion.XlsIO Namespace

Contains types to create and manipulate Excel documents.
Classes
 ClassDescription
Class This class gives access to the XlsIO IApplication interface.
Class 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.]
Class The ExpotEvent args for the TypeMismatchOnExport event which is raised whenever there is a data type mismatch on exporting to CLR objects.
Class 
Class Event arguments for PasswordRequired event.
Interfaces
 InterfaceDescription
Interface Represents an Custom Addin Function in Excel.
Interface Represents a collection of custom Add In functions.
Interface Represents the Excel application.
Interface Represents an Autofilter in an Excel worksheet.
InterfaceRepresents the autofilter conditions for ExcelFilterType.CustomFilter.
Interface Represents a collection of Autofilters.
Interface Represents the border of an object.
Interface A collection of four Border objects that represent the four borders of a Range or Style object.
Interface Represents user interface for built-in document properties.
Interface Represents the Calculation options in a Excel Workbook.
Interface Represents a chart sheet in the workbook.
Interface Represents an axis on the chart.
Interface Represents chart border. Provides Border options for Chart Area and Plot Area.
Interface Represents a collection of chart categories.
Interface Represents category in the chart.
Interface Represents category axis of the chart.
Interface Represents a collection of chart data labels.
Interface Represents data point in the chart.
Interface Represents a collection of data points in the series.
Interface Represents the chart data table.
Interface Represents up or down bars for the line chart.
Interface 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.
Interface Provides formatting options for area elements in the chart.
Interface Provides access to the formatting options for chart elements.
Interface Represent the borders and layout options of the chart elements.
Interface Represent grid lines of the chart.
Interface Represents the chart interior. Interior of chart is supported in Chart area and Plot area only.
Interface Provides layout options for plot area, legend and text area elements of the chart.
Interface Represents the legend of the chart.
Interface Represents a collection of legend entries in the chart.
Interface Represents a legend entry in a chart legend.
Interface Represent the chart manual layout
Interface Represent page setup options for the chart sheet.
Interface Represents plot area of the chart.
Interface Represents rich text of the chart title.
Interface Represents a collection of charts in the workbook.
Interface Represents a series in the chart.
Interface Represents formatting options for the series data.
Interface Represents the collection of chart series.
Interface Represents the chart series Axis.
Interface Represents an embedded chart in the worksheet.
Interface Represents a collection of embedded charts.
Interface Represents the Text Area in a chart.
Interface Represents the XlsIO Chart to image converter.
Interface Represents ChartTrendLine interface.
Interface Interface that represents trend line collection.
Interface Represents the chart value axis.
Interface Interface that represents chart wall or floor.
Interface This interface represents CheckBoxes collection inside single worksheet.
Interface This interface represents TextBox form control shape.
Interface Represents a condition value for color scale conditional format.
Interface Represents a color scale conditional formatting rule.
Interface Represents a combined Range.
Interface This interface represents collection of all combo box inside single worksheet.
Interface This interface provides access to the combo box shape properties.
Interface Represents a cell comment. The Comment object is a member of the Comments collection.
Interface A collection of cell comments. Each comment is represented by a Comment object.
Interface Represents an Excel comment.
Interface Represents a conditional format.
Interface Represents a collection of conditional formats.
InterfaceRepresents a condition value for IDataBar, IColorScale and IIconSet conditions.
Interface Represent the connection source
Interface Represent the connection collection.
Interface Summary description for ICustomDocumentProperties.
Interface Represents single worksheet custom property.
Interface Represent the custom xml part in excel
Interface Represents custom xml part collection in excel.
Interface A collection of all the Name objects in the application or workbook. Each Name object represents a defined name for a range of cells.
Interface 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.
Interface Represents the sort of range.
Interface Represents data validation for a worksheet range.
Interface Represents IErrorIndicator interface.
Interface Contains the font attributes (font name, size, color, and so on) for an object.
Interface Represents fill format.
Interface Contains the font attributes (font name, font size, color and so on) for an object.
Interface Represents the group shape in a worksheet.
Interface Engine for parsing and creation of header/footer strings.
Interface Represents a horizontal page break. The HPageBreak object is a member of the HPageBreaks collection.
InterfaceThe collection of horizontal page breaks within the print area. Each horizontal page break is represented by an IHPageBreak object.
Interface Represents a hyperlink.
Interface Represents collection of hyperlinks.
InterfaceRepresents a condition value for IIconSet conditions.
Interface Represents a set of icons that are used in an icon set conditional formatting rule.
Interface Represents a table on a worksheet.
Interface Represents a column in the table.
InterfaceRepresents collection of IListObject in the worksheet.
Interface Represents a Merged Cell.
Interface Represents meta properties in excel
Interface 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.
Interface Represents range object for the single cell. Coordinates of such object can be changed. There should be only one such object for single worksheet.
Interface 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.
Interface Summary description for INameIndexChangedEventProvider.
Interface A collection of all the Name objects in the application or workbook. Each Name object represents a defined name for a range of cells.
Interface Represents settings of number format.
Interface Represent the Ole object shapes.
Interface Represents the Ole objects shape collections.
Interface This interface represents OptionButton collection inside single worksheet.
Interface This interface represents TextBox form control shape.
Interface Represents the page setup description. The PageSetup object contains all page setup attributes (left margin, bottom margin, paper size, and so on) as properties.
Interface Represents parent application.
Interface A collection of cell comments. Each comment is represented by a Comment object.
Interface Represents an Image in a worksheet.
Interface Represents the memory cache for a PivotTable report.
Interface Represents the collection of memory caches from the PivotTable reports in a workbook.
Interface Represents collection of calculated fields in the pivot table.
Interface Represents a data field in pivot table report.
Interface Represents the collection of data fields from the PivotTable reports in a workbook.
Interface Represents a field in a PivotTable report.
Interface Represents an item in PivotTable field. The items are the individual data entries in a field category.
InterfaceRepresents a collection of IPivotFieldItem in a PivotTable field.
InterfaceRepresents a collection of IPivotField in the pivot table.
InterfaceRepresents a pivot filter which is applied to IPivotField.
InterfaceRepresents a collection of IPivotFilter in the pivot table.
Interface Represents a PivotTable on a worksheet.
Interface Represents the setting for the pivot table in the worksheet.
InterfaceRepresents collection of IPivotTable in the worksheet.
Interface Represents pivot value filter or pivot label filter object.
Interface Represents a cell, a row, a column, collection of cells or a 3-D Range.
Interface Represents a collection of ranges.
Interface Represents a Rich Text String that can be used to apply several styles inside a single cell.
Interface Represents shadow in the chart
Interface Represents a shape.
Interface Represents interface for shape line format.
Interface Represents shapes collection in the workbook.
Interface Represents the sort field based on which sorting is performed.
Interface Represents the sort field collections based on which sorting is performed.
Interface Represents the Algorithm to be perform sorting.
Interface Represents the Sparkline chart.
Interface Represents the Sparkline chart group.
Interface Represents the collections of Sparkline chart group.
Interface Represents the Spraklines in Sprakline chart
Interface Represents vertical axis of the Sprakline chart.
Interface 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
Interface 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).
Interface 
Interface 
Interface 
Interface 
Interface Represents worksheet and chartsheet tab in Excel.
InterfaceRepresents a collection of ITabSheets in the worksheet.
Interface Represents the processing of a special marker symbol, that appends multiple records from data source into a worksheet.
Interface This interface represents TextBox form control.
Interface This interface represents TextBoxes collection inside single worksheet.
Interface This interface represents TextBox form control shape.
Interface This interface represents TextBox form control shape.
Interface Returns a TextFrame object that contains the alignment and anchoring properties for the specified shape. Read-only.
Interface Returns the TextRange object that represents the text in the object. Read-only.
Interface Represents the three-dimensional chart format.
Interface Represents a vertical page break. The VPageBreak object is a member of the VPageBreaks collection.
Interface A collection of vertical page breaks within the print area. Each vertical page break is represented by a VPageBreak object.
Interface Represents an MS Excel Workbook.
Interface A collection of all the Workbook objects that are currently open in the Excel application.
Interface Represents a worksheet in a workbook.
Interface Returns a CustomProperties object representing the identifier information associated with a worksheet.
Interface Represents a worksheet group.
Interface A collection of all the Worksheet objects in the specified or active workbook. Each Worksheet object represents a worksheet.
Delegates
 DelegateDescription
Delegate Represents the delegate that handles TypeMismatchOnExport event that is raised whenever there is a data type mismatch while exporting data to CLR objects.
Enumerations
 EnumerationDescription
Enumeration Represent different auto shapes types.
Enumeration Specifies the existing built-in styles.
Enumeration Represents the extension property data.
Enumeration Conditional format type of Text rule.
Enumeration Specifies the time periods for date time conditional formatting in Excel.
Enumeration MS Chart Font preservation Type (Internal use)
Enumeration Specifies the type of conditions that can be used for Icon sets
Enumeration Represents the scope of conditional formatting applied in the PivotTable.
Enumeration Conditional format template.
Enumeration Represents the possible types that defines the values for the Top N conditional formatting evaluation for the PivotTable.
Enumeration 
Enumeration Represents a possible consolidation functions in Excel.
Enumeration Specifies the axis position for a range of cells with conditional formatting as data bars.
Enumeration Defines the directions of data bar in conditional formatting.
Enumeration Represents grouping type applied for DateTime filter.
Enumeration Represents the OleObject Display Behaviour.
Enumeration Represent relative date filter type.
Enumeration shape border join type (Supported in Excel 2007 and higher)
Enumeration This enumeration value indicates the bevel properties for both Top nad Bottom Bevel
Enumeration This enumeration value indicates the Lighting properties for the Chart
Enumeration This Enumeration value indicates the Material property values fro the chart
Enumeration This enumeration value indicates the Inner Shadow Values
Enumeration This Enumeration values Indicates the Outer Shadow values
Enumeration This Enumeration values gives the Perspective shadow Values
Enumeration Enumeration to align the excel comment Horizontally.
Enumeration This type specifies a list of available anchoring types for text.
Enumeration Represents functions added in Excel 2007.
Enumeration Represents line style.
Enumeration Represents Excel 2007 Text alignment.
Enumeration If there is vertical text, determines what type of vertical text is going to be used.
Enumeration Represents auto format values.
Enumeration Represents auto format options.
Enumeration Enumeration of the Border Pattern setting for Chart formatting in Excel.
Enumeration Enumeration which represents axis line identifier.
Enumeration Represents the axis title direction.
Enumeration Specifies the axis types for charts in Excel.
Enumeration Enumeration of the axes used for Charts in Excel.
Enumeration Base format options.
Enumeration Enumeration of the border and diagonal line types in Excel.
Enumeration Enumeration of the border weight types for lines/pictures in Excel.
Enumeration Specifies what the bubble size represents on a bubble chart.
Enumeration Property IDs for the SummaryInformation Property Set.
Enumeration Enum that defines different types of the formula calculations.
Enumeration Specifies the category labels for the category label levels.
Enumeration Specifies the type of the category axis.
Enumeration Enumeration to specify an excel cell type.
Enumeration Specifies whether the conditional format is based on a cell value or an expression.
Enumeration Enumeration of the background mode for Charts in Excel.
Enumeration Represents chart base unit.
Enumeration Represents excel chart uint to display.
Enumeration Enumeration of the horizontal alignment options for Charts in Excel.
Enumeration Specifies the line pattern for the border.
Enumeration Represents allowed line weight values for charts in Excel.
Enumeration Specifies the marker style for a point or series in a line chart, scatter chart, or radar chart.
Enumeration Gets or Sets the way picture are displayed on the walls and Faces of 3D-chart.
Enumeration Specifies how blank cells are plotted on a chart.
Enumeration Specifies the chart types.
Enumeration Enumeration of the vertical alignment options for Charts in Excel.
Enumeration Specifies check state of the check box.
Enumeration Specifies the possible directions to clear the cell formats, content, comments,conditional format,data validation or clear all of them.
Enumeration Specifies the type of color filter
Enumeration Enumeration of the Color Index in Excel.
Enumeration Represents different type of combinational filter.
Enumeration Represents possible combo box type values..
Enumeration Represent different command types of external connections.
Enumeration Enumeration to align the excel comment Horizontally.
Enumeration Enumeration to align the excel comment vertically
Enumeration Specifies the comparison operator for conditional formatting in Excel.
Enumeration It's Define the connection type
Enumeration Enumeration to specify the options to update formulas and merged ranges during copy range operation.
Enumeration It's represent the cretential for connect the server
Enumeration Represents the data label positioning.
Enumeration Possible types for row data storage.
Enumeration Data source type.
Enumeration Specifies the type of validation test to be performed in conjunction with values.
Enumeration Specifies the comparison operators for data validation.
Enumeration Enumeration to specify if the spreadsheet should be opened inside browser or saved as an attachment to disk.
Enumeration Represents the drop line style type.
Enumeration Represents encryption algorithm that will be used for encryption.
Enumeration Specifies error-bar parts to be included.
Enumeration Specifies the range marked by error bars.
Enumeration Possible error style values:
Enumeration Specifies the possible ExportDataTable options.
Enumeration Indicates what property will be used for export.
Enumeration Represents shape fill type.
Enumeration Specifies whether data is to be copied or left in place during a filter operation.
Enumeration Possible conditions in autofilter.
Enumeration Data type for autofilters.
Enumeration Specifies the type of filter applied.
Enumeration Specifies the possible type of finding options.
Enumeration Specifies the type of data to search.
Enumeration 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.
Enumeration Possible format types.
Enumeration Enumeration of the label types for formula in Excel.
Enumeration Enumeration of Worksheet functions in Excel.
Enumeration Represents gradient color type.
Enumeration Represents excel gradient pattern.
Enumeration Represents preset gradient type.
Enumeration Represents excel shape shading style.
Enumeration Represents shape shading variants.
Enumeration Specifies the Group types in Excel.
Enumeration Enumeration of the horizontal alignment options for cell formatting in Excel.
Enumeration Represents different horizontal alignments
Enumeration HttpContent type.
Enumeration Specify the hyperlink attached object name.
Enumeration Possible types of hyperlinks.
Enumeration Specifies the type of icon set.
Enumeration Specifies the flags of excel ignore error indicator.
Enumeration Possible image formats.
Enumeration Represents a possible insert options in Excel.
Enumeration Specifies the possible colors in Excel.
Enumeration Specifies the position of the legend on a chart.
Enumeration Represents the ExcelLegendSpacing options.
Enumeration Specifies the line style for the border in Excel.
Enumeration Represents different list object source type for external connection
Enumeration Enumeration of merge operation types in Excel.
Enumeration Specifies the possible directions to shift cells after clearing a range.
Enumeration Enumeration to specify Names Merge options.
Enumeration Object text is linked to.
Enumeration Represents excel open type.
Enumeration Enumeration of page order for sheet in Excel.
Enumeration Enumeration of page break types in Excel.
Enumeration Enumeration of page break extent types in Excel.
Enumeration Enumeration of page orientation types in Excel.
Enumeration The order in which page fields are added to the PivotTable report's layout.
Enumeration Enumeration of paper size types in Excel.
Enumeration Enumeration to specify the options of excel formula
Enumeration Parsing options.
Enumeration Enumeration of Patterns available in Excel.
Enumeration Enumeration limits values which can be set by user.
Enumeration Enumeration of the print size of charts in Excel.
Enumeration Enumeration of Replace Error Values when printing in Excel.
Enumeration Enumeration representing print comments in Excel.
Enumeration It represents Quartile calculation used for Box and Whisker Chart series
Enumeration Specifies whether the range should be accessed from worksheet or within the range object scope.
Enumeration Possible types of direction order.
Enumeration Excel rectangle style. Used in chart frames.
Enumeration Enumeration of Save as Access mode types in Excel.
Enumeration Enumeration of the Save types in Excel.
Enumeration Specifies the series labels for the series label levels.
Enumeration Represents arrow head length.
Enumeration Represents shape arrow style type.
Enumeration Represents arrow head width.
Enumeration Represents shape arrow width length.
Enumeration Represents shape dash line style.
Enumeration Represents line style.
Enumeration Enumeration of shapes available in Excel.
Enumeration Represents sheet protection flags enums.
Enumeration Enumeration of the sheet types in Excel.
Enumeration Specifies the values displayed in the second chart in a pie chart or a bar of pie chart.
Enumeration Enumeration to specify the style merge options.
Enumeration 
Enumeration It's represent the table type
Enumeration Enumeration to specify the possible Text Rotation options.
Enumeration Represents gradient texture.
Enumeration Specifies the position of tick-mark labels on the axis.
Enumeration Specifies the position of major and minor tick marks for an axis.
Enumeration Top format options.
Enumeration Specifies the type of calculation in the Totals row of a list column.
Enumeration It represents the Label position in Tree Map chart
Enumeration Represents trend line values.
Enumeration Specifies the underline types for the fonts available in Excel.
Enumeration Enumeration of the vertical alignment options for cell formatting in Excel.
Enumeration Represents possible excel versions.
Enumeration Represents different vertical alignments
Enumeration Enumeration to specify options when copying worksheets.
Enumeration Supported Xml open types.
Enumeration Supported Xml save types.
Enumeration Flags for expand/collapse settings.
Enumeration Filter operator
Enumeration Filter operator
Enumeration Font Scheme.
Enumeration Possible image types for image conversion.
Enumeration Represents different modes of layout
Enumeration Represents different targets of layout.
Enumeration Represents the MeasureUnits types.
Enumeration Defines types of the ole object field.
Enumeration defines the types of OLE object
Enumeration Represents the sort order.
Enumeration Indicates the type of rule being used to describe an area or aspect of the PivotTable.
Enumeration Represents Axis types in the pivot table.
Enumeration Represents Axis types in the pivot table equivalent to Excel 2007.
Enumeration Represents pivot table built in styles equivalent to Excel 2007.
Enumeration Represent data types for pivot table cache fields.
Enumeration Represents the data formats for a field in the PivotTable
Enumeration Represents data grouping that can be performed on a PivotTable.
Enumeration sort orders that can be applied to fields in a PivotTable.
Enumeration Pivot filter type
Enumeration Filter type
Enumeration This simple type defines the pivot type for a pivotItem.
Enumeration This simple type defines the Open Xml Pivot type for a pivotItem.
Enumeration Represents the Page field area order when there are multiple page fields in the page area
Enumeration Axis types in Excel 2007 file format notation.
Enumeration Represents the Subtotal types.
Enumeration Axis types in Excel 2007 file format notation.
Enumeration Specifies the pivot table row layout.
Enumeration It represents the chart image Scaling.
Enumeration Defines the view setting of the sheet.
Enumeration This enumeration used for controlling output stream infill on save operation provided by Workbook.
Enumeration Represents the algorithm to sort.
Enumeration Represents the sort by in the range.
Enumeration Represents the sort orientation.
Enumeration Defines the Display of the Empty Cells within the Sparkline Range.
Enumeration Defined types of Sparkline chart types.
Enumeration Defines the Sparkline vertical axis type.
Enumeration Excel 2007 table built in styles.
Enumeration Represents different text direction.
Enumeration Represents different horizontal overflow types.
Enumeration Represents different vertical overflow types.
Enumeration Represents a possible action to be taken while encountering unknown variable during template markers processing.
Enumeration Defines action for the unknown value type and numberformat in the template marker variable.
Enumeration Enumeration which controls visibility of worksheet in Excel.
See Also