c# - Delete non-empty worksheets from excel workbook -


i want delete worksheets excel workbook. when program loaded, reads sheets in workbook, lists them in gridview user can select sheets should in output file. when user hits save button, delete worksheets based on selection , save workbook. works. except when there content in worksheet. delete empty worksheets, not worksheets content.

foreach (var item in _view.sheets) {     exc.worksheet ws = wb.worksheets[item.name];     if (!item.include)     {         ws.delete();     } } 

any clues?

try turn off alerts:

    app.displayalerts = false;     foreach (var item in _view.sheets)     {         exc.worksheet ws = wb.worksheets[item.name];         if (!item.include)         {             ws.delete();         }     }     app.displayalerts = true; 

Comments

Popular posts from this blog

Change php variable from jquery value using ajax (same page) -

Pull out data related to my apps from Android Play Store and iOS App Store -

How can I fetch data from a web server in an android application? -