How to import data from multiple worksheets contained in 1 workbook?
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Purnjay Peshawaria
le 21 Juin 2020
Modifié(e) : Purnjay Peshawaria
le 22 Juin 2020
Hi,
I have a workbook SelfStorageData.xls . It contains 3 worksheets . I want to import data from each of these 3 worksheets as 3 different matrices. Here is my code:
T = readtable('SelfStorageData.xls');
However, I get the following error:
Unable to open file 'SelfStorageData.xls' as a workbook. Check that the file exists, read access is available, and the file is a valid spreadsheet file.
How can this be fixed? Excel Workbook attached.
0 commentaires
Réponse acceptée
Monalisa Pal
le 22 Juin 2020
Modifié(e) : Monalisa Pal
le 22 Juin 2020
You may use the importdata function instead to fetch data in matrix but seeing that you have some non-numeric data, I wouldn't recommend it.
T = importdata('SelfStorageData.xlsx');
Then use variable names to access the individual matrices:
T1 = T.data.ExampleLeases;
T2 = T.data.TypicalMoveIn;
T3 = T.data.TypicalMoveOut;
Alternatively, you may look into https://www.mathworks.com/help/matlab/ref/matlab.io.spreadsheet.spreadsheetimportoptions.html
So, if you need to use the readtable function, you might do something like this. It's much more flexible.
T1 = readtable('SelfStorageData.xlsx', 'Sheet', 'Example Leases');
T2 = readtable('SelfStorageData.xlsx', 'Sheet', 'Typical Move In');
T3 = readtable('SelfStorageData.xlsx', 'Sheet', 'Typical Move out');
Plus de réponses (1)
Walter Roberson
le 22 Juin 2020
Your file is SelfStorageData.xlsx but you try to read SelfStorageData.xls without the final 'x'
2 commentaires
Monalisa Pal
le 22 Juin 2020
Modifié(e) : Monalisa Pal
le 22 Juin 2020
Opps sorry, I missed the attachment. I just followed the comment. Thanks for pointing it out. I'll edit my answer.
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!