Name | Description |
Anchor |
An anchor represents the position of a floating (non-cell data) object within a spreadsheet
|
Area |
An Area object represents a rectangular set of cells
|
Axis |
An Axis object represents a chart axis.
The Axis class has two sub-classes:
CategoryAxis and ValueAxis .
The following properties
return a CategoryAxis object:
Chart.CategoryAxis
Chart.SecondaryCategoryAxis
Chart.ZCategoryAxis
The following properties
return a ValueAxis object:
Chart.ValueAxis
Chart.SecondaryValueAxis
Chart.ScatterValueAxis
|
AxisLabel |
An AxisLabel object represents the labels on an 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
|
Cell |
A Cell object represents a single cell in a worksheet
|
CellStyle |
Every cell in an Excel workbook contains a unique cell style
|
Cells |
A Cells collection represents the set of cells in a worksheet
|
CharacterRun |
The CharacterRun class allows you to set a font on a specified range of characters within a ChartText object or a cell
|
Chart |
The Chart class represents an Excel chart
|
ChartDataTable |
A ChartDataTable object represents a chart's data table
|
ChartInterior |
A ChartInterior object contains formatting properties of a ChartRegion or an object extending ChartRegion ( AxisLabel , ChartText , Legend , or SeriesDataLabel )
|
ChartLine |
A ChartLine object represents a line in a chart
|
ChartPageSetup |
The ChartPageSetup class represents the page layout properties of a printed chart or chart sheet
|
ChartRegion |
A ChartRegion object represents either a chart area or plot area
|
ChartSettings3D |
The ChartSettings3D class contains the set of properties specific to three-dimensional charts
|
ChartText |
A ChartText object represents a region in a chart where text is displayed (e.g., a chart title)
|
ChartTextCollection |
The ChartTextCollection contains all ChartText objects in the specified chart
|
ChartType |
The ChartType class contains all available chart types
|
Charts |
The Charts collection contains all charts in the specified worksheet
|
Chartsheet |
A Chartsheet object represents a worksheet that contains only a chart
|
Color |
The Color class represents a single color in a
spreadsheet's color palette
|
ColumnProperties |
The ColumnProperties class represents a single column in a worksheet
|
Comment |
A Comment object represents a note attached to a cell, or group of merged cells, separate from other cell content
|
Comments |
The Comments collection contains all Comment objects in the worksheet
|
DataImportProperties |
The DataImportProperties contains a set of properties that can be used when importing data into a Worksheet or Area
|
DataPoint |
A DataPoint object represents a data point in a chart
|
DataPointMarker |
The DataPointMarker class represents the style and formatting of data markers in line, radar, and scatter charts
|
DocumentProperties |
The DocumentProperties object represents properties of a spreadsheet
|
ErrorBar |
An ErrorBar object represents series error bars
|
ExcelApplication |
ExcelApplication is the main class for pure code-based workbook generation (for information about template-based workbook generation, see ExcelTemplate )
|
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
|
GlobalStyle |
ExcelWriter creates three style types: GlobalStyle , NamedStyle , and CellStyle
|
Group |
A Group is a type of shape that contains other shapes
|
Groups |
Groups provides access to the collection of Group objectss contained within a drawing
|
Hyperlink |
Represents a hyperlink in an Area (which may contain only one cell)
|
Hyperlinks |
The Hyperlinks collection contains all hyperlinks in a worksheet
|
Legend |
A Legend object represents a chart's legend
|
NamedObject |
A NamedObject object may refer to an array, number, picture, or range
|
NamedStyle |
ExcelWriter creates three style types: GlobalStyle , NamedStyle , and CellStyle
|
NumberFormat |
NumberFormat is a helper class that creates custom number format strings, which are used for formatting numbers and dates
|
Othersheet |
A Othersheet object represents a sheet that is not a worksheet or a chartsheet
|
PageSetup |
The PageSetup class represents the page layout properties of a printed worksheet
|
Palette |
The Palette class represents Excel's color palette
|
Picture |
A Picture object represents a picture in a worksheet and allows the size, position, and content of the picture to be managed
|
Pictures |
The Pictures collection represents the set of pictures in a worksheet
|
Range |
A Range object represents a range in a workbook
|
RowProperties |
The RowProperties class represents a single row in a worksheet
|
Series |
A Series object represents a single data series in a chart
|
SeriesCollection |
The SeriesCollection class contains the set of data series in a worksheet
|
SeriesDataLabel |
A SeriesDataLabel represents the appearance of series labels
|
SettingsBarColumn |
The SettingsBarColumn class contains all settings that are specific to bar and column charts
|
SettingsLineAreaScatter |
The SettingsLineAreaScatter class contains all settings that are specific to line, area, and scatter charts
|
SettingsPieDoughnut |
The SettingsPieDoughnut class contains all settings that are specific to pie and doughnut charts
|
Shape |
The Shape class allows the appearance and behavior of drawing object to be manipulated
|
ShapeType |
The ShapeType class contains the Excel shape types supported by ExcelWriter
|
Shapes |
The Shapes collection contains all Shape objects in the worksheet
|
Style |
ExcelWriter has three style types: CellStyle , GlobalStyle , and NamedStyle
|
Trendline |
A Trendline object represents a series trendline
|
Trendlines |
Trendlines is a collection of all Trendline objects associated with a data series in a chart
|
UpDownBar |
An UpDownBar object represents up/down bars in a line chart
|
ValueAxis |
A ValueAxis object represents a chart's value (y) axis
|
Workbook |
A Workbook object represents an Excel workbook
|
Worksheet |
The Worksheet class represents a single Excel worksheet
|
Worksheets |
The Worksheets class represents the set of worksheets in an Excel workbook
|