How to Write Table to Excel with headers
10 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
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 Kommentare
Peter Perkins
am 3 Jun. 2015
Samantha, writetable (unless you tell it otherwise) does write the variable names as column headers in the spreadsheet. What headers are you looking for?
Antworten (1)
Salaheddin Hosseinzadeh
am 3 Jun. 2015
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 Kommentare
Image Analyst
am 3 Jun. 2015
Tables and the associated functions like readtable() and writetable() came about in release R2013b I believe.
Salaheddin Hosseinzadeh
am 3 Jun. 2015
Bearbeitet: Salaheddin Hosseinzadeh
am 3 Jun. 2015
Alright!
I am using 2012a and it does not have writetable.
Thanks Image Analyst ;)
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!