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 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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 commentaire
Réponses (1)
KSSV
le 10 Mai 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 commentaires
Voir également
Catégories
En savoir plus sur Graphics Object Identification dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!