File Exchange

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.

1 Download

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 .

Comments and Ratings (3)

Carsten Ridder

Craig Miller

Works exactly as intended. Solved a problem for me quickly and kept me from having to write a function.

Hector Fibbs

Thanks for providing all these effort towards linking Matlab and Excel.
I think you should consider releasing a toolbox and updating it instead of dispatching new files seperately.

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!