Creating automated multiple variables to store excel table in a loop

1 次查看（过去 30 天）
NAMAN JAIN
NAMAN JAIN 2020-10-16
评论： NAMAN JAIN 2020-10-21
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
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
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
Gaurav Garg 2020-10-19
Hi Naman,
You can use readtable function to create table from an excel file and then create a loop e.g. -
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 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品


版本

R2019a

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by