Spire.Xls.Core Namespace

Represents the path info of the freeform shape.

Represents an Custom Addin Function in Excel.

Represents a collection of custom Add In functions.

Defines the contract for an arc shape, which can be used to represent parts of a circle or ellipse.

Defines a contract for shapes that can be represented as arcs.

Represents autofiltering for the specified worksheet..

Represents the autofilter conditions.

Represents a collection of Autofilters.

Defines the contract for an object that represents a border.

Defines a contract for classes that represent borders, providing methods or properties related to border manipulation or retrieval.

Represents user interface for built-in document properties.

Defines the contract for a button shape, specifying methods and properties that any button shape implementation must provide.

Defines the contract for button shapes, providing methods or properties that any button shape implementation must support.

Represents a chart sheet in the workbook.

Represents an axis on the chart.

Represents chart border. Provides Border options for Chart Area and Plot Area.

Represents category axis of the chart.

Represents a collection of chart data labels.

Represents data point in the chart.

Defines a contract for chart data points, which can be implemented by classes representing data points in a chart.

Represents the chart data table.

Defines the contract for a chart drop bar component, which is responsible for rendering a drop bar in a charting application.

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.

Provides formatting options for area elements in the chart.

Provides access to the formatting options for chart elements.

Represent the borders and layout options of the chart elements.

Represent grid lines of the chart.

Represents the chart interior. Interior of chart is supported in Chart area and Plot area only.

Represents the legend of the chart.

Defines the contract for managing chart legend entries, allowing for the addition, removal, and retrieval of legend items in a chart.

Represents a legend entry in a chart legend.

Represent page setup options for the chart sheet.

Defines the contract for chart-related operations and functionalities.

Represents a series in the chart.

Represents formatting options for the series data.

Defines the contract for a chart series, which represents a set of data points that can be rendered on a chart.

Represents the chart series Axis.

Defines the contract for chart shapes, which can be used to represent various graphical elements in a chart.

Defines a contract for chart shapes, which can be implemented by various chart shape classes to provide a common interface for charting operations.

Represents the Text Area in a chart.

Represents ChartTrendLine interface.

Defines the contract for a chart trend lines component, allowing for the implementation of various trend line functionalities in a chart.

Represents the chart value axis.

Interface that represents chart wall or floor.

Defines the contract for a checkbox component, allowing for checking and unchecking states.

Defines the contract for a component that manages a collection of checkboxes.

Supports cloning, which creates a new instance of a class with the same value as an existing instance.

Condition value for color scale conditional format.

This interface provides access to the color scale condition in the conditional format.

Represents a combined Range.

Defines a contract for a class that manages multiple ComboBox controls, allowing for operations such as adding, removing, and updating ComboBox items.

Defines the contract for a ComboBox shape.

Defines a contract for a comment entity.

Defines a contract for handling comments, which can include methods for adding, retrieving, updating, and deleting comments.

Defines the contract for comment shape.

Contains a condition and the formatting attributes applied to the cells, if the condition is met.

Represents a collection of conditional formats.

Represents a collection of conditional formats that can be applied to a worksheet range in a spreadsheet application.

Summary description for ICustomDocumentProperties.

Represents a collection of custom properties.

Represents a data bar conditional formating rule. Applying a data bar to a range helps you see the value of a cell relative to other cells.

Represents the sort of range.

Contains a condition and the formatting attributes applied to the cells, if the condition is met.

Represents a collection of data validation rules or objects.

Defines a contract for data validation tables, which are responsible for validating data entries according to specific rules or criteria.

Represents IErrorIndicator interface.

Define that all behaviors in Excel must include a Parent property.

Represents an extended format interface for Excel applications, inheriting from IExcelApplication.

Defines the contract for a font, which can be used to specify the style, size, and other attributes of text.

Defines a contract for a geometric path, which can be used to represent a series of connected line segments or curves in a 2D or 3D space.

Defines an interface for providing geometric path information.

Represents a geometric path shape, inheriting properties and methods from the IPrstGeomShape interface.

Interface used to get gradient XlsFill effects.

Represents a graphical user interface element that groups related controls or elements together, inheriting properties and methods from the IShape interface.

Defines a contract for managing group boxes within a user interface.

Represents a horizontal page break. The HPageBreak object is a member of the HPageBreaks collection.

The collection of horizontal page breaks within the print area. Each horizontal page break is represented by an HPageBreak object.

Represents a hyperlink in an Excel application.

Defines a contract for handling hyperlinks, including operations to manage and interact with hyperlinks.

