IXlSheet Properties
Represents a worksheet in a workbook.
Name | Description |
---|---|
Auto |
Provides access to the collection of column filters. |
Auto |
Gets or sets the cell range for which filtering is enabled. |
Column |
Provides access to the collection of column page breaks in a worksheet. |
Column |
Returns the cell range that contains all custom columns manually generated in the worksheet. |
Conditional |
Provides access to the collection of conditional formatting rules in a worksheet. |
Current |
Gets the index of the column where the document exporter is currently positioned. |
Current |
Gets the outline level of the currently generated group. |
Current |
Gets the index of the row where the document exporter is currently positioned. |
Data |
Gets the cell range that encompasses all cells containing data. |
Data |
Provides access to the collection of data validation rules specified in a worksheet. |
Header |
Provides access to options which determine the worksheet header and footer characteristics. |
Hyperlinks | Provides access to the collection of hyperlinks contained in a worksheet. |
Ignore |
Gets or sets the type of a formula error to be skipped in the worksheet data range. |
Merged |
Provides access to the collection of merged cells in a worksheet. |
Name | Gets or sets the name of the worksheet. |
Outline |
Provides access to the group settings that control the summary row and column location. |
Page |
Gets or sets page margins used to align the worksheet content on a printed page. |
Page |
Gets or sets the page layout and printing options for a worksheet. |
Print |
Gets or sets the cell range to be printed. |
Print |
Gets or sets specific options that control how a worksheet is printed. |
Print |
Provides access to an object used to specify rows and columns to be repeated on every printed page. |
Row |
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. |
Sparkline |
Provides access to a collection of sparkline groups in a worksheet. |
Split |
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. |
View |
Provides access to an object that specifies display settings for a worksheet. |
Visible |
Gets or sets whether the current worksheet is visible, hidden or “very hidden”. |
See Also