Set excel cell dimension.
25 views (last 30 days)
Show older comments
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 Comments
Accepted Answer
Friedrich
on 30 Oct 2013
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 Comments
Friedrich
on 31 Oct 2013
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.
More Answers (0)
See Also
Categories
Find more on Data Import from MATLAB in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!