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)

• Acknowledgements: This submission has inspired the following:; xls2html 1.0 R1
• MATLAB release: MATLAB 6.5 (R13)
• Other requirements: Microsoft Excel
• Other Files: xlsborder.m, ; xlscomment.m, ; xlsfont.m, ; xlswordart.m, ; xlsalign.m

[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]