Click or drag to resize

ExcelWorksheet Properties

The ExcelWorksheet type exposes the following members.

Properties
  NameDescription
Public propertyCode exampleCells
Gets all the cells in the sheet.
Public propertyCharts
Gets the worksheet charts. Not supported in XLS.
Public propertyColumns
Gets collection of all columns (ExcelColumn) in the worksheet.
Public propertyComments
Gets comments in this sheet.
Public propertyConditionalFormatting

Gets the conditional formatting rules applied on cell ranges of this sheet.

Currently supported in XLSX only.

Public propertyDataValidations
Gets the collection that expresses all data validation information for cells in a sheet which have data validation features applied. Supported in XLSX only.
Public propertyDefaultColumnWidth
Gets or sets the default column width in 1/256th of the width of the zero character in default font.
Public propertyDefaultRowHeight
Gets or sets the default row height in twips (1/20th of a point). Not supported in XLS and ODS.
Public propertyCode exampleFilter

Gets or sets the active AutoFilter. Returns if no AutoFilter is active.

AutoFilter is used to store filter settings and to apply filter on a range of cells.

Active AutoFilter is loaded from and saved to XLSX file.

Public propertyHasHeadersFooters
Returns true if worksheet has headers/footers.
Public propertyHasSplitOrFreezePanes
Returns true if worksheet has split or freeze panes.
Public propertyHeadersFooters
Gets or sets headers/footers for the sheet.
Public propertyCode exampleHorizontalPageBreaks
Gets collection of all horizontal page breaks (HorizontalPageBreak) in the worksheet.
Public propertyHyperlinks
Gets hyperlinks in this sheet.
Public propertyCode exampleIgnoredErrors

Gets the ignored errors applied on cell ranges of this sheet.

Currently supported in XLS and XLSX.

Public propertyIndex
Gets worksheet zero-based index.
Public propertyName
Gets or sets worksheet name.
Public propertyCode exampleNamedRanges
Gets NamedRangeCollection containing descriptive names which are used to represent cells, ranges of cells, formulas, or constant values.
Public propertyPanes
Gets or sets the panes in the worksheet.
Public propertyParent
Gets the parent ExcelFile of this ExcelWorksheet instance.
Public propertyCode examplePictures
Gets the worksheet pictures.
Public propertyCode examplePivotTables

Gets the collection of all PivotTables contained in this worksheet.

Currently supported in XLSX only.

Public propertyPrintOptions
Contains MS Excel print and print related options.
Public propertyProtected
Gets or sets the worksheet protection flag.
Public propertyProtectedRanges
Gets the protected ranges. Supported in XLSX only.
Public propertyProtectionSettings
Gets or sets worksheet protection properties. This settings will be used only if Protected is set to ; Otherwise it will be ignored. Supported in XLSX only.
Public propertyRows
Gets collection of all rows (ExcelRow) in the worksheet.
Public propertySelectedRanges

Gets the selected ranges of cells in the worksheet.

Supported only in XLSX.

Public propertyCode exampleSort

Gets or sets the active SortState. Returns if no SortState is active.

SortState is used to store sort settings and to apply sort on a range of cells.

Active SortState is loaded from and saved to XLSX file.

Public propertyTabColor

Gets or sets the worksheet tab color.

Supported only in XLSX and HTML.

Public propertyType
Gets worksheet type.
Public propertyCode exampleVerticalPageBreaks
Gets collection of all vertical page breaks (VerticalPageBreak) in the worksheet.
Public propertyViewOptions
Contains MS Excel display and view related options.
Public propertyVisibility
Gets or sets the worksheet visible property.
Top
See Also