필터 지우기
필터 지우기

How to work with certain excel sheets?

조회 수: 1 (최근 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)

카테고리

Help CenterFile Exchange에서 Spreadsheets에 대해 자세히 알아보기

Community Treasure Hunt

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

Start Hunting!

Translated by