Read & Plot to compare Data in Multiple SpreadSheets

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

[Ankit]

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

[Raghu Vamsi]

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]

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

[Raghu Vamsi]

Hi Turlough,

Thanks... The code solves the issue with the example file. I will try to implement it with my actual data file.

I have a question. what is the difference between these two statements

[~,sheet_name] = xlsfinfo('examplefile.xlsx') vs [stauts,sheet_name] = xlsfinfo('examplefile.xlsx')

both return the same result, although i have noticed many coders and you prefer the statement 1.

Raghu

[Turlough Hughes]

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]

Also, if you are happy with this can you accept the answer.