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
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 LinuxCategories
Find more on Spreadsheets in Help Center and MATLAB Answers
Tags
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!Discover Live Editor
Create scripts with code, output, and formatted text in a single executable document.