Add row name from uitable to excel

Hello,

I figured out how to export 'ColumnNames' from uitable to Excel Spreadsheet.

But how would I do the same for 'RowNames'?

Any help will be appreciated.

Thank you!

[Aditya Pathak]

Can you please share the codeline in order to receive help?

Answer 1

[Peng Li]

Better using writetable in this case I think. You can specify WriteRowNames as true.

writetable(yourTable, filename, “WriteRowNames”, 1);

[Peng Li]

function save1_Callback(hObject, eventdata, handles)
[filename,pathname]= uiputfile('*.xls','Save as');
col=get(handles.table1,'columnname')' ;
data=get(handles.table1,'data');
num=[col;data];

% changes 
writetable(handles.table1, filename, 'WriteRowNames', 1);

xlswrite([pathname filename],num);

[Adam Danz]

+1, clean and effective approach.

But only these lines are needed and you should use the full path to the file.

function save1_Callback(hObject, eventdata, handles)
[filename,pathname]= uiputfile('*.xls','Save as');
writetable(handles.table1, fullfile(pathname, filename), 'WriteRowNames', 1);