Anchor — An anchor represents the position of a floating (non-cell data) object within a spreadsheet. The position is maintained as a row number + a percentage of the row's width and a column number + a percentage of the column's height.
Area — An Area object represents a rectangular set of cells.
AutoFilter — The AutoFilter class represents the filter that is applied to a selected area of cells in a worksheet.
AxisLabel — An AxisLabel object represents the labels on an axis. The labels are the displayed values on the axis. Note: the title of an axis (returned by Axis.Title ) is not an axis label.
AxisType — When creating a chart with two X or Y axes (primary and secondary), use AxisType to associate a series with a particular axis.
Border — A Border object represents a border around a cell or area of cells.
BorderPart — A BorderPart object represents a particular part of a border around a cell or area of cells.
CategoryAxis — A CategoryAxis object represents a chart's category (x) axis. CategoryAxis is a sub-class of Axis.
Cell — A Cell object represents a single cell in a worksheet. To return a Cell object use Worksheet.Cells. Specify the cell by 0-based row and column indexes or by Excel-style reference:
Cells — A Cells collection represents the set of cells in a worksheet.
CellStyle — The unique cell style for a given cell.
Chart — The Chart class represents an Excel chart. It is the main class for code-based chart creation and modification.
ChartDataTable — A ChartDataTable object represents a chart's data table. A data table is a grid that can be added to some charts that contains the numeric data used to create the chart. The data table is usually attached to the chart's category axis, replacing the tick-mark labels on the axis.
Charts — The Charts collection contains all charts in the specified worksheet. Chart sheets are not included in this collection. To return a Charts collection, use Worksheet.Charts.
ChartType — The ChartType class contains all available chart types. When setting a chart type, always specify both the major type and the sub-type, for example:
Color — The {msdn:System.Drawing.Color|Color} class represents a single color in a spreadsheet's color palette.
Comment — A Comment object represents a note attached to a cell, or group of merged cells, separate from other cell content. A Comment must be associated with a cell, and may only be created using set Comment.Visible to true.
Condition — A Condition object represents a condition within a ConditionalFormat, a format that Excel will apply to a cell or group of cells if a specified condition is met.
ConditionalFormat — A ConditionalFormat object represents a conditional format that Excel will apply to a cell or group of cells if a specified condition is met. Each ConditionalFormat object contains up to three Condition and a Range object representing the set of cells on which the conditions will be tested.
ErrorBar — An ErrorBar object represents the error bars on a series. Error bars graphically express potential error amounts relative to each data marker in a data series. You can add error bars to data series in two-dimensional area, bar, column, line, scatter, and bubble charts. In scatter and bubble charts, you can display error bars for x values, y values, or both.
ExcelApplication — ExcelApplication is the main class for pure code-based workbook generation (for information about template-based workbook generation, see ExcelTemplate). This class is an engine used to open, create, and write (save or stream to a browser) workbooks. A single instance of ExcelApplication can generate multiple workbooks.
ExcelWriterException — All methods in the ExcelWriter API can throw an exception of type ExcelWriterException.
Font — The Font object represents a font style that you can use when creating a reusable Style object, or when setting the style of a cell or set of cells. To set or return a Font object, use Style.Font.
GlobalStyle — ExcelWriter creates three style types: GlobalStyle, NamedStyle, and CellStyle. All three style types derive from the Style class, and NamedStyle derives from GlobalStyle.
Group — A Group is a type of shape that contains other shapes. Currently, groups may not be created or have their contents modified. They may be moved, resized, and deleted.
Groups — Groups provides access to the collection of Group objectss contained within a drawing. Currently, only top level groups may be accessed. Nested groups are not supported. Additionally, a group may not be created or have its contents modified. However, a group can be moved, resized, and removed from a drawing. To return a Groups collection, use Worksheet.ShapeGroups.
HeaderFooterSection — The HeaderFooterSection class represents an area of the header or footer. It allows you to set and retrieve the content in that area.
Hyperlink — Represents a hyperlink in an Area (which may contain only one cell) that points to an external URL.
ItemsToRetain — The ItemsToRetain class represents the number of items a PivotTable cache will retain even changes have been made to the data source.
Legend — A Legend object represents a chart's legend. To return Legend object, use Chart.Legend.
NamedObject — A NamedObject object may refer to an array, number, picture, or range. To create a NamedObject in an Excel file, use the corresponding method for the specific object you wish to create (Pictures.CreatePicture(), Workbook.CreateRange(), etc). To get a NamedObject from an existing file, use Workbook.GetNamedObject(), passing in the name of the object you wish to get.
NamedStyle — ExcelWriter creates three style types: GlobalStyle, NamedStyle, and CellStyle. All three style types derive from the Style class, and NamedStyle derives from GlobalStyle.
NumberFormat — NumberFormat is a helper class that creates custom number format strings, which are used for formatting numbers and dates. Use Style.NumberFormat to set a number format for a specific style.
ObjectPositioning — Enumeration of the available resize and reposition behaviors of an object when the cells in the spreadsheet it spans are changed.
Othersheet — A Othersheet object represents a sheet that is not a worksheet or a chartsheet. This sheet represents VBA Module and dialog sheets. These are not currently implemented by ExcelWriter
PageSetup — The PageSetup class represents the page layout properties of a printed worksheet.
Palette — The Palette class represents Excel's color palette.
Pattern — Pattern contains all available background patterns for pictures.
Picture — A Picture object represents a picture in a worksheet and allows the size, position, and content of the picture to be managed. Once created, the data of a picture may not be changed or replaced with the data of another picture. Instead, delete the picture and create a new one.
Pictures — The Pictures collection represents the set of pictures in a worksheet. To return a Pictures collection, use Worksheet.Pictures.
PivotTable — A PivotTable object represents a PivotTable in a worksheet and allows the PivotTable to be managed.
PivotTableField — The PivotTableField represents a single field in a Pivot Table. This can be a row label, column label, data field (or value field) or a page field (or report filter). To get a PivotTableField object, use a FieldCollection.
PivotTables — The PivotTables collection represents the set of PivotTables in a worksheet. To return a PivotTables collection, use PivotTables.
Shape — The Shape class allows the appearance and behavior of drawing object to be manipulated. On its own, Shape represents a simple auto shape, such as a line, rectangle, or oval. A shape may also represent the display area of a Comment or the size, position, and formatting of a Picture.
ShapeType — The ShapeType class contains the Excel shape types supported by ExcelWriter.
ShowValueAs — The ShowValueAs class contains the options for showing the value of a DataField. It is equivalent to the Show Values As tab in DataField settings in Excel.
UpDownBar — An UpDownBar object represents up/down bars in a line chart. Up/down bars connect data points in the highest and lowest series in a line chart to show motion during an interval.
ValueAxis — A ValueAxis object represents a chart's value (y) axis. The ValueAxis class extends Axis .
Worksheets — The Worksheets class represents the set of worksheets in an Excel workbook. This object is used to manage (add, copy, remove, etc.) the worksheets in the workbook To return a Worksheets object, use Workbook.Worksheets.