Viable format that would satisfy the requirements for transfering from Matlab to Excel.
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
I am dealing with a 4x4x4 matrix. It is easier to sent the results to Excel. I have the format as a "double" but Matlab does not like that when sending to Excel. Is there a viable format that would satisfy the requirements for transfering from Matlab to Excel.
Program:
exl = actxserver('excel.application');
exlWkbk = exl.Workbooks;
exlFile = exlWkbk.Open(['C:\MATLAB7\work\Analysis_Excel.xlsm']);
exlSheet1 = exlFile.Sheets.Item('Sheet1');
exl.visible = true;
for i=1:4
for j=1:4
for k=1:4
Affinity(i,j,k)=double(subs(Affinity0(i,j,k),{r,h},{7000,0.7071}))
end
end
end
exlSheet1.Range(['C' num2str(3)]).value=Affinity(1,1,1)
exlSheet1.Range(['D' num2str(3)]).value=Affinity(1,1,2)
...
Error code:
Warning: ActiveX - invalid argument type or value.
> In Analysis_Excel>Evaluate at 82
exlSheet1 =
Interface.Microsoft_Excel_12.0_Object_Library._Worksheet
What type or value do they mean? Format other than double?
0 commentaires
Réponses (0)
Voir également
Catégories
En savoir plus sur Use COM Objects in MATLAB dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!