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
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.
0 个评论
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!