How to keep Excel template format when using writetable

2018 10 28
1 个回答
更新时间：2018 10 29
4 次查看（30 天）

0 个投票

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?

请先登录，再回答此问题。

回答（1 个）

madhan ravi
madhan ravi 2018-10-28
编辑：madhan ravi 2018-10-28

0 个投票

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

2 个评论
显示 无 隐藏 无

Morteza
Morteza 2018-10-29
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
madhan ravi 2018-10-29
编辑：madhan ravi 2018-10-29
I use 2018b matlab and excel 2016 , it works in mine but no idea what’s the mystery behind yours

请先登录，再进行评论。

类别

在 帮助中心 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

提问:

Morteza
Morteza
2018-10-28

编辑：

madhan ravi
madhan ravi
2018-10-29

Community Treasure Hunt

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

Start Hunting!

Translated by