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 view (last 30 days)
Show older comments
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 Comment
Answers (1)
KSSV
on 10 May 2023
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 Comments
See Also
Categories
Find more on Graphics Object Identification in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!