Saving output in different rows with subsequent runs of my program.

I want to run my program multiple times, and during each run, I want to save data in a same Excel sheet but in the different new row such as

Run 1 output data in A1,

Run 2 output data in A2, and so on and so on.....

Currently my output data keep saving in same row (A1) and overwrites it after the next run. I hope someone can help to answer my problem. Thanks In advance.

Answer 1

[dpb]

See the 'append' value for the 'WriteMode' named parameter in <writetable>.

Far more efficient would be to wrap your code as a function, then call it in a loop saving the output in an array locally, THEN write the output in "one swell foop" instead of opening/closing the file for every row.

[Aries]

Thanks dpb in your suggestion and help. Will try yuor suggestion

[Aries]

Hi dpb,

It works, the data was saving in the different row every run of the program.

However the first row data follow the new data in the last row.

Any comment & suggestion.