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
Guilherme Coco Beltramini (2021). Delete worksheets in Excel file (https://www.mathworks.com/matlabcentral/fileexchange/42054-delete-worksheets-in-excel-file), MATLAB Central File Exchange. Retrieved .
Just as FYI to anyone else w.r.t. my last comment, you need to FULL filepath.
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.
Inspired by: Check if XLS file is open and close it
Find the treasures in MATLAB Central and discover how the community can help you!Start Hunting!