How to specify column names by writematrix function in Appdesigner?

8 次查看（过去 30 天）
piston_pim_offset
评论： piston_pim_offset 2024-4-22
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 个评论
显示 1更早的评论
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 个）

类别

在 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