Read & Plot to compare Data in Multiple SpreadSheets
조회 수: 15 (최근 30일)
이전 댓글 표시
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
채택된 답변
Turlough Hughes
2019년 10월 9일
편집: Turlough Hughes
2019년 10월 9일
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
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().
추가 답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Data Import from MATLAB에 대해 자세히 알아보기
제품
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!