Delete worksheets in Excel file
- XLSFILE: name of the Excel file
- SHEETS: cell array with the worksheet names, or matrix with positive integers to tell which worksheets are going to be protected. If SHEETS=, all empty sheets will be deleted.
- XLSFILE will be edited
Perfect functionality for my requirements.
I am using to delete the default blank work sheets from a new workbook after my function has created it.
Very useful. I use xlswrite with Worksheet Name as an input argument and always end up with 3 blank sheets at the beginning. This program delete all blank sheets.
Added missing function