xlsread

21 visualizzazioni (ultimi 30 giorni)
Richard
Richard il 1 Dic 2011
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?

Accedi per rispondere a questa domanda.

Risposta accettata

Fangjun Jiang
Fangjun Jiang il 1 Dic 2011
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.

Più risposte (0)

Categorie

Scopri di più su Software Development Tools in Help Center e File Exchange

Tag

Community Treasure Hunt

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

Start Hunting!

Translated by