Number format coming from syms into subs leading to Excel format
조회 수: 1 (최근 30일)
이전 댓글 표시
I have equations that use "syms" variables. After the equations are finished I want to add numbers to the final equations with "subs". These equations are in Matrix form. There are a lot of Matrices so I opted to display them in Excel.
My problem is the number format coming out of the "subs" is different then the "Double" format needed for Excel so I need a way to convert them.
My interface with Excel works flawlessly when no other errors.
rr = exlSheet1.Range(['C' num2str(5)]).value;
theta = exlSheet1.Range(['D' num2str(5)]).value;
for i=1:4
for j=1:4
for k=1:4
Affinity(i,j,k)=subs(Affinity0(i,j,k),{r,h},{rr,theta})
end
end
end
exlSheet1.Range(['I' num2str(3)]).value=Affinity(1,1,1)
exlSheet1.Range(['J' num2str(3)]).value=Affinity(1,1,2)
exlSheet1.Range(['K' num2str(3)]).value=Affinity(1,1,3)
...
Warning: ActiveX - invalid argument type or value.
> In SchwarzchildAnalysis_Excel>Evaluate at 267
exlSheet1 =
Interface.Microsoft_Excel_12.0_Object_Library._Worksheet
댓글 수: 0
답변 (1개)
Walter Roberson
2014년 2월 5일
Affinity(i,j,k) = double(subs(Affinity0(i,j,k),{r,h},{rr,theta}));
댓글 수: 2
Walter Roberson
2014년 2월 5일
At your MATLAB command line, what do you have
format
set to?
Are you referring to the format at the MATLAB level, or at the Excel level?
참고 항목
카테고리
Help Center 및 File Exchange에서 Data Import from MATLAB에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!