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 http://www.aspose.com/forums/ShowPost.aspx?PostID=3404 for the usage.