We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

How to clear the worksheet content


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


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.