How to import XLS files with multiple sheets using the Dataset Array function?
조회 수: 1 (최근 30일)
이전 댓글 표시
LS,
I would like to import a XLS file which has multiple worksheets in it using the dataset array function. Is this possible? When I use the standard code below it just imports the first worksheet.
A = dataset('XLSFile',filename,'ParamName',Value)
Your help is much appreciated.
Best regards,
Frits Hermans
댓글 수: 0
답변 (1개)
Oleg Komarov
2011년 5월 3일
example (same type dataset on 2 excel sheets):
A = cell(2,1);
for ii = 1:2 % number of sheets
A{ii} = dataset('XLSFile','test.xlsx','sheet',ii);
end
cat(1,A{:})
댓글 수: 2
Oleg Komarov
2011년 5월 5일
Edit your original post adding the FORMATTED code you're using. In addition post the first three lines of the exceel sheet.
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!