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