Info

# Pull Out MATLAB Data to One Excel Spreadsheet[HELP!]

1 view (last 30 days)
Xiao Tang on 18 Jul 2012
Closed: MATLAB Answer Bot on 20 Aug 2021
Your opinion is important to me!
First there is a MATLAB code(pseudo code):
for i = 1:2
A(i) = [C(i);D(i)];
B(i) = [E(i);F(i)];
end
The value for A and B in each loop are as follows,
A(1) =
'Rank' 'Ticker' '201205' 'Weight'
[ 1] 'B' [ 0.04] [ 0.03]
[ 2] 'E' [ 0.01] [ 0.10]
A(2) =
'Rank' 'Ticker' '201206' 'Weight'
[ 1] 'X' [ 0.02] [ 0.07]
[ 2] 'Y' [ 0.01] [ 0.11]
B(1) =
'Rank' 'Sector' '201205'
[ 1] 'S' [ 0.02]
[ 2] 'A' [ 0.01]
B(2) =
'Rank' 'Sector' '201206'
[ 1] 'T' [ 0.08]
[ 2] 'Y' [ 0.03]
Now comes to my question. How can I add a code in the loop so that all values of A and B generated from each loop can be pulled out into a single spreadsheet like the following picture?
The trick thing is data should be pulled out in different area of spreadsheet for different i.
BTW this is a simplified version. The actual problem has 500 loops instead of 2. A and B are much more complicated as well.

Mark Whirdy on 18 Jul 2012
Edited: Mark Whirdy on 18 Jul 2012
Append rows of empty cells {''} to the A, B cell-arrays as necessary
e.g.
repmat({''},1,3)