Importing Data from excel across multiple sheets and filenames.
228 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Declan Simons
le 25 Août 2016
Commenté : Walter Roberson
le 9 Déc 2023
I am attempting to import multiple strings of data from excel spread sheets and was hoping that the same ranges across multiple sheets could be imported with the same command.
Was thinking it would be a for loop but was unsure how to set it up best.
A total of 8 data sets will be imported from 12 sheets. Any help is greatly appreciated or any questions. :)
3 commentaires
Guillaume
le 25 Août 2016
Yes, you can pass the same range to each call of xlsread, just as you can pass the same arguments to each call of a function.
It's very unclear what problem you are having.
Réponse acceptée
Azzi Abdelmalek
le 25 Août 2016
Modifié(e) : Azzi Abdelmalek
le 25 Août 2016
[~,sheet_name]=xlsfinfo('filename.xlsx')
for k=1:numel(shhet_name)
data{k}=xlsread('filename.xlsx',sheet_name{k})
end
Now all your data are in the variable data. You don't need to associate to each column a variable, because it's a very bad programming practice.
3 commentaires
GreenValleyB
le 30 Juin 2022
is there a way to import data from different worksheets into one variable? Example: variableA contains data from column "B2:B100001" from worksheets X12, X13, X14, X15.
Walter Roberson
le 9 Déc 2023
@Dyuman Joshi points out,
Answer needs to be updated to mention new robust functions such as writematrix(), writetable() and writecell(). And to notify that xlsread() is not recommended to use.
Plus de réponses (2)
Kristian Opsahl
le 12 Sep 2018
Hi,
This code worked fine to import my data. However it does not import the dates that I have in column A on every sheet. Any workaround/solution to that?
1 commentaire
Carlos Riascos
le 17 Fév 2023
I would recommend something like this:
[~,sheet_name]=xlsfinfo('filename.xlsx')
for k=sheet_name
[~,~,data.(k{1})]=xlsread('filename.xlsx',k{1});
end
Note: be careful with not having spaces or unallowed symbols in the sheet_name, otherwise use the command replace.
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!