Loop filename and variable name

2 views (last 30 days)
Karl
Karl on 8 May 2013
I want to make a loop that loops over the number 2011 in the following script.
[~, ~, raw] = xlsread('Q:\Karl\HH\FUT2013\LOTTE\2011.xlsx','B8:I18');
H2011 = reshape([raw{:}],size(raw));
[~, ~, raw] = xlsread('Q:\Karl\HH\FUT2013\LOTTE\2011.xlsx','B28:I38');
G2011 = reshape([raw{:}],size(raw));
As you can see, "2011" is the filename, but also used in the matrix definitions (H2011, G2011). Also, I call on a specific cell range from the excelfiles (B8:I18, b28:I38).
I have several excelfiles with names "2011", "2012", "2013_1", "2014_1", "2014_1s2" and "2014_1s5". Instead of repeating the excact same commands as aboove by changing "2011" in the filaname and matrix name for all the names mentioned, I wish to make a loop that does this. Does anybody have suggestions?
I have asked the same question before, http://www.mathworks.se/matlabcentral/answers/74778-loop-file-and-variablenames-when-importing, but the answer didn't work.

Answers (1)

Image Analyst
Image Analyst on 8 May 2013
  1 Comment
Karl
Karl on 8 May 2013
I think I get the loading part. The problem is looping over the variable definitions...How do change "H2011" and "G2011" in my example with H(i) and G(i) where i = 2011, 2012, 2013_1, 2014_1, 2014_1s2 and 2014_1s5?

Sign in to comment.

Categories

Find more on Loops and Conditional Statements in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!