xlsread

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?

Answer 1

[Fangjun Jiang]

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.