Worksheet Class Methods

Xceed Workbooks for .NET v2.0 Documentation

Worksheet Class Methods

Collapse All

Xceed.Workbooks.NET Assembly > Xceed.Workbooks.NET Namespace : Worksheet Class

For a list of all members of this type, see Worksheet members.

Public Methods

	Name	Description
	CalculateFormulas	Starts the calculation process in all the Cells containing a formula and update their Value properties once the process is done.
	Clear	Clears specific elements in the Worksheet.
	ClearAllDataValidations	Removes all DataValidations in the Worksheet.
	DeleteColumns	Overloaded. Deletes Columns at a specific index in the Worksheet.
	DeleteRange	Overloaded. Deletes a CellRange and allows to specify in which direction the Cells located after the deleted range will be shifted.
	DeleteRows	Deletes Rows at a specific index in the Worksheet.
	ImportData	Imports data of type Array, 2D-Array, ArrayList, ICollection, IDictionary, DataTable, DataView or CSV path/stream in a Worksheet.
	InsertColumns	Overloaded. Inserts new Columns at a specific index in the Worksheet.
	InsertRange	Overloaded. Inserts an empty CellRange and allows to specify in which direction the Cells located after the inserted range will be shifted.
	InsertRows	Inserts new Rows at a specific index in the Worksheet.
	Protect	Protects a Worksheet by enabling or disabling specific actions. This can be done with or without a password.
	RemoveDataValidation	Removes a specific DataValidation from the Worksheet.
	ReplaceContent	Searches into the content of the Worksheet and replaces all occurences of a specific value with a new value.
	ReplaceContents<TSearch,TNew>	Searches into the content of the Worksheet and replaces all instances of the SearchValues with their corresponding NewValues.
	Unprotect	Unprotects a Worksheet.

See Also

Reference

Worksheet Class
Xceed.Workbooks.NET Namespace

Send Feedback