Click or drag to resize

ChartSheet Methods

The ChartSheet type exposes the following members.

Methods
Name Description
Public method Activate
Makes the current sheet the active sheet. Equivalent to clicking the sheet's tab in MS Excel.
(Inherited from XlsWorksheetBase .)
Protected method AddReference
Increase the quantity of reference. User must use this method when new wrapper on object is created or reference on object stored.
(Inherited from XlsObject .)
Public method AddTextEffectShape
Adds a text effect shape to the worksheet.
(Inherited from XlsWorksheetBase .)
Protected method CheckDisposed
Checks whether object was disposed and throws exception if it was.
(Inherited from XlsObject .)
Public method CheckForSupportGridLine
Chacks for existing gridlines in chart.
(Inherited from XlsChart .)
Public method ClearCellImageCache
Clear Cell image array cache,not delete CellImage in cell.
(Inherited from XlsWorksheetBase .)
Public method Clone(Object)
Clones current instance.
(Inherited from XlsChart .)
Public method Clone(Dictionary String, String , Object, Dictionary Int32, Int32 ) Obsolete.
Clones current instance.
(Inherited from XlsChart .)
Public method Dispose
Dispose object and free resources.
(Inherited from XlsObject .)
Public method Equals
Determines whether the specified object is equal to the current object.
(Inherited from Object .)
Protected method Finalize
Destructor. Call dispose method of current object.
(Inherited from XlsObject .)
Protected method FindParent(Type)
This method is used to find parent with specific type.
(Inherited from XlsObject .)
Protected method FindParent( Type )
Find parent of object.
(Inherited from XlsObject .)
Protected method FindParent(Type, Boolean)
This method is used to find parent with specific type.
(Inherited from XlsObject .)
Protected method FindParents
Finds parent objects.
(Inherited from XlsObject .)
Public method GetHashCode
Serves as the default hash function.
(Inherited from Object .)
Public method GetType
Gets the Type of the current instance.
(Inherited from Object .)
Protected method InitializeCollections
Initializes the collections used by the derived class.
(Inherited from XlsChart .)
Protected method MemberwiseClone
Creates a shallow copy of the current Object .
(Inherited from Object .)
Public method MoveChartsheet
Moves chartsheet into new position.
(Inherited from XlsChart .)
Public method MoveSheet
Moves sheet into new position, including chartsheet and worksheet.
(Inherited from XlsWorksheetBase .)
Protected method OnDispose
Method which can be overriden by users to take any specific actions when object is disposed.
(Inherited from XlsObject .)
Public method Code example Protect(String)
Protects worksheet with password.protect the sheet except select lock/unlock cells.
Examples
The following code illustrates how to protect the sheet except select lock/unlock cells:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Protects the first worksheet's content with password</para><para>worksheet.Protect("123456");</para><para>//Save to file</para><para>workbook.SaveToFile("Protect.xlsx");</para>
(Inherited from XlsWorksheetBase .)
Public method Protect(String, SheetProtectionType)
Protects worksheet with password.
(Inherited from XlsWorksheetBase .)
Protected method ReleaseReference
Decrease quantity of Reference. User must call this method when freeing resources.
(Inherited from XlsObject .)
Public method Select
Selects current tab sheet.
(Inherited from XlsWorksheetBase .)
Public method SelectTab
Adds sheet tab to the selected tab.
(Inherited from XlsWorksheetBase .)
Public method SetChanged
This method should be called after any changes in the worksheet. Sets Saved property of the parent workbook to false.
(Inherited from XlsWorksheetBase .)
Protected method SetParent
Sets parent of the object.
(Inherited from XlsObject .)
Public method SetToDefaultGridlines
Sets to default chart grid lines on chart type or serie type changing.
(Inherited from XlsChart .)
Public method ToString
Returns a string that represents the current object.
(Inherited from Object .)
Public method ToSVGStream
Convert chart to Svg stream
Public method Unprotect
Unprotects this wokrsheet.
(Inherited from XlsWorksheetBase .)
Public method Unprotect(String)
Unprotects this worksheet using specified password.
(Inherited from XlsWorksheetBase .)
Public method Unselect
Unselects current tab sheet if possible.
(Inherited from XlsWorksheetBase .)
Public method Unselect(Boolean)
Unselects current tab sheet if possible.
(Inherited from XlsWorksheetBase .)
Top
See Also