We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

How to Clear the Spreadsheet data?

Platform: Silverlight |
Control: SpreadsheetControl |
Published Date: December 11, 2014 |
Last Revised Date: January 28, 2015
Tags: selection

Spreadsheet control allows you to clear the worksheet by using two ways:

  • ClearData()
  • Clear()

ClearData():

This function clears only the content in each cell of the worksheet. You can use the following code example for reference.

C#

 

Clear():

This function entirely (i.e. content, formatting, merged cells) clears the worksheet.

C#

 

ADD COMMENT
You must log in to leave a comment

Please sign in to access our KB

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon