xlsfont, xlsalign, xlsborder, xlswordart, xlscomment

Version 1.0.0.0 (8,64 ko) par Fahad Al Mahmood
5 functions to modify Microsoft Excel cell format & adds comments and WordArt
5.0
(17)
5,1K téléchargements
Mise à jour 9 juin 2004

Afficher la licence

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)

Citation pour cette source

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. Extrait(e) le .

Compatibilité avec les versions de MATLAB
Créé avec R13
Compatible avec toutes les versions
Plateformes compatibles
Windows macOS Linux

Community Treasure Hunt

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

Start Hunting!

Version Publié le Notes de version
1.0.0.0

Added (xlscomment) & (xlswordart)