MATLAB: Read & Plot to compare Data in Multiple SpreadSheets

excel sheetsMATLAB

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

Best Answer

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
Related Question