How to write column headers into Excel files?

18 Ansichten (letzte 30 Tage)
Leon
Leon am 27 Jan. 2020
Kommentiert: Leon am 27 Jan. 2020
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 Kommentare
Mohammad Sami
Mohammad Sami am 27 Jan. 2020
try using array2table and writetable function.
Leon
Leon am 27 Jan. 2020
Many thanks.
writetable works.

Melden Sie sich an, um zu kommentieren.

Antworten (0)

Produkte


Version

R2019b

Community Treasure Hunt

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

Start Hunting!

Translated by