My column and row names are not transferring to Excel when I use writetable on App Designer

12 次查看（过去 30 天）
Joseph Lesniak
Joseph Lesniak 2022-6-3
评论： Walter Roberson 2022-6-3
I cannot get the column or row names to transfer to excel when using writetable on App Designer.
app.UITable3.Data=Temperature ; % Temperature is a combination of table 1 and 2
Names={'CH1','CH2','CH3','CH4','CH5','CH6','CH7','CH8','CH9','CH10','CH11','CH12','CH13','CH14','CH15','CH16','CH17','CH18','CH19','CH20'};
app.UITable3.ColumnName=Names; % this table looks correct on the app
LineNumber = 1 ; % Just an example, edit field defines this
InputFile=('Temperature Table Line %s.xlsx');
filename=sprintf(InputFile,LineNumber);
t=table(app.UITable3.Data); % When I don't use this line and the next is "writematrix(app.UITable3.Data,...) I only get values
writetable(t,filename)
In one case I need column names and on table 4 I need both column and row names to export to Excel. What can I do?
Thank you.

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

采纳的回答

dpb
dpb 2022-6-3
Read the writetable doc --
writetable(t,filename,'writevariablenames',1)
There are many other options available as well, see the examples and use what you need to get the desired result.

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品


版本

R2022a

Community Treasure Hunt

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

Start Hunting!

Translated by