RemoveSheet123 - remove default Excel sheets

Version 1.0.0.0 (4,96 ko) par Noam Greenboim
Remove default sheets ("sheet1" ,"sheet2", "sheet3") from an Excel file
5.0
(4)
1,3K téléchargements
Mise à jour 1 avr. 2015

Afficher la licence

Note de l’éditeur : 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

Citation pour cette source

Noam Greenboim (2025). RemoveSheet123 - remove default Excel sheets (https://fr.mathworks.com/matlabcentral/fileexchange/50371-removesheet123-remove-default-excel-sheets), MATLAB Central File Exchange. Extrait(e) le .

Compatibilité avec les versions de MATLAB
Créé avec R2013a
Compatible avec toutes les versions
Plateformes compatibles
Windows macOS Linux
Tags Ajouter des tags
Remerciements

A inspiré : Islanding Detection In Distributed Generation

Community Treasure Hunt

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

Start Hunting!

Version Publié le Notes de version
1.0.0.0