| 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
|
| Condition |
A Condition object represents a condition within a {a
href="ConditionalFormat.aspx"}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
|
| CopyPasteProperties |
The CopyPasteProperties object represents the types of data that will be copied
from a worksheet when you call the CopyPaste() method.
To create a CopyPasteProperties object, call the CreateCopyPasteProperties() method on a Workbook object.
|
| 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
|
| DataValidation |
A DataValidation object represents a rule for validating data entered in cells
|
| 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
|
| AxisType |
When creating a chart with two X or Y axes (primary and secondary), use AxisType to specify which axis a series is associated with
|
| ObjectPositioning |
|
| Pattern |
Pattern contains all available background patterns for charts and pictures
|
