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 visualización (últimos 30 días)
Mostrar comentarios más antiguos
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 comentario
Respuestas (1)
KSSV
el 10 de Mayo de 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 comentarios
Ver también
Categorías
Más información sobre Graphics Object Identification en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!