How to keep Excel template format when using writetable

Hi. I,m trying to export my data to Excel file by using writetable function, but when I use this function, the destination file format will be reset. How should I do to keep the template format unchanged?

[madhan ravi]

upload your code and datas to export

[Morteza]

The simple sample code and mentioned template are attached.

Answer 1

[madhan ravi]

t = readtable ('testFile.xlsx')

t.Var2(1,:) = 4
writetable(t,'testFile.xlsx');

[Morteza]

It works when I use Matlab R2014a and Excel 2010. But on my laptop, I use Matlab R2018b and Excel 2016 and it doesn't work. The table will be written on Excel file bu the template format will be deleted.

[madhan ravi]

I use 2018b matlab and excel 2016 , it works in mine but no idea what’s the mystery behind yours