Code covered by the BSD License  

Highlights from
xlsfont, xlsalign, xlsborder, xlswordart, xlscomment

5.0

5.0 | 7 ratings Rate this file 34 Downloads (last 30 days) File Size: 8.64 KB File ID: #4981

xlsfont, xlsalign, xlsborder, xlswordart, xlscomment

by

 

22 May 2004 (Updated )

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

| Watch this File

File Information
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
Tags for This File   Please login to tag files.
Please login to add a comment or rating.
Comments and Ratings (7)
31 Dec 2013 Mohammad

Super cool

10 Feb 2012 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.

05 Jan 2012 Camille Couzi

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

22 Apr 2009 Sahin Aktas  
10 Apr 2009 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.

25 Nov 2007 J W

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

18 Aug 2007 g l

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

Contact us