Xceed Workbooks for .NET v2.0 Documentation
Worksheet Class Members
Properties  Methods 


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

The following tables list the members exposed by Worksheet.

Public Properties
 NameDescription
Public PropertyAnnotationsGets the Worksheet's AnnotationCollection.  
Public PropertyCellsGets the Worksheet's CellCollection.  
Public PropertyColumnsGets the Worksheet's ColumnCollection.  
Public PropertyDataValidationsGets the DataValidations in the DataValidationCollection.  
Public PropertyHyperlinksGets the Worksheet's HyperlinkCollection.  
Public PropertyIdGets the current Worksheet's Id. A Workbook may contain more than one Worksheet. The first Id starts at 0.  
Public PropertyIsProtectedGets if the Worksheet is currently protected. The default value is false.  
Public PropertyMergedCellsGets the Worksheet's MergedCellCollection.  
Public PropertyName

Gets or sets the Worksheet's name.

 
Public PropertyPageLayoutGets the Worksheet's PageLayout.   
Public PropertyPicturesGets the Worksheet's PictureCollection.  
Public PropertyProtectionGets the WorksheetProtection as a read-only object.  
Public PropertyRowsGets the Worksheet's RowCollection.  
Public PropertySheetViewGets the Worksheet's SheetView.  
Public PropertyTabColorGets or sets the Color for the Worksheet's tab. The default value is null.  
Public PropertyTablesGets the Worksheet's TableCollection.  
Public PropertyTabThemeColorGets or sets the ThemeColor that the Worksheet will use on its tabs. The default value is null.  
Public PropertyVisibilityGets or sets how a Worksheet is displayed. The default setting is Visible.  
Top
Public Methods
 NameDescription
Public MethodCalculateFormulasStarts the calculation process in all the Cells containing a formula and update their Value properties once the process is done.  
Public MethodClearClears specific elements in the Worksheet.  
Public MethodClearAllDataValidationsRemoves all DataValidations in the Worksheet.  
Public MethodDeleteColumnsOverloaded. Deletes Columns at a specific index in the Worksheet.  
Public MethodDeleteRangeOverloaded. Deletes a CellRange and allows to specify in which direction the Cells located after the deleted range will be shifted.  
Public MethodDeleteRowsDeletes Rows at a specific index in the Worksheet.  
Public MethodImportData

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

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

Protects a Worksheet by enabling or disabling specific actions.

This can be done with or without a password.

 
Public MethodRemoveDataValidationRemoves a specific DataValidation from the Worksheet.  
Public MethodReplaceContentSearches into the content of the Worksheet and replaces all occurences of a specific value with a new value.  
Public MethodReplaceContents<TSearch,TNew>Searches into the content of the Worksheet and replaces all instances of the SearchValues with their corresponding NewValues.  
Public MethodUnprotectUnprotects a Worksheet.  
Top
See Also

Reference

Worksheet Class
Xceed.Workbooks.NET Namespace

Send Feedback