How to work with certain excel sheets?
이전 댓글 표시
So I have an excel file with over 20 excel sheets, is there a way I can use matlab to target a certain sheet so that there wont be a difficult syntax to code.
For example I have a file with sheets labeled 1 - 20, and I want to read in sheet4, how would I use xlsread to readin in sheet4 and not sheet1?
답변 (1개)
David O'Brien
2015년 9월 3일
Here you go. Specify which sheet by replacing sheet with the sheet name. Read the help doc for more info.
num = xlsread(filename,sheet)
카테고리
도움말 센터 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!