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.

Question

nerella bhargav 2023-5-10

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1960594-i-want-plot-100-sheets-of-excel-data-in-one-plot-in-each-sheet-number-of-column-s-are-same-and-i-wa

回答： KSSV 2023-5-10

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更早的评论隐藏 -1更早的评论

Cris LaPierre 2023-5-10

Definitely doable. Please share your code so we can help you.

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

KSSV 2023-5-10

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1960594-i-want-plot-100-sheets-of-excel-data-in-one-plot-in-each-sheet-number-of-column-s-are-same-and-i-wa#answer_1232169

在 MATLAB Online 中打开

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