Write table to next row of an excel file
6 ビュー (過去 30 日間)
古いコメントを表示
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 件のコメント
Peter Perkins
2017 年 4 月 19 日
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?
回答 (1 件)
参考
カテゴリ
Help Center および File Exchange で Spreadsheets についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!