How to specify column names by writematrix function in Appdesigner?
6 次查看(过去 30 天)
显示 更早的评论
I'm working in app designer. I store 4 columns of data to an excell file.
I have already specified the column names in excell and am using "VariableNamingRule", "preserve". But the column names are transformed into Var1, Var2 etc. or all column names are disappeared.
How do l solve this problem?
Thanks in advance!
采纳的回答
Tiffany
2024-4-1
编辑:Tiffany
2024-4-1
A potential workaround would be to first use array2table to convert the array into a table and set the column labels by using the property 'VariableNames'. Then you can use writetable to export the data to an excel file.
writetable(array2table(insert_data, 'VariableNames', insert_col_labels), 'filename.xls')
3 个评论
Tiffany
2024-4-2
The following video details how to save data from MATLAB to Excel using a template: https://www.mathworks.com/videos/saving-data-from-matlab-to-excel-using-a-template-118948.html. I hope this helps!
更多回答(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!