Clearing a whole range


I have a need of clearing a whole range of values and sometimes of their formatting. In excel I am able to do it using the range class, and applying the clearcontents. Is there an equivalent way of doing this in aspose.excel? Range object does not have any methods I could see that can do this, nor does cells object.



Thanks for your consideration.

Now you can use Cell.PutValue(null) to clear content of a cell. I will add two methods to clear contents and formatting of a range of cells.

Cells.Clear(…) //Clear contents and formatting of a range
Cells.ClearContents(…) //Clear contents of a range

This feature will be available before the end of next week. Thanks for your waiting.



Please download hotfix 1.8.7. This feature is available. You can refer to for the usage.