ExpertXls.ExcelLib Namespace

Represents the alignment style options of the text in a cell.

Represents one of the borders of a range or style

Represents a collection of four borders of a Range or a Style. A border index can be used to identify the Border object

Represents the interior style of a cell or range of cells.

Represents a gradient fill options for a cell or range.

Represents the pattern fill of a cell interior

Represents the solid fill for a cell interior.

Represents the number format options for a cell or a range of cells.

Represents the protection options for a cell or a range of cells.

Represents the style of a cell or a range of cells.

Represents a collection of cell styles. The ExcelWorkbook offers such a collection containing all the styles created in the workbook.

Represents a chart shape in a worksheet.

Represents an area in an Excel chart.

Represents the category axis (horizontal axis) of a chart

Represents a data point in the chart.

Represents the label of a chart data point

Represents a collection of data points in a chart series

Represents the formatting options for the chart data table.

Represents a formatted text area in a chart.

Represents the interior of a chart element

Represents the legend of a chart.

Represents the collection of legend entries for a picture.

Represents and entry in the chart legend.

Represents the border of a chart element

Represents the rotation properties for a 3D chart.

Represents the collection of charts in a worksheet

Represents a data series in a Excel chart

Represents the series axis (depth axis) of a chart

Represents a collection of chart series.

Represents the value axis (vertical axis) of a chart

Represents a chart worksheet.

Represents the chart worksheet page setup

Represents a colection of chart worksheets in a workbook.

Represents the Excel colors palette.

Represents a comment in a mec.

Represents a collection of comments in a worksheet

Represents a data type validator for a range of cells.

The document properties like title, subject, keywords, author, etc.

Manage the document security like workbook structure and windows protection, open/write password protection.

Represents a font in the Excel workbook

Represents a hyperlink in the worksheet hyperlinks collection.

Represents a collection of hyperlinks

Exception thrown by the Excel library

Represents a named range in a worksheet. Named ranges can be added to the worksheet or workbook named ranges collection.

Represents a collection of named ranges. The ExcelWorksheet and ExcelWorkbook define such collections.

Represents a horizontal or vertical page break in worksheet

Represents a collection of page breaks.

Represents the Excel page setup.

Represents a picture in a worksheet.

Represents a collection of picture in a worksheet.

Represents a range of cells in a worksheet

Represents a collection of ranges in a worksheet.

Represents the interior of a shape

Represents a gradient fill options for a shape.

Represents the pattern fill of a shape interior.

Represents a picture fill of a shape interior.

Represents the solid fill for a shape interior.

Represents the texture fill of a shape interior.

Utility class to convert between various Excel measurement units (points, pixels, width characters)

The Excel Workbook

A class encapsulating the default options (font, row height, column width) for a newly created workbook.

Excel Worksheet

Represents the Excel page setup for a worksheet.

Represents the collection of Excel worksheets in a workbook

Manages the security options for a worksheet.

Specifies the index of the border to be retrieved from a borders collection.

The interior pattern of a cell

Represents the type of interior for cell or range of cells.

The horizontal alignment of data in a cell

Enumeration of the border line styles for cells in Excel.

Specifies the reading order for the cell

Represents the underline style of the text in a cell

The vertical alignment of data in a cell

Represents the axis labels position from the chart axis

Represents the type of the category axis of a chart

Represents the chart legend position in chart area.

Represents the type of line for a chart element border.

Represents the weight of a chart border line

Represents the chart axis tick marks type

Represents the time unit for category axis

Enumeration of the Chart types in Excel.

The display units for the value axis.

Represents the data types allowed by a data validator.

Represents the style of the error alert for data validator.

Represents a comparison operator used by a data validator.

Describes how the cells are shifted to replace deleted cells.

Represents the colors mode of a gradient

Represents the possible directions of the gradient

Represents the variants for a gradient direction.

Describes how to group the range.

Represents the type of URL in a worksheet.

Represents the scope of a named range.

Represents the type of pae break (horizontal or vertical).

Represents the page orientation of a worksheet.

Represents the paper size for an Excel document.

Represents the location where the comments in a worksheet will be printed.

Represents the mode of printing errors.

Specifies the order in which cells are processed.

Represents how the picture is attached to the cells below it.

The allowed operations for a protected worksheet.

Represents the possible patterns of shape interior.

Represents the available preset gradients

Represents the possible textures of the shape interior.

Represents the type of interior of a shape.

The Excel workbook format