XLSrange

版本 1.2.0.0 (1.8 KB) 作者: Yvan Lengwiler
The function returns the range address as used by Excel. It is useful in connection with XLSWRITE.
0.0
(0)
524.0 次下载
更新时间 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