Delete worksheets in Excel file

Delete selected worksheets or all empty worksheets in Excel file
2K Downloads
Aktualisiert 3. Jun 2013

Lizenz anzeigen

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

Zitieren als

Guilherme Coco Beltramini (2024). Delete worksheets in Excel file (https://www.mathworks.com/matlabcentral/fileexchange/42054-delete-worksheets-in-excel-file), MATLAB Central File Exchange. Abgerufen.

Kompatibilität der MATLAB-Version
Erstellt mit R2010a
Kompatibel mit allen Versionen
Plattform-Kompatibilität
Windows macOS Linux
Quellenangaben

Inspiriert von: Check if XLS file is open and close it

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!
Version Veröffentlicht Versionshinweise
1.1.0.0

Added missing function

1.0.0.0