File Exchange

image thumbnail

RemoveSheet123 - remove default Excel sheets

version 1.0.0.0 (4.96 KB) by Noam Greenboim
Remove default sheets ("sheet1" ,"sheet2", "sheet3") from an Excel file

12 Downloads

Updated 01 Apr 2015

View License

Editor's Note: This file was selected as MATLAB Central Pick of the Week

When a new Excel file is created (whether using Matlab or Excel), it always contains 3 defaults sheets. Their names are depended on the language Excel is defined. In English, it's "sheet1", "sheet2" and "sheet3".
It is useless when writing (with XLSWRITE) to a specific sheet.
This function remove those sheets, regardless of their contents.
The code is based on Jiro Doke's answer (link below), and built-in Matlab functions.
http://www.mathworks.com/matlabcentral/answers/2603-add-a-new-excel-sheet-from-matlab#answer_4096

Cite As

Noam Greenboim (2020). RemoveSheet123 - remove default Excel sheets (https://www.mathworks.com/matlabcentral/fileexchange/50371-removesheet123-remove-default-excel-sheets), MATLAB Central File Exchange. Retrieved .

Comments and Ratings (5)

Worked perfectly, thanks!

Paul Smits

Quick and easy.

David Logan

Nice! But as The Pick of the Week says
"Note: This only works on Windows because it relies on the Excel API."

http://blogs.mathworks.com/pick/2015/05/01/remove-default-excel-sheets/

Oren Rosen

MATLAB Release Compatibility
Created with R2013a
Compatible with any release
Platform Compatibility
Windows macOS Linux