xlcolumn
Version 1.0.0.0 (1.56 KB) by
Fahad Al Mahmood
Converts Excel column name to column number and vise versa.
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 (2026). xlcolumn (https://uk.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 LinuxCategories
- MATLAB > Data Import and Analysis > Data Import and Export > Standard File Formats > Spreadsheets >
- MATLAB > External Language Interfaces > COM with MATLAB > Use COM Objects in MATLAB >
Find more on Spreadsheets in Help Center and MATLAB Answers
Tags
Acknowledgements
Inspired by: xlswrite - legacy
Inspired: Example of how to save or read data to an Excel archive.
Discover Live Editor
Create scripts with code, output, and formatted text in a single executable document.
| Version | Published | Release Notes | |
|---|---|---|---|
| 1.0.0.0 |
