xlsread

19 vues (au cours des 30 derniers jours)
Richard
Richard le 1 Déc 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?

Connectez-vous pour répondre à cette question.

Réponse acceptée

Fangjun Jiang
Fangjun Jiang le 1 Déc 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.

Plus de réponses (0)

Catégories

En savoir plus sur Software Development Tools dans Help Center et File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by