Creating automated multiple variables to store excel table in a loop
显示 更早的评论
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 个评论
Mathieu NOE
2020-10-16
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
2020-10-16
example:
Day1.xlsx , Day2.xlsx and Day3.xlsx
For i:1:3
data_day(i) = readtable('Day',num2str(i),'.xlsx');
end
采纳的回答
Gaurav Garg
2020-10-19
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.
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
