Number format coming from syms into subs leading to Excel format
1 view (last 30 days)
Show older comments
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 Comments
Answers (1)
Walter Roberson
on 5 Feb 2014
Affinity(i,j,k) = double(subs(Affinity0(i,j,k),{r,h},{rr,theta}));
2 Comments
Walter Roberson
on 5 Feb 2014
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?
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!