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

jquery - How can I dynamically add a browser tab? -

node.js - Getting the socket id,user id pair of a logged in user(s) -

keyboard - C++ GetAsyncKeyState alternative -