xlcolumn
版本 1.0.0.0 (1.6 KB) 作者:
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)
引用格式
Fahad Al Mahmood (2024). xlcolumn (https://www.mathworks.com/matlabcentral/fileexchange/5942-xlcolumn), MATLAB Central File Exchange. 检索来源 .
MATLAB 版本兼容性
创建方式
R14
兼容任何版本
平台兼容性
Windows macOS Linux类别
- 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 >
在 Help Center 和 MATLAB Answers 中查找有关 Spreadsheets 的更多信息
标签
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!版本 | 已发布 | 发行说明 | |
---|---|---|---|
1.0.0.0 |