How to preserve column titles from a table created with array2table when I copy and paste into excel
6 次查看(过去 30 天)
显示 更早的评论
Dear all,
My problem is to do with copying and pasting a table created with array2table into excel. I seem to be able to only obtain the data, not the column titles.
This may or may not be an un-necessary step, I have no idea. In fact, given that I need to write code whilst running other program files, I want to send some of the matlab jobs to the departmental cloud computing. The platform that allows me to do that (something called Altair) doesn't allow me to see the workspace that I would ordinarily see using matlab on my pc. I have to explicitly tell matlab to save my results. A colleague of mine runs stuff overnight and his results are figures, so he declares a figure and then uses the print command-that's how he gets out his results when sending jobs to the cloud. If he didn't do that, he'd get nothing once after he runs his stuff. In my case the results are the named matrices created with array2table. So perhaps it's dumb for me to ask you about a way to copy and save into excel whilst preserving column names given that there may be a command that allows me to side-step that?
I look forward to hearing from you.
0 个评论
采纳的回答
KSSV
2019-3-5
Dont copy paste........you need not to convert table to an array. You can straight away table into a excel file using writetable. Read about it.
0 个评论
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Data Distribution Plots 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!