xlsfont, xlsalign, xlsborder, xlswordart, xlscomment

Versione 1.0.0.0 (8,64 KB) da Fahad Al Mahmood
5 functions to modify Microsoft Excel cell format & adds comments and WordArt
5.0
(17)
5,1K download
Aggiornato 9 giu 2004

Visualizza la licenza

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)

Cita come

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. Recuperato .

Compatibilità della release di MATLAB
Creato con R13
Compatibile con qualsiasi release
Compatibilità della piattaforma
Windows macOS Linux

Community Treasure Hunt

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

Start Hunting!

Versione Pubblicato Note della release
1.0.0.0

Added (xlscomment) & (xlswordart)