IXlSheet Properties

Represents a worksheet in a workbook.

Name	Description
AutoFilterColumns	Provides access to the collection of column filters.
AutoFilterRange	Gets or sets the cell range for which filtering is enabled.
ColumnPageBreaks	Provides access to the collection of column page breaks in a worksheet.
ColumnRange	Returns the cell range that contains all custom columns manually generated in the worksheet.
ConditionalFormattings	Provides access to the collection of conditional formatting rules in a worksheet.
CurrentColumnIndex	Gets the index of the column where the document exporter is currently positioned.
CurrentOutlineLevel	Gets the outline level of the currently generated group.
CurrentRowIndex	Gets the index of the row where the document exporter is currently positioned.
DataRange	Gets the cell range that encompasses all cells containing data.
DataValidations	Provides access to the collection of data validation rules specified in a worksheet.
HeaderFooter	Provides access to options which determine the worksheet header and footer characteristics.
Hyperlinks	Provides access to the collection of hyperlinks contained in a worksheet.
IgnoreErrors	Gets or sets the type of a formula error to be skipped in the worksheet data range.
MergedCells	Provides access to the collection of merged cells in a worksheet.
Name	Gets or sets the name of the worksheet.
OutlineProperties	Provides access to the group settings that control the summary row and column location.
PageMargins	Gets or sets page margins used to align the worksheet content on a printed page.
PageSetup	Gets or sets the page layout and printing options for a worksheet.
PrintArea	Gets or sets the cell range to be printed.
PrintOptions	Gets or sets specific options that control how a worksheet is printed.
PrintTitles	Provides access to an object used to specify rows and columns to be repeated on every printed page.
RowPageBreaks	Provides access to the collection of row page breaks in a worksheet.
Selection	Provides access to an object that allows you specify the cell selection.
SparklineGroups	Provides access to a collection of sparkline groups in a worksheet.
SplitPosition	Freezes a specific number of rows and columns above and to the left of the specified cell.
Tables	Provides access to the read-only collection of tables contained in the worksheet.
ViewOptions	Provides access to an object that specifies display settings for a worksheet.
VisibleState	Gets or sets whether the current worksheet is visible, hidden or “very hidden”.