XLSrange
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.
Cita come
Yvan Lengwiler (2024). XLSrange (https://www.mathworks.com/matlabcentral/fileexchange/27606-xlsrange), MATLAB Central File Exchange. Recuperato .
Compatibilità della release di MATLAB
Compatibilità della piattaforma
Windows macOS LinuxCategorie
Tag
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!Scopri Live Editor
Crea script con codice, output e testo formattato in un unico documento eseguibile.
Versione | Pubblicato | Note della release | |
---|---|---|---|
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 |