Column Converter for Excel

バージョン 1.1.0.0 (2.25 KB) 作成者: Kevin Crosby
Convert Excel column letters to numbers or vice versa, for processing data to/from XLSREAD/XLSWRITE.
ダウンロード: 4.8K
更新 2010/8/2

ライセンスの表示

B = XLSCOL(A) takes input A, and converts to corresponding output B. The input may be a number, a string, an array or matrix, an Excel range, a cell, or a combination of each within a cell, including nested cells and arrays.

The output maintains the shape of the input and attempts to "flatten" the cell to remove nesting.

Numbers and symbols within strings or Excel ranges are ignored.

Examples:
xlscol(256) % returns 'IV'
xlscol('IV') % returns 256
xlscol('A1:IV65536') % returns [1 256]

See more examples in help comments.

Notes:
CELLFUN and ARRAYFUN allow the program to recursively handle multiple inputs. An interesting side effect is that mixed input, nested cells, and matrix shapes can be processed.

Acknowledgment:
I adapted the modular math from Mike Sheppard's program ExcelCol, to properly handle the conversion from column number to strings. His program is at http://www.mathworks.com/matlabcentral/fileexchange/27182-excel-column-conversion

引用

Kevin Crosby (2024). Column Converter for Excel (https://www.mathworks.com/matlabcentral/fileexchange/28343-column-converter-for-excel), MATLAB Central File Exchange. 取得済み .

MATLAB リリースの互換性
作成: R2010a
すべてのリリースと互換性あり
プラットフォームの互換性
Windows macOS Linux
カテゴリ
Help Center および MATLAB AnswersSpreadsheets についてさらに検索
タグ タグを追加
謝辞

ヒントを与えたファイル: xlsrange

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!
バージョン 公開済み リリース ノート
1.1.0.0

Vectorized loop under ISNUMERIC, and added right parenthesis to incorrect example.

1.0.0.0