How to clear the worksheet content

[narendrareddy.bandi]

hi

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

[Amjad_Sahi]

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.