How to Write Table to Excel with headers

16 views (last 30 days)
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 Comments
Peter Perkins
Peter Perkins on 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?
Samantha Brand
Samantha Brand on 5 Jun 2015
I'm looking for column headers, not just the variable name (which I already have as the title of the columns) what is the best function for that.

Sign in to comment.

Answers (1)

Salaheddin Hosseinzadeh
Salaheddin Hosseinzadeh on 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 Comments
Image Analyst
Image Analyst on 3 Jun 2015
Tables and the associated functions like readtable() and writetable() came about in release R2013b I believe.
Salaheddin Hosseinzadeh
Salaheddin Hosseinzadeh on 3 Jun 2015
Edited: Salaheddin Hosseinzadeh on 3 Jun 2015
Alright!
I am using 2012a and it does not have writetable.
Thanks Image Analyst ;)

Sign in to comment.

Community Treasure Hunt

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

Start Hunting!