Thread Subject: xlswrite?

Dear All

I have a matrix M of three columns and 100 rows. I like to
export it to Excel. I have to add the lables also.

I am using

Titles = {'Number of Cycles', 'Crack Length','Crack Growth
Rate'}
Labels = {'Cycles', 'a','da/dN'}
Units = {'[Cycles]', '[mm]','[mm/Cycles]'}
[newmatfile, newpath] = uiputfile('*.xls', 'Save As');
filename = [newpath,newmatfile];
if isempty(findstr([newpath,newmatfile],'.xls'))
   filename = [filename,'.xls'];
end

xlswrite(filename, Titles, 1, 'A2')
xlswrite(filename, Labels, 1, 'A3')
xlswrite(filename, Units, 1, 'A4')
xlswrite(filename, M,1, 'A6')

I like to ask if I can auto width the columns in Excel
sheet using any matlab command and also to change the font
size.

Thanks in Advance

Regards

"Cooky Monster" <sharif.uk@gmail.com> wrote in message
<snip>
> I like to ask if I can auto width the columns in Excel
> sheet using any matlab command and also to change the font
> size.


You cannot do this with xlswrite. However, you can do this
by directly accessing the Excel COM server and running
column-width and font-size VB commands on that server. The
same applies to any other formating you may wish to do on
the data. To see how to do this, you can edit xlswrite.m:
It's a relatively long function, but if you ignore the
error-checking parts, you'll see that the actual skeleton is
pretty small.

An alternative is to use the OfficeDoc submission on the
File Exchange:
http://www.mathworks.com/matlabcentral/fileexchange/loadFile.do?objectId=15192

Yair Altman
http://ymasoftware.com