Xceed Workbooks for .NET v1.4 Documentation
Worksheet Class Methods


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

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

Public Methods
 NameDescription
Public MethodStarts the calculation for all the Worksheet's cells containing a formula and update their Value properties.  
Public MethodClears specific elements in the Worksheet.  
Public MethodOverloaded. Deletes Columns at a specific index in the Worksheet.  
Public MethodOverloaded. Deletes a CellRange and allows to specify in which direction the Cells located after the deleted range will be shifted.  
Public MethodDeletes Rows at a specific index in the Worksheet.  
Public Method

Imports data of type Array, 2D-Array, ArrayList, ICollection, IDictionary, DataTable, DataView or CSV path/stream in a Worksheet.

 
Public MethodOverloaded. Inserts new Columns at a specific index in the Worksheet.  
Public MethodOverloaded. Inserts an empty CellRange and allows to specify in which direction the Cells located after the inserted range will be shifted.  
Public MethodInserts new Rows at a specific index in the Worksheet.  
Public Method

Protects a Worksheet by enabling or disabling specific actions.

This can be done with or without a password.

 
Public MethodSearches into the content of the Worksheet and replaces all occurences of a specific value with a new value.  
Public MethodUnprotects a Worksheet.  
Top
See Also

Reference

Worksheet Class
Xceed.Workbooks.NET Namespace