xlswrite_mod

Version 1.0.0.0 (2,61 KB) von Edmond Ng
Writes data to excel, allows writing to more than 702 (ZZ) columns
2,4K Downloads
Aktualisiert 18. Dez 2007

Keine Lizenz

Modified version of xlswrite_mod. I needed to write to more than 702 columns (ZZ) since with Excel 07 it can support up to 16000 columns (XFD). I added a third character so from ZZ it will become AAA, AAB...AAZ, ABA,ABB,ABC,...ABZ and so forth. Tested upto 2500 columns using a simple matrix and it works. I have not tried using column offset such as when you defined which column to start writing. Feel free to modify/comment and correct it if there is any mistake.

Some simple test:
% test array, create 25x2500, test for
% excel write
for i = 1:25
for j = 1:2500
testArray(i,j) = j;
end
end
filename = 'testArray.xlsx';
xlswrite_mod(testArray(1:25,1:2054),{},{},filename);
% End of testArray

Zitieren als

Edmond Ng (2024). xlswrite_mod (https://www.mathworks.com/matlabcentral/fileexchange/18057-xlswrite_mod), MATLAB Central File Exchange. Abgerufen .

Kompatibilität der MATLAB-Version
Erstellt mit R14SP3
Kompatibel mit allen Versionen
Plattform-Kompatibilität
Windows macOS Linux
Quellenangaben

Inspiriert von: xlswrite_mod, xlswrite1

Inspiriert: rician_channel.m

Community Treasure Hunt

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

Start Hunting!
Version Veröffentlicht Versionshinweise
1.0.0.0