How to insert index table on XLS

How can I insert a Index table on XLS file?

On matlab I have a matrix with 8colums and 200rows.

I need to insert on the first row of each column the title.

I'm using xlswrite('CO2.xls',A) for exporting the matrix.

Can anybody help me please?

Answer 1

[Fangjun Jiang]

I can think of two ways. First one is to write twice. The second one is to combine the Header and Data and then write once. See if the first one solves your problem.

Header={'colA','colB','colC'};
Data=rand(20,3);
xlswrite('CO2.xls',Header,1,'A1');
xlswrite('CO2.xls',Data,1,'A2');

[Maurizio]

Header={'D','P','g','o','Fu','Fle','Da'};

xlswrite('CO2.xls',Header,1,'A')

if I write the code above the output xls file has only the header. How can I append also the matrix A after the header?

What are A1 and A2?

[Fangjun Jiang]

Run the code in my answer and you'll see. 'A1','A2' is the starting cell position in the spreadsheet that you want to write the data to. Check the help of xlsread().