How to specify column names by writematrix function in Appdesigner?

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!

[piston_pim_offset]

Additionally, when writing data to excell sheet, template is gone (cell colors, text size etc.).

Answer 1

[Tiffany]

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')

[piston_pim_offset]

Thank you. Do you have any suggestion about the excel template?

[Tiffany]

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!

[piston_pim_offset]

@Tiffany it workes when "append" option is selected for "writemode" in writetable command. But, when I overwrite the data the template is gone.