Spec. Cell exportation from a loop

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.

[Jan]

Line 11 is "OptimierungPV_B_WP_mitWaermespeicher_Bandu_14;". I have no idea why this should create the variable "ZFW". In addition the Excel file is overwritten in each iteration. Is this useful or wanted?

Out-commented code increases the confusion of the readers. So better delete it, when you discuss in the forum.

[Michael]

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]

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.

Answer 1

[Azzi Abdelmalek]

Move xlswrite from the loop and put it after:

xlswrite('testsheet.xlsx', cat(1,Kapitalwert{:}),'Kapitalwerte');

[Michael]

the programm put only one value in cell A1:A1

but i need 28 ?