How to Write Table to Excel with headers
10 ビュー (過去 30 日間)
古いコメントを表示
Hello. I need to write a table from within matlab to an excel sheet. Right now, this is the code I have:
writetable(Check_AirTemp, filename, 'Sheet', 3)
Where the table being inputted has columns and rows. I am looking to the best way to add column headers in excel for each of the three columns in the Check_AirTemp table.
2 件のコメント
Peter Perkins
2015 年 6 月 3 日
Samantha, writetable (unless you tell it otherwise) does write the variable names as column headers in the spreadsheet. What headers are you looking for?
回答 (1 件)
Salaheddin Hosseinzadeh
2015 年 6 月 3 日
Hi Samantha,
I usually use xlswrite() which then I add the headers as soon as I generate the file.
You can give it a try if you like, I haven't heard of writetable() in fact!
2 件のコメント
Image Analyst
2015 年 6 月 3 日
Tables and the associated functions like readtable() and writetable() came about in release R2013b I believe.
Salaheddin Hosseinzadeh
2015 年 6 月 3 日
編集済み: Salaheddin Hosseinzadeh
2015 年 6 月 3 日
Alright!
I am using 2012a and it does not have writetable.
Thanks Image Analyst ;)
参考
カテゴリ
Help Center および File Exchange で Spreadsheets についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!