Click or drag to resize
ExcelWorksheetClear Method
Clears this worksheet.

Namespace:  GemBox.Spreadsheet
Assembly:  GemBox.Spreadsheet (in GemBox.Spreadsheet.dll) Version: 41.3.30.1033
Syntax
public void Clear()
Remarks
References to following members will become invalid after calling this method. If they are stored in external variables, you will need to get them again from worksheet.
Examples

For example:

var dataValidations = worksheet.DataValidations;
worksheet.Clear();
// dataValidations variable is no longer associated with worksheet, you need to do following to reacquire it
dataValidations = worksheet.DataValidations;
Here is the list:
See Also