excel sheet with 5rows & 10 columns

1 view (last 30 days)
shaz on 17 Jun 2013
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

Answers (3)

David Sanchez
David Sanchez on 17 Jun 2013
Did you type help xlswrite in the command window?
The documentation in matlab help is very useful too.

Tom on 17 Jun 2013
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 Comment
shaz on 17 Jun 2013
thanks for your answer
can you please tell how to insert a table & put data into the table

Sign in to comment.

Tom on 17 Jun 2013
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;


Community Treasure Hunt

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

Start Hunting!