Creating automated multiple variables to store excel table in a loop
3 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Hi all,
So I have got multiple excel files(.xlsx) named as "day 1 , day 2 , day 3.......day 30" in the order of 288x29. What I want is for Matlab to automatically generate variables in a sequence like "data_day1, data_day2.....data_day30" to store the data from the excel file as a table in a loop, so I can use values from the table to do more calculations.
I am a self-taught newbie and any help would be greatly appreciated!!!!!
thanks for your time,
cheers
2 commentaires
Mathieu NOE
le 16 Oct 2020
hi
could you share some execl file to see how to proceed ?
how do you want to merge the excel file data together ?
Sudhakar Shinde
le 16 Oct 2020
example:
Day1.xlsx , Day2.xlsx and Day3.xlsx
For i:1:3
data_day(i) = readtable('Day',num2str(i),'.xlsx');
end
Réponse acceptée
Gaurav Garg
le 19 Oct 2020
Hi Naman,
for i = 1:3
data_day(i) = readtable('Day',num2str(i),'.xlsx');
end
The name of the file within readtable function should be a string. So, we convert i to a string and then append it to Day and extension .xlsx before passing it as an argument to readtable function.
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Data Import from MATLAB 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!