excel sheet with 5rows & 10 columns

1 次查看（过去 30 天）
shaz
shaz 2013-6-17
i would like to create a excel sheet with following information 1) 5rows & 10 columns 2) each column with different colors 3) heading for each column to be bold

请先登录，再回答此问题。

回答（3 个）

David Sanchez
David Sanchez 2013-6-17
Did you type help xlswrite in the command window?
The documentation in matlab help is very useful too.
Tom
Tom 2013-6-17
You'll need to set up an Excel server; see this example
That shows how to change the cell colours. The font is made bold in a similar way, using the selected range:
ran.font.Bold = 1;
  1 个评论
shaz
shaz 2013-6-17
thanks for your answer
can you please tell how to insert a table & put data into the table

请先登录，再进行评论。

Tom
Tom 2013-6-17
The example shows how to put data into the cells:
%Select the appropriate range
ran = h.Activesheet.get('Range',range);
%write the data to the range
ran.value = data;
You can add borders around the cells; here are a couple of examples:
ran.Borders.Item('xlEdgeBottom').LineStyle = 1;
ran.Borders.Item('xlEdgeLeft').Weight = 3;

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by