View License

Download apps, toolboxes, and other File Exchange content using Add-On Explorer in MATLAB.

» Watch video

Highlights from
Delete worksheets in Excel file

Join the 15-year community celebration.

Play games and win prizes!

» Learn more

5.0 | 1 rating Rate this file 12 Downloads (last 30 days) File Size: 4.28 KB File ID: #42054 Version: 1.1
image thumbnail

Delete worksheets in Excel file



03 Jun 2013 (Updated )

Delete selected worksheets or all empty worksheets in Excel file

| Watch this File

File Information

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


Check If Xls File Is Open And Close It inspired this file.

Required Products MATLAB
MATLAB release MATLAB 7.10 (R2010a)
Other requirements MS Excel
Tags for This File   Please login to tag files.
Please login to add a comment or rating.
Comments and Ratings (1)
24 Jun 2015 John Chow

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.

03 Jun 2013 1.1

Added missing function

Contact us