Worksheet Class

Yogesh.ExcelXml

previous page next page

A Sandcastle Documented Class Library Worksheet Class

Worksheet class represents a single sheet in a workbook

Declaration Syntax

Visual Basic

Visual C++

public class Worksheet : Styles, IEnumerable<Cell>, 
	IEnumerable

Public Class Worksheet _
	Inherits Styles _
	Implements IEnumerable(Of Cell), IEnumerable

public ref class Worksheet : public Styles, 
	IEnumerable<Cell^>, IEnumerable

Members

All Members	Methods	Properties
Public Protected		Instance Static		Declared Inherited

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

Assembly: Yogesh.ExcelXml (Module: Yogesh.ExcelXml) Version: 2.89.501.2158

previous page start next page