# How to save data in for loop to excel

조회 수: 18(최근 30일)
댓글: Walter Roberson 2022년 1월 14일
I have 2 value in loop show that
T0 = [1035 1200];%K
for i = 1:length(T0)
L0 = [0 5e-6] ;%m
yi0 = [1 0 0] ;%molfrac(ya0 yb0 yc0)
P0 = 162.*yi0 ;%kPa
v0 = 2.037e-3 ;%m3/s (volumetric flowrate)
R = 8.314e-3 ;%(kPa*m3)/(kmol*K)
Fi0 = (P0.*v0)./(R.*T0(i)) ;%[Fa Fb Fc][mol/s mol/s mol/s]
Var0 = [Fi0 T0(i)] ;
[L ,Vary] = ode45(@Try_loop,L0,Var0) ;
end
So I want to save every value i in different file in excel for example when i = 1035 and code run to end then save result calculate of 1035 in excel. I don't know how to save it not to overlap on the same value.
##### 댓글 수: 2표시숨기기 이전 댓글 수: 1
I want 1035 different sheets in the same file.

댓글을 달려면 로그인하십시오.

### 채택된 답변

David Sanchez 2022년 1월 14일
Hi Jidapa, type in your matlab terminal
doc xlswrite
This will give you lots of information about how to do it.
As an example, to write data given by the variable "A" in sheet "2" starting in cell "E1", you just use the following code:
filename = 'testdata.xlsx';
A = {'Time','Temperature'; 12,98; 13,99; 14,97};
sheet = 2;
xlRange = 'E1';
xlswrite(filename,A,sheet,xlRange)
In your case, "sheet = i" should work, simply adapt the rest of the example to your needs ;)
##### 댓글 수: 1표시숨기기 없음
Walter Roberson 2022년 1월 14일
These days we would recommend writetable() or writematrix(), with the 'Sheet' parameter.

댓글을 달려면 로그인하십시오.

### Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!