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
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 个评论
piston_pim_offset
piston_pim_offset 2024-4-22
@Tiffany it workes when "append" option is selected for "writemode" in writetable command. But, when I overwrite the data the template is gone.

请先登录,再进行评论。

更多回答(0 个)

Community Treasure Hunt

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

Start Hunting!

Translated by