How to work with certain excel sheets?

조회 수: 3 (최근 30일)
Rodriguez Pham
Rodriguez Pham 2015년 9월 3일
답변: David O'Brien 2015년 9월 3일
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
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)
Source: http://www.mathworks.com/help/matlab/ref/xlsread.html

카테고리

Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기

태그

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by