How to load the data from a specific excel files in a loop?

2015 2 20
1 个回答
回答已采纳
更新时间：2015 2 20
2 次查看（30 天）

0 个投票

Hi
I have the data files, and I have to load the data into matlab when ever the condition matches.
The condition should be depended on my file name.
for example the data files are ''1.xlsx 2.xlsx 5.xlsx 8.xlsx''
for i=1:10 if i= the file name, then I have to load the dat in to excel.
my file names are changing frequently, so with out modifying the program I just want to put a condition and load the data.
how to write a condition in this case ?
Thanks.

请先登录，再回答此问题。

 采纳的回答

Sad Grad Student
Sad Grad Student 2015-2-20
编辑：Sad Grad Student 2015-2-20

1 个投票

Try this and let me know if it works!
% cd (<directory containing all the files you want to load>)
allfiles = dir;
allfiles(1:2) = []; %this is because allfiles(1) = . & allfiles(2) = ..
for i = 1:10
if allfiles(i).name == strcat(sprintf('%d',i),'.xlsx')
fname = allfiles(i).name; %or = strcat(sprintf('%d',i),'.xlsx');
f = xlsread(fname);
end
end

更多回答（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