RemoveSheet123 - remove default Excel sheets

Remove default sheets ("sheet1" ,"sheet2", "sheet3") from an Excel file

Version 1.0.0.0 (4,96 KB)
1,3K Downloads
(4)
1. Apr 2015

Sie verfolgen jetzt diese Einreichung

Anmerkung des Herausgebers: 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

Zitieren als

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

Kategorien

Mehr zu Spreadsheets finden Sie in Help Center und MATLAB Answers

Allgemeine Informationen

Kompatibilität der MATLAB-Version

  • Kompatibel mit allen Versionen

Plattform-Kompatibilität

  • Windows
  • macOS
  • Linux
In neuem Tab öffnen
Version Veröffentlicht Versionshinweise
1.0.0.0