RemoveSheet123 - remove default Excel sheets

버전 1.0.0.0 (4.96 KB) 작성자: Noam Greenboim
Remove default sheets ("sheet1" ,"sheet2", "sheet3") from an Excel file
5.0
(4)
다운로드 수: 1.3K
업데이트 날짜: 2015/4/1

라이선스 보기

편집자 메모: 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://kr.mathworks.com/matlabcentral/fileexchange/50371-removesheet123-remove-default-excel-sheets), MATLAB Central File Exchange. 검색 날짜: .

MATLAB 릴리스 호환 정보
개발 환경: R2013a
모든 릴리스와 호환
플랫폼 호환성
Windows macOS Linux
카테고리
Help Center 및 MATLAB Answers에서 Spreadsheets에 대해 자세히 알아보기
태그 태그 추가

버전 게시됨 릴리스 정보
1.0.0.0