Set Column width of Excel through Matlab

Hi, I tried to set the width of a column but i don't try..

i found a hint here:

http://www.mathworks.com/matlabcentral/fileexchange/23270-set-columns-in-excel-to-auto-fit/content/xlsAutoFitCol.m

and i simply call it (in another file which I open excel) with xlsAutoFitCol('myfile.xls','Sheet1','A:S'); but nothing change... that's what appears to me...

http://imageshack.us/photo/my-images/402/catturahi.png/

and what i want...

http://imageshack.us/photo/my-images/689/cattura1yw.png/

Someone can help me?

Answer 1

[Fangjun Jiang]

Something like this.

ExcelApp=actxserver('excel.application');
ExcelApp.Visible=1;
NewWorkbook=ExcelApp.Workbooks.Open(ExcelFile);   
NewSheet=NewWorkbook.Sheets.Item(1);
NewRange=NewSheet.Range('A1');
NewRange.ColumnWidth=40;

[Vincenzo]

Great Fangjun!!

Music to my ears!!

[Rik]

Minor downside: this requires Windows and Excel.