Quickly clear a range's cells' contents and styles

Aspose.Cells Product Family
1

Laurence,

is there a quick way to

- Clear the contents (foruma / value) of a range of cells?
- Reset the range of cells’ styles to default?

If there isn’t at the moment, would it be possible to add method(s) like:

ClearContents()
ResetStyles()

or such? Maybe you will come up with a simpler/better solution.

Another thing: When I set a cell’s style to null it is not being reset to defaults. Isn’t there such a thing as a default cell style?

Kai

2

Hi Kai,

Please check http://www.aspose.com/Products/Aspose.Excel/Api/Aspose.Excel.CellsMembers.html for reference.

You can try Cells.ClearContents method and Cells.ClearFormats method.

3

Hi Laurence,

thanks very much for the hint. I simply didn’t find it Smile

Kai