Delete worksheets in Excel file
Delete selected worksheets or all empty worksheets in Excel file
You are now following this Submission
- You will see updates in your followed content feed
- You may receive emails, depending on your communication preferences
Delete worksheets in Excel file
USAGE
xls_delete_sheets(xlsfile)
xls_delete_sheets(xlsfile,sheets)
INPUT
- 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.
OUTPUT
- XLSFILE will be edited
Cite As
Guilherme Coco Beltramini (2026). Delete worksheets in Excel file (https://www.mathworks.com/matlabcentral/fileexchange/42054-delete-worksheets-in-excel-file), MATLAB Central File Exchange. Retrieved .
Acknowledgements
Inspired by: Check if XLS file is open and close it
General Information
- Version 1.1.0.0 (4.28 KB)
MATLAB Release Compatibility
- Compatible with any release
Platform Compatibility
- Windows
- macOS
- Linux
