Export data from MATLAB table to new table in Excel
51 次查看(过去 30 天)
显示 更早的评论
See image below for reference.
I have created a 5763 x 15 table named 'data' which you can see in my workspace. I am wanting to export all information (including headers) from this table into xlsx.
I thought I'd try code on just 3 columns to see if I could get it working. For all the coding I have tried I receive 'T' as just 3 header columns without any information within the rows.
In the image you will see a few of the many attempts I have tried. Any help would be welcomed!
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/299958/image.png)
0 个评论
采纳的回答
rubindan
2020-5-25
In your case T is a cell array of three strings. The correct form to use would be
id = some_vector_of_numbers;
UTS = anouther_vector;
startSeconds = yet_another_vector;
T = table(id,UTS,startSeconds);
writetable(T,'data.xlsx')
Matlab will use the column names id,UTS, and startSeconds for the header.
2 个评论
rubindan
2020-6-15
I was thinking that id, startSeconds, and UTS are columns in your table, but now I see that your table has 15 columns. In thaty case I do not undesrant what they are.
To save the table as it is just type writetable(data,'data.xlsx')
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
产品
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!