Worksheet class represents a single sheet in a workbook
Declaration Syntax Members| All Members | Methods | Properties | |||
|
|
|
|
|||
| Icon | Member | Description |
|---|---|---|
|
AddNamedRange(Range, String) |
Add a named range to the book with limited scope with this sheet
|
|
|
AddRow()()() |
Adds a row at the end of the sheet
|
|
Alignment |
Gets or sets cell alignment options
(Inherited from Styles.) |
|
|
Border |
Gets or sets border settings
(Inherited from Styles.) |
|
|
ColumnCount |
Number of columns in this worksheet
|
|
|
Columns(Int32) |
Returns the column at a given position
|
|
|
CustomFormatString |
Gets or sets custom dispkay format string
(Inherited from Styles.) |
|
|
Delete()()() |
Delete this sheet from the workbook
|
|
|
DeleteColumn(Int32, Boolean) |
Completely removes a column at a given index
|
|
|
DeleteColumn(Int32) |
Completely removes a column at a given index
|
|
|
DeleteColumns(Int32, Int32, Boolean) |
Completely removes a specified a number of columns from a given index
|
|
|
DeleteColumns(Int32, Int32) |
Completely removes a specified a number of columns from a given index
|
|
|
DeleteRow(Int32) |
Deletes a row
|
|
|
DeleteRow(Row) |
Deletes a row
|
|
|
DeleteRow(Int32, Boolean) |
Deletes a row
|
|
|
DeleteRow(Row, Boolean) |
Deletes a row
|
|
|
DeleteRows(Int32, Int32) |
Delete a specific number of rows starting from a row index
|
|
|
DeleteRows(Row, Int32) |
Delete a specific number of rows starting from a row instance
|
|
|
DeleteRows(Int32, Int32, Boolean) |
Delete a specific number of rows starting from a row index
|
|
|
DeleteRows(Row, Int32, Boolean) |
Delete a specific number of rows starting from a row instance
|
|
|
DisplayFormat |
Gets or sets the cell display format
(Inherited from Styles.) |
|
|
Equals(Object) | Determines whether the specified Object is equal to the current Object. (Inherited from Object.) |
|
Finalize()()() | Allows an Object to attempt to free resources and perform other cleanup operations before the Object is reclaimed by garbage collection. (Inherited from Object.) |
|
|
Font |
Gets or sets the font options
(Inherited from Styles.) |
|
|
FreezeLeftColumns |
Gets or sets left freezed column setting
|
|
|
FreezeTopRows |
Gets or sets top freezed row setting
|
|
|
GetEnumerator()()() |
Get a cell enumerator
|
|
|
GetHashCode()()() | Serves as a hash function for a particular type. GetHashCode()()() is suitable for use in hashing algorithms and data structures like a hash table. (Inherited from Object.) |
|
|
GetType()()() | Gets the Type of the current instance. (Inherited from Object.) |
|
|
InsertColumnAfter(Int32) |
Inserts a column after a given column index
|
|
|
InsertColumnBefore(Int32) |
Inserts a column before a given column index
|
|
|
InsertColumnsAfter(Int32, Int32) |
Inserts a specified number of columns after a given column index
|
|
|
InsertColumnsBefore(Int32, Int32) |
Inserts a specified number of columns before a given column index
|
|
|
InsertRowAfter(Int32) |
Inserts a row after another row
|
|
|
InsertRowAfter(Row) |
Inserts a row after another row
|
|
|
InsertRowBefore(Int32) |
Inserts a row before another row
|
|
|
InsertRowBefore(Row) |
Inserts a row before another row
|
|
|
InsertRowsAfter(Int32, Int32) |
Inserts a specific number of rows after a cell
|
|
|
InsertRowsAfter(Row, Int32) |
Inserts a specific number of rows after a cell
|
|
|
InsertRowsBefore(Int32, Int32) |
Inserts a specific number of rows before a row
|
|
|
InsertRowsBefore(Row, Int32) |
Inserts a specific number of rows before a row
|
|
|
Interior |
Gets or sets interior options
(Inherited from Styles.) |
|
|
Item[([(Int32, Int32])]) |
Returns the cell at a given position
|
|
|
Item[([(Int32])]) |
Returns the row at a given position
|
|
|
MemberwiseClone()()() | Creates a shallow copy of the current Object. (Inherited from Object.) |
|
|
Name |
Gets or sets the sheet name
|
|
|
PrintOptions |
Gets or sets various sheet printing options
|
|
|
RowCount |
Returns the number of rows present in the sheet
|
|
|
Style |
Returns the XmlStyle reference of the cell
(Inherited from Styles.) |
|
|
TabColor |
Gets or sets the tab color
|
|
|
ToString()()() | Returns a String that represents the current Object. (Inherited from Object.) |
Remarks
Worksheet class represents a single sheet in a workbook.
You cannot directly declare a instance of a sheet from your code by using new keyword. The only way to access a sheet is to retrieve it from a workbook.
Inheritance Hierarchy| Object | |||
|
CellSettingsApplier | ||
|
|
Styles | ||
|
|
Worksheet | ||