RemoveSheet123 - remove default Excel sheets

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

現在この提出コンテンツをフォロー中です。

編集メモ: 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

引用

Noam Greenboim (2026). RemoveSheet123 - remove default Excel sheets (https://jp.mathworks.com/matlabcentral/fileexchange/50371-removesheet123-remove-default-excel-sheets), MATLAB Central File Exchange. に取得済み.

謝辞

ヒントを与えたファイル: Islanding Detection In Distributed Generation

一般的な情報

MATLAB リリースの互換性

  • すべてのリリースと互換性あり

プラットフォームの互換性

  • Windows
  • macOS
  • Linux
バージョン 公開済み リリース ノート Action
1.0.0.0