image thumbnail

xlswrite_mod

version 1.0.0.0 (2.61 KB) by Edmond Ng
Writes data to excel, allows writing to more than 702 (ZZ) columns

2.4K Downloads

Updated 18 Dec 2007

No License

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

Cite As

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

MATLAB Release Compatibility
Created with R14SP3
Compatible with any release
Platform Compatibility
Windows macOS Linux
Acknowledgements

Inspired by: xlswrite_mod, xlswrite1

Inspired: rician_channel.m

Community Treasure Hunt

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

Start Hunting!