How do you write multiple lists from Matlab to the same excel file?

Question

I have several lists in Matlab that I want to write to the same excel file. I have one list xordered and another list aspl. I do not know the length of the lists till after I run the Matlab program.

I used

data = xlswrite('edgar.xls',fliplr(sortedx'),'A2:A3000')

for the first list but when I tried to write another list to the same file like this I ended up with two different excel files named edgar.xls

asp_data = xlswrite('edagr.xls', fliplr(aspl'), 'B2:B3000')

Is there a way I can write both of these lists into the same excel file? xordered in the A column and aspl in the B column?

Ben Fossen · Accepted Answer · 2010-04-14 05:23:50Z

2

d = [ fliplr(sortedaspl'), fliplr(sortedx')];

Makes a matrix from A2 to B300

data = xlswrite('edgar.xls',d,'A2:B300');

answered Apr 14, 2010 at 5:23

Ben Fossen

1,3517 gold badges21 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How do you write multiple lists from Matlab to the same excel file?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related