Set excel cell dimension.

11 visualizzazioni (ultimi 30 giorni)
Tommaso
Tommaso il 30 Ott 2013
Commentato: Friedrich il 31 Ott 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

Accedi per rispondere a questa domanda.

Risposta accettata

Friedrich
Friedrich il 30 Ott 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 Commenti
Mostra 1 commento meno recente
Tommaso
Tommaso il 30 Ott 2013
Modificato: Tommaso il 30 Ott 2013
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 il 31 Ott 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.

Accedi per commentare.

Più risposte (0)

Categorie

Scopri di più su Data Import from MATLAB in Help Center e File Exchange

Tag

Community Treasure Hunt

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

Start Hunting!

Translated by