How do we store the results of a loop vertically?

Hi everyone,

Is this a correct way to store the values of a loop vertically in an excel file?

CompiledResults(:,i) = Output

also, what is the difference between this and store option?

Answer 1

[Adam Danz]

> Is this a correct way to store the values of a loop vertically in an excel file?

CompiledResults(:,i) = Output

Well, no. That appears to store values vertically within a variable named CompiledResults, in column i. Check out this page from the documentation on how to write to excel files.

> what is the difference between this and store option

I'm not sure what this means. Are you refering to datastore methods (I doubt it)?

Perhaps adding some more context would help, if this doesn't address your question.

[Wolfgang McCormack]

@Adam Danz Thanks Adam, I guess I wrote the post a bit in a hurry. So, I want the loop runs and store my values vertically for each run in a column. Then, I want to write that to an excel. So, I guess this will do the job of storing data in one clean variable with 100 columns/loops.

[Adam Danz]

Does the loop produce a scalar value (size 1x1) or a vector? The line that you have stores a vector but can easily store a scalar in row j using,

CompiledResults(j,i) = ___