Using loop in strings for import

Question

Karl 2013-4-30

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/74124-using-loop-in-strings-for-import

回答： Jacob Lynch August 2014-3-24

I have excelfiles with names "2011", "2012", "2013" that i want to read from Matlab. I want to use a for loop reading these excelfiles, since tha names are so alike.

This did not work

for i = 2011:1:2013; xlsread('adress\(i).xlsx');

It does not seem like Matlab interprest the "i" in the string at a number, but onlye as an "i". Anybody know how to solve this?

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Alessandro Renna 2013-5-6

在 MATLAB Online 中打开

You can also use

num2str(i)

to convert the numerical variable i in a string variable and then concatenate it to the string '.xlsx'

So:

    for i=2011:1:2013
        file{i}=xlsread([num2str(i) '.xlsx']);
    end

请先登录，再进行评论。

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

Answer 1

per isakson 2013-4-30

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/74124-using-loop-in-strings-for-import#answer_83963

编辑：per isakson 2013-4-30

在 MATLAB Online 中打开

The number, e.g. 2012, must be converted to a string. Note the double back-slash, "\\"

    for ii = 2011:1:2013
        [ num, txt ] = xlsread( sprintf( 'adress\\%i.xlsx', ii ) );
    end

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Karl 2013-5-6

Thanks!

请先登录，再进行评论。

Answer 2

Jacob Lynch August 2014-3-24

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/74124-using-loop-in-strings-for-import#answer_130081

在 MATLAB Online 中打开

I have a similar problem. I have data taken from multiple machines with variable conditions, and a consistent heirarchy. E.g.

Machine = MAA, MAB, MAC, ..., MBH
Condition = 100, 200, 300, ..., 800
Part = Gold, Platinum, Silver

File = X:\Folder\Machine\Condition_Part\dat.csv

I want to treat text as I would a numerical list in a for loop. Obviously ['MAA' 'MAB' ... 'MBH'] would just concatenate the strings into one, which is not useful. I tried variations of the following and a few functions like strcat to name the file to no avail.

for machine = {'MAA' 'MAB' 'MAC' ... 'MBH'}
  for condition = {'100' '200' '300' ... '800'}
      for part = {'Gold' 'Platinum' 'Silver'}
          CSV = ['X:\Folder\' machine '\' condition '_' part '\dat.csv']
      end
  end