xlswrite to write in different columns
Show older comments
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 Comment
huseyin tas
on 26 Oct 2019
I have the same problem. Can someone help please?
Answers (1)
Fangjun Jiang
on 27 Jun 2011
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.
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!