ExcelWorksheet Members

Office Open XML

The ExcelWorksheet type exposes the following members.

Constructors

  NameDescription
ExcelWorksheet
A worksheet

Methods

  NameDescription
Column
Provides access to an individual column within the worksheet so you can set its properties.
DeleteRowOverloaded.
Equals
Determines whether the specified Object is equal to the current Object.
(Inherited from Object.)
GetHashCode
Serves as a hash function for a particular type.
(Inherited from Object.)
GetType
Gets the Type of the current instance.
(Inherited from Object.)
GetValueOverloaded.
InsertRowOverloaded.
Row
Provides access to an individual row within the worksheet so you can set its properties.
SelectOverloaded.
SetValueOverloaded.
ToString
Returns the name of the worksheet
(Overrides Object..::.ToString()()().)

Properties

  NameDescription
AutoFilterAddress
Address for autofilter
BackgroundImage
An image displayed as the background of the worksheet.
Cells
Provides access to a range of cells
Comments
Collection of comments
DataValidations
DataValidation defined in the worksheet. Use the Add methods to create DataValidations and add them to the worksheet. Then set the properties on the instance returned.
DefaultColWidth
Get/set the default width of all rows in the worksheet
DefaultRowHeight
Get/set the default height of all rows in the worksheet
Dimension
Dimension address for the worksheet. Top left cell to Bottom right. If the worksheet has no cells, null is returned
Drawings
Collection of drawing-objects like shapes, images and charts
HeaderFooter
A reference to the header and footer class which allows you to set the header and footer for all odd, even and first pages of the worksheet
Hidden
Indicates if the worksheet is hidden in the workbook
Index
The index in the worksheets collection
MergedCells
Addresses to merged ranges
Name
The worksheet's display name as it appears on the tab
Names
Provides access to named ranges
OutLineApplyStyle
Automatic styles
OutLineSummaryBelow
Summary rows below details
OutLineSummaryRight
Summary rows to right of details
PivotTables
Pivottables defined in the worksheet.
PrinterSettings
Printer settings
Protection
Access to sheet protection properties
SelectedRange
Provides access to the selected range of cells
TabColor
Color of the sheet tab
Tables
Tables defined in the worksheet.
View
Returns a ExcelWorksheetView object that allows you to set the view state properties of the worksheet
Workbook
The workbook object
WorksheetXml
The XML document holding the worksheet data. All column, row, cell, pagebreak, merged cell and hyperlink-data are loaded into memory and removed from the document when loading the document.

See Also