MATLAB: Set Column width of Excel through Matlab

columnexcel

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?

Best Answer

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;
Related Question