xlsread

조회 수: 17 (최근 30일)
Richard
Richard 2011년 12월 1일
Is it possible to say in xlsread to import the last workbook in a spreadsheet? I know its possible to define which workbook you want if you know the name of the workbook but if you dont, is there a statement that says to take the last workbook?

이 질문에 답변하려면 로그인하십시오.

채택된 답변

Fangjun Jiang
Fangjun Jiang 2011년 12월 1일
You could use xlsfinfo() to get the sheet names and then you'll get the last sheet name.
[A, DESCR, FORMAT] = XLSFINFO('FILENAME')
Normally, 'DESCR' will return all the sheet names in a cell array.

추가 답변 (0개)

카테고리

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

태그

Community Treasure Hunt

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

Start Hunting!

Translated by