How to work with certain excel sheets?

3 vues (au cours des 30 derniers jours)
Rodriguez Pham
Rodriguez Pham le 3 Sep 2015
Réponse apportée : David O'Brien le 3 Sep 2015
So I have an excel file with over 20 excel sheets, is there a way I can use matlab to target a certain sheet so that there wont be a difficult syntax to code.
For example I have a file with sheets labeled 1 - 20, and I want to read in sheet4, how would I use xlsread to readin in sheet4 and not sheet1?

Connectez-vous pour répondre à cette question.

Réponses (1)

David O'Brien
David O'Brien le 3 Sep 2015
Here you go. Specify which sheet by replacing sheet with the sheet name. Read the help doc for more info.
num = xlsread(filename,sheet)
Source: http://www.mathworks.com/help/matlab/ref/xlsread.html

Catégories

En savoir plus sur Spreadsheets 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