This interface provides access to Conditional formatting icon set condition.

Defines the contract for an interior.

Represents internal worksheet object. It can be internal or external.

Defines an interface for a label shape that inherits from the IShape interface.

Defines the contract for label shapes, which can be used to label or annotate graphical shapes in an application.

Defines a contract for types that represent a collection of lines.

Defines the contract for a line shape, including properties and methods that are common to all line shapes.

Defines an interface for a list box, which is a type of shape that can display a list of items.

Defines a contract for classes that manage multiple list boxes.

Represents a table on a worksheet.

Represents a column in the table.

Defines a contract for classes that can list objects.

Summary description for ITemplateMarkers.

Represents range object for the single cell. Coordinates of such object can be changed. There should be only one such object for single worksheet.

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.

A collection of all the Name objects in the application or workbook. Each Name object represents a defined name for a range of cells.

Defines methods and properties for number format.

Represents an interface for objects that can be embedded in OLE containers.

Defines a contract for interacting with OLE (Object Linking and Embedding) objects within a document or application.

Defines the contract for an oval-shaped object, including properties and methods that describe and manipulate the shape.

Defines a contract for oval-shaped objects, providing methods and properties common to all oval shapes.

Represents the page setup description. The PageSetup object contains all page setup attributes (left margin, bottom margin, paper size, and so on) as properties.

Defines a contract for working with pictures, including methods for loading, saving, and manipulating images.

Defines a contract for a picture shape, which includes methods and properties related to the manipulation and representation of picture shapes.

Represents pivot cache.

Represents collection of workbook pivot caches.

Defines a contract for pivot calculated fields, which are used to perform calculations on pivot table data.

Represents pivot table data field.

Represents pivot cache data field collection.

Represents pivot field object.

Represents field collection inside pivot table.

Represents pivot table object.

Describes the settings of the pivot table

Represents collection of all pivot tables inside worksheet.

Defines the contract for a geometric shape in a presentation geometry context.

Defines a contract for geometric shapes, allowing for the implementation of various geometric forms and their associated properties or behaviors.

Defines the contract for a radio button control, which allows the user to select one option from a set of mutually exclusive options.

Defines a contract for a group of radio buttons, allowing for the selection of a single option from a set of mutually exclusive options.

Defines an interface for a rectangle shape that inherits properties and methods from IShape, ITextBox, and IPrstGeomShape interfaces.

Defines the contract for rectangle shapes, including methods and properties that all rectangle shapes should implement.

Represents a Rich Text String that can be used to apply several styles inside a single cell.

Defines the contract for a scrollbar shape, providing methods and properties necessary for rendering and interacting with a scrollbar.

Defines the contract for shapes that can be used in a scrollbar.

Defines the contract for a shape, which can be implemented by various geometric shapes.

Defines methods and properties for filling a shape with color or pattern.

Defines the interface for setting and getting line format properties of a shape.

Defines a contract for shapes, which can be implemented by any class representing a geometric shape.

Defines a contract for a column that can be used in sorting operations.

Defines a contract for sorting columns in a data structure, such as a table or a grid.

Defines a contract for a rule that can be sorted.

Represents a spinner shape, inheriting from the IShape interface.

Defines a contract for spinner shapes, which can be used to specify the visual representation of a spinner in a user interface.

The Style interface

Defines a contract for styles that can be applied to various elements within an application.

Represents an Excel worksheet Tab.

Summary description for ITabSheets.

Defines the contract for a text box control.

Defines a contract for classes that provide functionality related to text boxes.

Defines the contract for a text box link shape, which is responsible for representing a link or connection within a text box.

Defines the contract for a text box.

Defines the contract for a text frame, which is a container for displaying and managing text content.

Defines a contract for a vertical page break in a document or spreadsheet.

A collection of vertical page breaks within the print area. Each vertical page break is represented by a VPageBreak object.

Represents an MS Excel Workbook.

Represents a worksheet. The Worksheet object is a member of the Worksheets collection. The Worksheets collection contains all the Worksheet objects in a workbook.

Represents a worksheet group.

A collection of all the Worksheet objects in the specified or active workbook. Each Worksheet object represents a worksheet.

Represents a cell, row, column, selection of cells containing one or more contiguous blocks of cells, or a 3-D range.

Represents a collection of ranges.

Defines the base interface for a TextBox shape, providing a contract for common text box functionalities.

Specifies the built-in styles that can be applied to a slicer. These styles define the visual appearance of the slicer, including colors and formatting.