Xlswrite and copy&paste uitable column names

3 次查看(过去 30 天)
Hi,
I have a uitable which I copy&paste and export. It does not paste the uitable column names to Excel. How can I do it?. Do I have to change something in the property inspector?
In addition, how do I also export also the uitable column names when I am saving the uitable data (using xlswrite).
Thanks

采纳的回答

Jan
Jan 2013-2-17
Copy&Paste duplicates the marked contents, but the headers are not selected. Therefore I'd suggest am extra button or adding a context menu on the Java level. From there you can apply a method similar to Azzi's suggestion considering if the Data are stored as cell or double matrix.

更多回答(1 个)

Azzi Abdelmalek
Azzi Abdelmalek 2013-2-17
编辑:Azzi Abdelmalek 2013-2-17
col=get(t,'columnname')' % t is the handle of your table
data=get(t,'data')
num=[col;data]
xlswrite('file.xls',num)
  5 个评论
Azzi Abdelmalek
Azzi Abdelmalek 2013-2-17
You can delete your file before saving again.
delete([pathname filename])

请先登录,再进行评论。

类别

Help CenterFile Exchange 中查找有关 Workspace Variables and MAT-Files 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by