i want plot 100 sheets of excel data in one plot. in each sheet number of column's are same and i want to plot 3rd column on Y axis and the cycle(sheet number) on y-axis.
조회 수: 1 (최근 30일)
이전 댓글 표시
here i want to plot charging data set of battery as i have 100 sheets of data each sheet represents a cycle of battery i want to plot voltage vs cycle graph of 100 cycles please help me how to do this.
댓글 수: 1
답변 (1개)
KSSV
2023년 5월 10일
file = 'filename.xlsx' ;
[status,sheets] = xlsfinfo(file) ;
N = length(sheets) ;
figure
hold on
for i = 1:N
fprintf('Reading sheet : %s\n',sheets{i}) ;
T = readtable(file,'sheet',sheets{i}) ;
v = T.(1) ;
c = T.(2) ;
plot(v,c)
end
댓글 수: 0
참고 항목
카테고리
Help Center 및 File Exchange에서 Graphics Object Identification에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!