xlswrite_mod

Versión 1.0.0.0 (2,61 KB) por Edmond Ng
Writes data to excel, allows writing to more than 702 (ZZ) columns
0.0
(0)
2,4K descargas
Actualizado 18 dic 2007

Sin licencia

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

Citar como

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

Compatibilidad con la versión de MATLAB
Se creó con R14SP3
Compatible con cualquier versión
Compatibilidad con las plataformas
Windows macOS Linux
Agradecimientos

Inspirado por: xlswrite_mod, xlswrite1

Inspiración para: rician_channel.m

Community Treasure Hunt

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

Start Hunting!

Versión Publicado Notas de la versión
1.0.0.0