i have 300 sheets in one worksheet in excel. i wan to import this to matlab. I want to create loop where it reads all sheets and plot graph on a same graph.

Question

Shrutidat 2022-4-10

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1692930-i-have-300-sheets-in-one-worksheet-in-excel-i-wan-to-import-this-to-matlab-i-want-to-create-loop-w

评论： Shrutidat 2022-5-20

[num,txt,raw] = xlsread('C:\Users\varun\OneDrive\Desktop\New folder\medicaldatasheet.xlsx');
Patients = xlsread('C:\Users\varun\OneDrive\Desktop\New folder\medicaldatasheet.xlsx','150','A7:A26');    %% X-axis constant for all plots
C1 = xlsread('C:\Users\varun\OneDrive\Desktop\New folder\medicaldatasheet.xlsx', '150', 'D53:D72');   %% Cancer patients data Y axis of run number 150 (150 sheet name)
H1 = xlsread('C:\Users\varun\OneDrive\Desktop\New folder\medicaldatasheet.xlsx', '150', 'E53:E72');   %%heart prob data y axis of run no 150 (150 sheet name)
L1 = xlsread('C:\Users\varun\OneDrive\Desktop\New folder\medicaldatasheet.xlsx', '150', 'G7:G26');  %% Liver prob values 
B1 = xlsread('C:\Users\varun\OneDrive\Desktop\New folder\medicaldatasheet.xlsx' , '150', 'H7:H26);  %% Bones values 
K1 = xlsread('C:\Users\varun\OneDrive\Desktop\New folder\medicaldatasheet.xlsx', '150' 'I7:I26');   %% Kidney values ..same for next sheet 151asfollows 
C2 = xlsread('C:\Users\varun\OneDrive\Desktop\New folder\medicaldatasheet.xlsx', '151', D53:D72');  next sheet in same workbook (151)
H2 = xlsread('C:\Users\varun\OneDrive\Desktop\New folder\medicaldatasheet.xlsx', '151', E53:E72'); 151 Sheet no 
L2 = xlsread('C:\Users\varun\OneDrive\Desktop\New folder\medicaldatasheet.xlsx', '151', 'G7:G26'); 
B2 = xlsread('C:\Users\varun\OneDrive\Desktop\New folder\medicaldatasheet.xlsx', '151', 'H7:H26');
K2 = xlsread('C:\Users\varun\OneDrive\Desktop\New folder\medicaldatasheet.xlsx', '151', 'I7:I26');    same range goes for all the sheets in workbook. 
plot(patients,C1)
hold on 
plot(patients,C2)
hold off 
plot(patients,H1)medicaldatasheet
hold on 
plot(patients,H2)
plot(patients,B1)
hold on 
plot(patients,B2)
hold off
plot(patients,L1)
hold on 
plot(patients,L2)
hold off 
plot(patients,K1)
hold on 
plot(patients,K2)
hold off

I need all this 5 plots patients Vs C, CD vs patients Vs H, patients Vs B ,patients Vs L, patients Vs K just by mentioning the sheet numbers. for eg as mentioned above 150,151 sheets i want both the values of patients Vs C to be plotted in same graph so used hold on.

3 个评论
显示 1更早的评论隐藏 1更早的评论

Rik 2022-4-23

As I posted in my previous comment: if you disagree with my assessment, contact Mathworks support. I don't see anything that could be considered confidential. Can you explain which parts would be confidential? Can you think of any way to edit your question that would remove the confidential parts, but leave the essence of the question the same?

Shrutidat 2022-4-24

Yes sir now this editing is fine for me. can u pls do the same for the provided answer?

请先登录，再进行评论。

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

Answer 1

VBBV 2022-4-10

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1692930-i-have-300-sheets-in-one-worksheet-in-excel-i-wan-to-import-this-to-matlab-i-want-to-create-loop-w#answer_939140

编辑：Jan 2022-5-20

在 MATLAB Online 中打开

hold all
for I = 1:length(num)
A(:,I) = xlsread('C:\Users\varun\OneDrive\Desktop\New folder\asd.xlsx',num2str(I),'A7:A26'); 
B(:,I) = xlsread('C:\Users\varun\OneDrive\Desktop\New folder\asd.xlsx', num2str(I), 'D53:D72');
C(:,I) = xlsread('C:\Users\varun\OneDrive\Desktop\New folder\asd.xlsx', num2str(I), 'E53:E72');
D(:,I) = xlsread('C:\Users\varun\OneDrive\Desktop\New folder\asd.xlsx',num2str(I), 'G7:G26');
E(:,I) = xlsread('C:\Users\varun\OneDrive\Desktop\New folder\asd.xlsx', num2str(I), 'H7:H26');
F(:,I) = xlsread('C:\Users\varun\OneDrive\Desktop\New folder\asd.xlsx', num2str(I), 'I7:I26');
figure(1)
plot(A(:,I),B(:,I))   % coefficient for all 300 sheets 
figure(2)
plot(A(:,I),C(:,I))  % coefficient for all 300 sheets 
figure(3)
plot(A(:,I),D(:,I))  % 
figure(4)
plot(A(:,I),E(:,I))
figure(5)
plot(A(:,I),F(:,I))
end 