Access Keys:
Skip to content (Access Key - 0)


  • 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.
  • Axis — An Axis object represents a chart axis. The Axis class has two sub-classes: CategoryAxis and ValueAxis.
  • 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 <dotnet>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.
  • CharacterRun — The CharacterRun class allows you to set a font on a specified range of characters within a ChartText object or a cell. To return a CharacterRun object, use Cell.GetCharacters() or ChartText.GetCharacters().
  • 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.
  • ChartFillPattern
  • 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. To return a ChartPageSetup object, use Chart.PageSetup
  • ChartRegion — A ChartRegion object represents either a chart area or plot area. The following classes extend ChartRegion : AxisLabel, ChartText, Legend, DataPoint, and SeriesDataLabel.
  • 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.
  • ChartSettings3D — The ChartSettings3D class contains the set of properties specific to three-dimensional charts. To return a ChartSettings3D object, use Chart.ChartSettings3D.
  • Chartsheet — A Chartsheet object represents a worksheet that contains only a chart.
  • ChartText — A ChartText object represents a region in a chart where text is displayed (e.g., a chart title). The ChartText extends ChartRegion.
  • ChartTextCollection — The ChartTextCollection contains all ChartText objects in the specified chart..
  • 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.
  • 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. A Comment must be associated with a cell, and may only be created using set Comment.Visible to true.
  • Comments — The Comments collection contains all Comment objects in the worksheet. To return a Comments collection, use Worksheet.Comments.
  • 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.
  • CopyPasteProperties — The CopyPasteProperties object represents the types of data that will be copied from a worksheet when you call the CopyPaste() method.
  • DataImportProperties — The DataImportProperties contains a set of properties that can be used when importing data into a Worksheet or Area. To return a DataImportProperties object, call Workbook.CreateDataImportProperties.
  • DataLabelPlacementType — The possible positions of a data label relative to its data point.
  • DataPoint — A DataPoint object represents a data point in a chart. To return a DataPoint object, use Series[i].
  • DataPointMarker — The DataPointMarker class represents the style and formatting of data markers in line, radar, and scatter charts. To return a DataPointMarker object, use Series.DataPointMarker.
  • DataValidation — A DataValidation object represents a rule for validating data entered in cells. The rule may be applied to a cell or a set of cells. The Workbook class contains several CreateDataValidation methods for creating DataValidation objects. To apply a DataValidation object to a cell or group of cells, use Area.SetDataValidation or Range.SetDataValidation.
  • DocumentProperties — The DocumentProperties object represents properties of a spreadsheet. These properties are displayed in the file's Properties sheet which can be opened in Excel (File -> Properties), or by right-clicking the file icon and selecting "Properties." The DocumentProperties class can be used to remove personal information from an existing spreadsheet, or to populate searchable fields that can be used to locate the file.
  • ErrorBar — An ErrorBar object represents series error bars. 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.
  • HeaderFooterPicture — A HeaderFooterPicture object represents a picture embedded in a Header or Footer.
  • 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). To create a Hyperlink object, call Cell.CreateHyperlink or Area.CreateHyperlink. To get an existing Hyperlink, use
  • Hyperlinks — The Hyperlinks collection contains all hyperlinks in a worksheet. The Worksheet.Hyperlinks property returns a Hyperlinks collection.
  • 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 charts and 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.
  • Range — A Range object represents a range in a workbook.
  • RowProperties — The RowProperties class represents a single row in a worksheet. To return a RowProperties object, use Worksheet.GetRowProperties.
  • Series — A Series object represents a single data series in a chart. To return a Series object, use one of the SeriesCollection.CreateSeries methods.
  • 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. To return a SettingsBarColumn object,
  • SettingsLineAreaScatter — The SettingsLineAreaScatter class contains all settings that are specific to line, area, and scatter charts. To return a SettingsLineAreaScatter object,
  • SettingsPieDoughnut — The SettingsPieDoughnut class contains all settings that are specific to pie and doughnut charts. To return a SettingsPieDoughnut object,
  • 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.
  • Shapes — The Shapes collection contains all Shape objects in the worksheet. To return a Shapes collection, use Worksheet.Shapes.
  • ShapeType — The ShapeType class contains the Excel shape types supported by ExcelWriter.
  • Style — ExcelWriter has three style types: CellStyle, GlobalStyle, and NamedStyle.
  • Trendline — A Trendline object represents a series trendline. To create a Trendline object, call Trendlines.CreateTrendline .
  • Trendlines — Trendlines is a collection of all Trendline objects associated with a data series in a chart. To return a Trendlines collection, use Series.Trendlines .
  • 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 .
  • Workbook — A Workbook object represents an Excel workbook. To return a Workbook object: Call ExcelApplication.Create() to create a new Excel workbook. Call ExcelApplication.Open() to open an existing Excel workbook.
  • Worksheet — The Worksheet class represents a single Excel worksheet.
  • 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.
 Programmer's Reference ExcelTemplate Programmer's Reference
Adaptavist Theme Builder Powered by Atlassian Confluence