Loading in excel data with loop and plotting

3 次查看（过去 30 天）

显示更早的评论

Benjamin 2018-11-12

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/429433-loading-in-excel-data-with-loop-and-plotting

编辑： Benjamin 2018-11-12

matlab_example.xlsx

在 MATLAB Online 中打开

I took 2 pieces of code and tried to put them together, but it did not work.

When I load in data like this:

S=struct;
S.A600= xlsread(filename,'0.600');
S.A601= xlsread(filename,'0.601');

etc.

and

then do this:

fn = fieldnames(S);
for k = 1:length(fn)
  thisS = S.(fn{k});
  x = thisS(:, 1);
  y = thisS(:, 2);
  fprintf('Printing field #%d.\n', k);
  semilogy(x, y,'-o');
  hold on
  drawnow;
end

Everything works fine, namely because fn is defined correctly. Here, fn is 20x1.

But when I try to load data in with a loop and do this:

filename = 'C:\PATH\variable_analysis.xlsx';
S=struct;
for n=20:-1:1
    A= xlsread(filename,sprintf('0.6%02d',n));
    S(n).data=A;
end
fn = fieldnames(S);
for k = 1:length(fn)
  thisS = S.(fn{k});
  x = thisS(:, 1);
  y = thisS(:, 2);
  fprintf('Printing field #%d.\n', k);
  semilogy(x, y,'-o');
  hold on
  drawnow;
end
grid on;

fn is only a 1x1 cell, so only 1 dataset is plotted.

I know I am making an obvious error somewhere, but I cannot find it.

6 个评论
显示 4更早的评论隐藏 4更早的评论

Bob Thompson 2018-11-12

编辑：Bob Thompson 2018-11-12

If S is 1x20 then you need to use fin = size(S,2). In the size command the number indicates which dimension you're looking at.

Also, now that I'm looking at it again. You don't actually need fn at all. Just replace the loop index with 'for k = 1:size(S,2)' and then use S(k).data in the loop.

Benjamin 2018-11-12