Write table to next row of an excel file

6 views (last 30 days)
Sean Byrne
Sean Byrne on 19 Apr 2017
Commented: Peter Perkins on 19 Apr 2017
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
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?

Sign in to comment.

Answers (1)

yuanling jing
yuanling jing on 19 Apr 2017
I do not kown

Community Treasure Hunt

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

Start Hunting!