Set excel cell dimension.

35 次查看（过去 30 天）

Tommaso 2013-10-30

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/104375-set-excel-cell-dimension

评论： 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

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

采纳的回答

Friedrich 2013-10-30

3
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/104375-set-excel-cell-dimension#answer_113688

在 MATLAB Online 中打开

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 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 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.

请先登录，再进行评论。