Excel Column Number To Column Name

Versione 1.4.0.0 (1,76 KB) da Matt G
Converts an array of numbers to a cell array of Excel column names
4,1K download
Aggiornato 3 ago 2009

Visualizza la licenza

XLSCOLNUM2STR takes in an array of numbers and returns a cellular array of the same size with cell of corresponding Excel column names.

example:
n=[1 10;
53 256]
c=xlsColNum2Str(n);
c={'A' , 'J';
'BA', 'IV'}

See Also XLSCOLSTR2NUM

Cita come

Matt G (2025). Excel Column Number To Column Name (https://it.mathworks.com/matlabcentral/fileexchange/15748-excel-column-number-to-column-name), MATLAB Central File Exchange. Recuperato .

Compatibilità della release di MATLAB
Creato con R2006b
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.4.0.0

Updated summary

1.3.0.0

Fixed bug noted by Malcolm Lidierth.

1.0.0.0

Changed category, added screenshot