XLSrange

Version 1.2.0.0 (1,78 ko) par Yvan Lengwiler
The function returns the range address as used by Excel. It is useful in connection with XLSWRITE.
0.0
(0)
526 téléchargements
Mise à jour 20 mai 2010

Afficher la licence

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.

Citation pour cette source

Yvan Lengwiler (2026). XLSrange (https://fr.mathworks.com/matlabcentral/fileexchange/27606-xlsrange), MATLAB Central File Exchange. Extrait(e) le .

Compatibilité avec les versions de MATLAB
Créé avec R2010a
Compatible avec toutes les versions
Plateformes compatibles
Windows macOS Linux
Tags Ajouter des tags
Ouvrir dans un nouvel onglet
Version Publié le Notes de version
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