Read & Plot to compare Data in Multiple SpreadSheets

Question

Raghu Vamsi 2019-10-9

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/484374-read-plot-to-compare-data-in-multiple-spreadsheets

评论： Turlough Hughes 2019-10-10

examplefile.xlsx

Hi,

I have multiple sheets in Excel file which is again created by matlab script. Iam running some iterations in matlab, so the variable names in each sheet of the excel file will same except for the data. I would like to compare the data of same variable in each sheet with a plot.

Could somebody help me with read the data on each sheet and plot them to compare in matlab.

Thanks

Raghu

2 个评论
显示无隐藏无

Ankit 2019-10-9

how your code looks like? where you are facing problem?

Raghu Vamsi 2019-10-9

编辑：Raghu Vamsi 2019-10-9

Hi Ankit,

Thanks for replying. To be frank, i have no code for this solution, I am trying to get help from the community. All i am doing right now is with Excel completely.

I am working on the code as i speak with you and it can read one sheet at a time and plot the data in that sheet.

I am not a matlab user.

a1 = xlsread('examplefile.xlsx','sheet1');

plot (a1(:,1),a1(:,2));

hold on

a1 = xlsread('examplefile.xlsx','sheet2');

plot (a1(:,1),a1(:,2));

hold on

a1 = xlsread('examplefile.xlsx','sheet3');

plot (a1(:,1),a1(:,2));

hold on

a1 = xlsread('examplefile.xlsx','sheet4');

plot (a1(:,1),a1(:,2));

hold off

This is what i have so far and i want to avoid writing so many lines. 4 sheets data is just an example as i have to work on more than 50 sheets with 10 - 20 columns each.

请先登录，再进行评论。

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

Answer 1

Turlough Hughes 2019-10-9

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/484374-read-plot-to-compare-data-in-multiple-spreadsheets#answer_395581

编辑：Turlough Hughes 2019-10-9

在 MATLAB Online 中打开

Hi Raghnu,

I reckon you should store your data in a structure and use dynamic fieldnames to have a fieldname corresponding to each sheet in your file. Try the following:

[~,sheet_name] = xlsfinfo('examplefile.xlsx')
for k = 1:numel(sheet_name)
    [data, vnames{k}] = xlsread('examplefile.xlsx',sheet_name{k});
    s.(sheet_name{k}) = array2table(data,'VariableNames',vnames{k});
end

To plot in a loop then you just do the following:

figure(), hold on
for c = 1:numel(sheet_name)
    plot(s.(sheet_name{c}).(vnames{c}{1}),s.(sheet_name{c}).(vnames{c}{2}))
    larray{c}=vnames{c}{2}
end
l=legend(larray)
set(l,'Interpreter','none')

If you wanted to look at results from an given sheet you just enter the following:

s.Sheet1
s.Sheet2
etc

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

Turlough Hughes 2019-10-10

No problem. Regarding your question, the function has two output arguments and I only wanted the second one. The tilda is just used to ignore the first output argument of xlsinfo().

Turlough Hughes 2019-10-10