xlsfont, xlsalign, xlsborder, xlswordart, xlscomment

Version 1.0.0.0 (8,64 KB) von Fahad Al Mahmood
5 functions to modify Microsoft Excel cell format & adds comments and WordArt
5.0
(17)
5,1K Downloads
Aktualisiert 9. Jun 2004

Lizenz anzeigen

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)

Zitieren als

Fahad Al Mahmood (2024). xlsfont, xlsalign, xlsborder, xlswordart, xlscomment (https://www.mathworks.com/matlabcentral/fileexchange/4981-xlsfont-xlsalign-xlsborder-xlswordart-xlscomment), MATLAB Central File Exchange. Abgerufen .

Kompatibilität der MATLAB-Version
Erstellt mit R13
Kompatibel mit allen Versionen
Plattform-Kompatibilität
Windows macOS Linux

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Version Veröffentlicht Versionshinweise
1.0.0.0

Added (xlscomment) & (xlswordart)