Set excel cell dimension.

20 次查看（过去 30 天）
Tommaso
Tommaso 2013-10-30
评论： Friedrich 2013-10-31
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

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

采纳的回答

Friedrich
Friedrich 2013-10-30
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;
  3 个评论
显示 1更早的评论
Tommaso
Tommaso 2013-10-30
编辑：Tommaso 2013-10-30
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
Friedrich 2013-10-31
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.

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by