資源簡介
matlab批量讀入excel表格,可以讀文件和sheet。非常適用于大批量數據處理,歡迎大家下載!

代碼片段和文件信息
function?newsheet?=?addsheet(WorkSheetsSheet)
%?Add?new?worksheet?Sheet?into?worsheet?collection?WorkSheets.
if?isnumeric(Sheet)
????%?iteratively?add?worksheet?by?index?until?number?of?sheets?==?Sheet.
????while?WorkSheets.Count?????????%?find?last?sheet?in?worksheet?collection
????????lastsheet?=?WorkSheets.Item(WorkSheets.Count);
????????newsheet?=?WorkSheets.Add([]lastsheet);
????end
else
????%?add?worksheet?by?name.
????%?find?last?sheet?in?worksheet?collection
????lastsheet?=?WorkSheets.Item(WorkSheets.Count);
????newsheet?=?WorkSheets.Add([]lastsheet);
end
%?If?Sheet?is?a?string?rename?new?sheet?to?this?string.
if?ischar(Sheet)
????set(newsheet‘Name‘Sheet);
end
end
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2010-08-24?10:19??批量讀寫Excel\
?????文件?????????717??2010-07-24?07:57??批量讀寫Excel\addsheet.m
?????文件????????2701??2010-07-24?08:26??批量讀寫Excel\loadExcels.asv
?????文件????????2744??2010-07-24?08:27??批量讀寫Excel\loadExcels.m
?????文件????????3095??2010-07-24?08:56??批量讀寫Excel\LoadMultiExcels.asv
?????文件????????3110??2010-07-24?08:59??批量讀寫Excel\LoadMultiExcels.m
?????文件?????????149??2010-07-24?09:06??批量讀寫Excel\批量載入說明.txt
- 上一篇:matlab畫ROC曲線
- 下一篇:基于matlab的漢字識別系統和
評論
共有 條評論