Free Support Forum -

Clear the formatting of a range of worksheet cells using Aspose.Cells for .NET in C#

I saw on the forums that it is possible to clear the contents and formatting of a range of cells using the Cells.Clear(…) method.

And you can clear only the contents of a range of cells using the Cells.ClearContents(…) method.

But is there a way to clear the only the formatting (NOT the contents) of either an entire worksheet or a range of cells?


Hi Steve,

Currently there isn’t such a clear format method. I will add it in the following release. It will be available in one or two weeks.


Please download the latest hotfix and try Cells.ClearFormats method.


Just what I wanted. Thanks for the quick response time.