Excel Column Number To Column Name

Version 1.4.0.0 (1.76 KB) by Matt G
Converts an array of numbers to a cell array of Excel column names
4K Downloads
Updated 3 Aug 2009

View License

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

Cite As

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

MATLAB Release Compatibility
Created with R2006b
Compatible with any release
Platform Compatibility
Windows macOS Linux

Community Treasure Hunt

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

Start Hunting!
Version Published Release Notes
1.4.0.0

Updated summary

1.3.0.0

Fixed bug noted by Malcolm Lidierth.

1.0.0.0

Changed category, added screenshot