image thumbnail

xlcolumn

version 1.0.0.0 (1.56 KB) by Fahad Al Mahmood
Converts Excel column name to column number and vise versa.

3.3K Downloads

Updated 30 Sep 2004

View License

xlcolumn(column)

column: Can be either column name (characters) or column number (positive integers).

NOTE: Excel sheet is limited to 256 columns. Therefore, column number should be between (1-256) and column name should be between ('A' - 'IV').

Example:
xlcolumn('K')
xlcolumn('EQ')
xlcolumn(234)
xlcolumn(19)

Cite As

Fahad Al Mahmood (2021). xlcolumn (https://www.mathworks.com/matlabcentral/fileexchange/5942-xlcolumn), MATLAB Central File Exchange. Retrieved .

MATLAB Release Compatibility
Created with R14
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!