ExcelWorksheet Members
From Office Open XML
| |
| EPPlus 3.0 |
| ExcelWorksheet Members |
| ExcelWorksheet Class Constructors Methods Properties See Also Send Feedback |
The ExcelWorksheet type exposes the following members.
Constructors
| Name | Description | |
|---|---|---|
 | ExcelWorksheet |
A worksheet
|
Methods
| Name | Description | |
|---|---|---|
| Column |
Provides access to an individual column within the worksheet so you can set its properties.
|
| DeleteRow | Overloaded. |
| Equals | (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.) |
| GetValue | Overloaded. |
| InsertRow | Overloaded. |
| Row |
Provides access to an individual row within the worksheet so you can set its properties.
|
| Select | Overloaded. |
| SetValue | Overloaded. |
| ToString |
Returns the name of the worksheet
(Overrides Object..::.ToString()()().) |
Properties
| Name | Description | |
|---|---|---|
 | 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.
|
