IXlSheet Members
In This Article
#Properties
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”. |
#Methods
Name | Description |
---|---|
Begin |
Starts filtering data in the specified cell range. |
Begin |
Starts creating a new group in the worksheet. |
Begin |
Starts creating a new group in the worksheet. |
Create |
Creates a new column in the worksheet and returns the IXl |
Create |
Creates a new column in the worksheet with the specified index. |
Create |
Creates a picture to be inserted into the worksheet. |
Create |
Creates a new row in the worksheet and returns the IXl |
Create |
Creates a new row in the worksheet with the specified index. |
Dispose() | Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources. Inherited from IDisposable. |
End |
Finishes filtering data in the cell range after calling the IXl |
End |
Finalizes the group creation after calling the IXl |
Skip |
Specifies the number of successive columns to be skipped in the worksheet before starting to generate a new column. |
Skip |
Specifies the number of successive rows to be skipped in the worksheet before starting to generate a new row. |
See Also