xlsfont, xlsalign, xlsborder, xlswordart, xlscomment

5 functions to modify Microsoft Excel cell format & adds comments and WordArt

Description

Look at functions help for more details and descriptions. Also included (PDF) file showing Excel Color Index to be used for specifying colors in those functions.

Examples:

xlsfont('file.xls','Sheet1','whole','font','Courier New');
xlsfont('file.xls','Sheet1','2:2','interior',1,11,4);
xlsfont('file.xls','Sheet1','A1','underline',3);

xlsalign('file.xls','Sheet1','A1:A2','MergeCells',1);
xlsalign('file.xls','Sheet1','A1:A2','Horizontal',3,'WrapText',1);
xlsalign('file.xls','Sheet1','A1:A2','Orientation',90,'ShrinkToFit',1);

xlsborder('file.xls','Sheet1','A1:A2','Box',1,2,1);
xlsborder('file.xls','Sheet1','A1:B2','Cross',6,4,5);
xlsborder('file.xls','Sheet1','A1:A2','EdgeTop',1,2,1,'EdgeBottom',4,3,3);

xlswordart('file.xls','Sheet1',7,'My Profile!',30,'Impact',1,1,50,50);

xlscomment('file.xls','Sheet1','B4','This is my Comment!',1)

• MATLAB release: MATLAB 6.5 (R13)
• Other requirements: Microsoft Excel

[g l]

Not sure why nobody commented. But these are exactly what I am looking for!

[J W]

Very useful, I have been looking for this for long time....

[Aviator]

This is great absolutely handy and well-written. This was what I was looking for for a long time.... Thanks. Keep up the good work.

[Sahin Aktas]

 

[Camille Couzi]

thanks a lot for these very useful functions!!
just one thing, the pdf is not included in the .zip!

[Eric]

Well done. Note to users, to highlight/fill/color a cell in red, use a command something like:
xlsfont('file.xls','Sheet1','A1:A1','interior',3,0,3);

Read the documentation on this script for further explanation.