XLSrange

バージョン 1.2.0.0 (1.78 KB) 作成者: Yvan Lengwiler
The function returns the range address as used by Excel. It is useful in connection with XLSWRITE.
0.0
(0)
ダウンロード: 524
更新 2010/5/20

ライセンスの表示

Example:

M = rand(25,5);

% We start in cell 'B4' (= coordinates [4,2]).
rng = XLSrange(size(M),[4,2]);
% This produces rng = 'B4:F28'.

xlswrite('M.xls',M,'',rng)
% This exports the matrix M into an Excel worksheet named 'M.xls'.

The function admits columns greater than 16384, the maximum column that Excel 2007 can handle. It is therefore well prepared for future Excel versions, but it is your responsibility to make sure that the result is compatible with your Excel version.

引用

Yvan Lengwiler (2024). XLSrange (https://www.mathworks.com/matlabcentral/fileexchange/27606-xlsrange), MATLAB Central File Exchange. に取得済み.

MATLAB リリースの互換性
作成: R2010a
すべてのリリースと互換性あり
プラットフォームの互換性
Windows macOS Linux
カテゴリ
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.2.0.0

I have replaced the previous spaghetti code and made it much more transparent. As a result, the previous limitation up to column 'ZZZ' is gone.
1.1.0.0

Added default for topleft argument. If user does not select topleft cell, the program now chooses 'A1'.
1.0.0.0