xlswrite to write in different columns

44 次查看(过去 30 天)
Is there a way to have xlswrite paste in data into another column besides the first column? I'm trying to write a program to combine different 1 column matrix data into one excel file. I could try putting them in as different sheets in the document, but is there a way to, say, specify that array X is exported into column B of New.xls?

回答(1 个)

Fangjun Jiang
Fangjun Jiang 2011-6-27
Yes. See help xlswrite
XLSWRITE(FILE,ARRAY,SHEET,RANGE)
SUCCESS = XLSWRITE('c:\matlab\work\myworkbook.xls',A,'A2:C4')
Or, it is easier to combine data in MATLAB and then write it once to xls file.

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by