How to write column headers into Excel files?

I'm trying to generate an Excel file with column headers. Below is my code. Why does the generated file do not containt the column header at all?
File_W = 'Output.xlsx';
col_header={'Depth','Parameter_A'};
xlswrite(File_W, col_header, 'Sheet1', 'B1');
xlswrite(File_W, DATA(:,[1,2]), 'Sheet1', 'B2');

2 comentarios

Mohammad Sami
Mohammad Sami el 27 de En. de 2020
try using array2table and writetable function.
Leon
Leon el 27 de En. de 2020
Many thanks.
writetable works.

Iniciar sesión para comentar.

Respuestas (0)

Productos

Versión

R2019b

Preguntada:

el 27 de En. de 2020

Comentada:

el 27 de En. de 2020

Community Treasure Hunt

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

Start Hunting!

Translated by