How to keep Excel template format when using writetable

3 visualizaciones (últimos 30 días)
Morteza
Morteza el 28 de Oct. de 2018
Editada: madhan ravi el 29 de Oct. de 2018
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?
  2 comentarios
madhan ravi
madhan ravi el 28 de Oct. de 2018
upload your code and datas to export
Morteza
Morteza el 28 de Oct. de 2018
The simple sample code and mentioned template are attached.

Iniciar sesión para comentar.

Iniciar sesión para responder a esta pregunta.

Respuestas (1)

madhan ravi
madhan ravi el 28 de Oct. de 2018
Editada: madhan ravi el 28 de Oct. de 2018
t = readtable ('testFile.xlsx')
t.Var2(1,:) = 4
writetable(t,'testFile.xlsx');
  2 comentarios
Morteza
Morteza el 29 de Oct. de 2018
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 el 29 de Oct. de 2018
Editada: madhan ravi el 29 de Oct. de 2018
I use 2018b matlab and excel 2016 , it works in mine but no idea what’s the mystery behind yours

Iniciar sesión para comentar.

Categorías

Más información sobre Spreadsheets en Help Center y File Exchange.

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by