How to keep Excel template format when using writetable

22 views (last 30 days)
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?

Answers (1)

madhan ravi
madhan ravi on 28 Oct 2018
Edited: madhan ravi on 28 Oct 2018
t = readtable ('testFile.xlsx')
t.Var2(1,:) = 4
writetable(t,'testFile.xlsx');
  2 Comments
madhan ravi
madhan ravi on 29 Oct 2018
Edited: madhan ravi on 29 Oct 2018
I use 2018b matlab and excel 2016 , it works in mine but no idea what’s the mystery behind yours

Sign in to comment.

Community Treasure Hunt

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

Start Hunting!

Translated by