How to clear the worksheet content

Aspose.Cells Product Family
1

hi

How to clear the worksheet content. Is there any methods to clear the content
2

Hi,


You may use following methods to removes the formatting, contents, formulas etc. from worksheet cells or range to cells:

Worksheet.Cells.Clear() //Clears all cell objects
Worksheet.Cells.ClearContents() //Clears contents of a range
Worksheet.Cells.ClearFormats() //Clears formatting of a range
Worksheet.Cells.RemoveFormulas() //Removes formulas and replaces the cells with calculated values

Thank you.