How to insert index table on XLS

Question

Maurizio 2011-10-28

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/19687-how-to-insert-index-table-on-xls

关闭： MATLAB Answer Bot 2021-8-20

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?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

此问题已关闭。

Answer 1

Fangjun Jiang 2011-10-28

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/19687-how-to-insert-index-table-on-xls#answer_26026

在 MATLAB Online 中打开

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');

2 个评论
显示无隐藏无

Maurizio 2011-10-28

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 2011-10-28

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().