Spec. Cell exportation from a loop

Question

Michael 2013-10-14

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/90162-spec-cell-exportation-from-a-loop

评论： Michael 2013-10-15

采纳的回答： Azzi Abdelmalek

在 MATLAB Online 中打开

Hi guys,

This is the code:

M = cell(28,1);
for i=1:28;
  M{i} =  UM(i,:);
  IPV = M{i,1}(1);
  IB = M{i,1}(2);
  IWP = M{i,1}(3);
  IK = M{i,1}(4);
  IWS = M{i,1}(5);    
   OptimierungPV_B_WP_mitWaermespeicher_Bandu_14;
   Kapitalwert(i,1)= num2cell(ZFW);
     xlswrite('testsheet.xlsx', ...
     Kapitalwert{i}, ...
     'Kapitalwerte','A1:A28');
end

As you can see, i want to export a specific value from the calculation in line 11. The program does export, but ONLY the value from the first run of the loop, it conitnues writing this value for all the 28 runs of the loop. There must be different values for this of ZFW which is returned as Kapitalwert. Can sb help me to understand and find the error ?

Thanks a lot.

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

Michael 2013-10-14

编辑：Michael 2013-10-14

Sorry, i changed my question due to your commentaries. line 9 is a .m file. ('OptimierungPV_B_WP_mitWaermespeicher_Bandu_14;'). If i make run this program, it returns a ZFW value after running it.

The excel file can be overwritten in each iteration, but i want to export each ZFW being calculated in the extern program in one column. You can be sure that ZFW is generated in this program, but in each run ,it differs from the previous. So i want to export it after each of the 28 runs. If i wasnt able to cvlarify, please tell me, im trying to give another try.

Jan 2013-10-15

No, obviously OptimierungPV_B_WP_mitWaermespeicher_Bandu_14 does not return anything. Therefore I guess it is a script. Scripts have the disadvantage, that they can access all variables of the caller, intentionally and unintentionally. In consequence, you cannot debug the program sufficiently without knowing the source code of the script.

请先登录，再进行评论。

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