Set excel cell dimension.
35 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Tommaso
am 30 Okt. 2013
Kommentiert: Friedrich
am 31 Okt. 2013
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 Kommentare
Akzeptierte Antwort
Friedrich
am 30 Okt. 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 Kommentare
Friedrich
am 31 Okt. 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.
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Data Import from MATLAB finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!