how to save a UITable in Excell along with Rows & Column Names (Appdesigner, R2020a)

2 次查看（过去 30 天）
taimour sadiq
taimour sadiq 2020-10-24
评论： Mario Malic 2020-11-8
i have a data in in a variable 'A', i want to save it in excell file with rows and column names as shown in fighure below.
i tried
A = app.d;
filter = {'*.xlsx'};
[file,path] = uiputfile(filter);
filename = fullfile(path,file);
xlswrite(filename,A);
but this only save table not row names(a,b,c,d,e) and colomn names(Data,Average). kindly guide.

请先登录，再回答此问题。

采纳的回答

Mario Malic
Mario Malic 2020-11-1
Use writetable to solve your problem, there's a Name-Value pair that corresponds to your need. Here's the example: https://www.mathworks.com/help/matlab/ref/writetable.html#btydetm-1
  5 个评论
显示 3更早的评论
taimour sadiq
taimour sadiq 2020-11-8
Dear Mario More than Thanks for ur Valuable suupport... all was helpfull but ur sentence that i will not get desired output unless i fill UITable.Data properly... and i focused on that while keeping in mind the directions of documentation... and finally i succedded... both with writing row and columns Names along with UIputfile..
i also want to share one of my mistake due to which it take much long time to achieve desire goal.. actually i was taking average of first column and displaying it in first row of second column... but when we assign row and column names then number of rows for each column should be same... so i changed my data and it works... due to this technical mistake which matlab was promting again and again i was not able to get my output even with proper code and syntax of Writetable.. Dear Mario once Again Thanks and i really appreciate that you Guide in such a way that encourage people for poolish them for troubleshooting...
sharing my working code file for those who will get help from this forum in future.

请先登录，再进行评论。

更多回答（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!

Translated by