xlcolumn
버전 1.0.0.0 (1.56 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 |