Set excel cell dimension.

Hi everybody, I need to know if it is possible, via matlab, to set excel cells dimensions (width and height) and if it is possible to turn on the option "text wrap".

Thanks

Answer 1

[Friedrich]

Hi,

sure. Here you go:

ex = actxserver('excel.application');
ex.Workbooks.Add
ex.Visible = 1;
ex.Columns.Item('A:A').ColumnWidth = 30;
ex.Rows.Item('1:1').RowHeight = 60;
ex.Range('A1:A1').Select
ex.Selection.WrapText = true;

[Tommaso]

Thank you very much!!

[Tommaso]

May you tell me how to centre (both in width and height) the text written in the cell and how to add borders?

Thanks!!

[Friedrich]

Open Excel, Enable Macro recording and do what you like to do manually. Afterwards take a look at the generated VBA code. This shows what you need to do.