Set excel cell dimension.

2013 10 30
1 个回答
回答已采纳
更新时间：2013 10 31
6 次查看（30 天）

0 个投票

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

3 个投票

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更早的评论 隐藏 1更早的评论

Tommaso
Tommaso 2013-10-30
Thank you very much!!
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 个）

类别

在 帮助中心 和 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