How to clear workbook ?

[Rajendra]

I have a problem to clear the loaded excel sheet from SfSpreadsheet control to clear again.Please guide me how to achieve it?

Scenario:

(1) Browse a excel file from folder and load that to SfSpreadsheet.

(2) I have a context menu on control to clear the current loaded excel sheet.

[Kanimozhi Bharathi]

Hi Rajendra, 

We have prepared a sample based on your requirement of browsing the excel file from button click and clearing the data with context menu of SfSpreadsheet. Please find the sample link for your reference. 

Sample: http://www.syncfusion.com/downloads/support/directtrac/general/ze/WpfApplication8-1797162303 

If you want to remove the sheet in workbook, please find the below UG link for your reference, 

https://help.syncfusion.com/wpf/sfspreadsheet/worksheet-management#insert-and-delete 

Regards 

Kanimozhi B 

[Rajendra]

Dear Kanimozhi,

I asked to clear the workbook and not the active worksheet. For e.g. when you load the SfSpreadsheet control it shows only Sheet1 with empty worksheet.

 

When you load some excel sheet into it, then it create sheets according to the excel.

Here, my requirement is, I have a context menu for Spreadsheet control for clearing the loaded excel sheet from SfSpreadsheet control and display freshly the Sheet1.

[Kanimozhi Bharathi]

Hi Rajendra, 

We have prepared a sample based on your requirement by browsing the excel file from button click and clearing the loaded workbook with the Dispose method of SfSpreadsheet. Please find the sample link for your reference. 

 

Sample: http://www.syncfusion.com/downloads/support/directtrac/general/ze/WpfApplication8_(2)1686540125 

 

Regards 

Kanimozhi B