Write table to next row of an excel file
6 views (last 30 days)
Show older comments
Seems pretty simple but i'm Struggling to do get it right.
All i want to do Is take an existing excel worksheet and add values
filename = 'testdata.xlsx';
A = 'MyVariable';
sheet = 'sheet name';
xlRange = 'Next free row';
xlswrite(filename,A,sheet,xlRange)
What I guess I need to do is define the new row to be written to.
The Reason I'm want to write it as a table rather than an array is because I want the specific Varaiable and Row names to be populated as well.
Any suggestions?
1 Comment
Peter Perkins
on 19 Apr 2017
Sean, I don't see any tables in your code example, and xlswrite doesn't work on tables. Is there a reason to not use writetable?
Answers (1)
See Also
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!