How to save Excel file as a variable and pull data from it?
15 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Din N
le 9 Juil 2021
Réponse apportée : Sergio Yanez-Pagans
le 9 Juil 2021
I have an Excel file with several sheets. I would like to first read the whole Excel file and then just pull data from specific sheets. This is what I have now. This works but is very slow and I have to do this for every sheet.
data_prev=readtable('Predictions.xlsx','Sheet','Specific Impulse','Range','A1:A10');
And this is what I would like to do:
k=readtable('Predictions.xlsx');
data_prev(l,etc.)
So, to make it more clear, I just want to read the whole file and store it as a variable ( k for example) and then when I need to read a specific sheet, just use that variable.
I cannot share my Excel file for various reasons, so I am just asking for some guidance.
0 commentaires
Réponse acceptée
Walter Roberson
le 9 Juil 2021
Unfortunately, Mathworks does not provide any method of reading all sheets at the same time.
I am not familiar enough with the Excel object model to know if it is even possible with Excel to fetch data from multiple sheets at the same time.
0 commentaires
Plus de réponses (1)
Sergio Yanez-Pagans
le 9 Juil 2021
Using the Import Data option in the Home tab of MATLAB might be the easiest thing to you assuming you don't have tons of sheets in your Excel file.
0 commentaires
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!