xlswrite_mod

버전 1.0.0.0 (2.61 KB) 작성자: Edmond Ng
Writes data to excel, allows writing to more than 702 (ZZ) columns
다운로드 수: 2.4K
업데이트 날짜: 2007/12/18

라이선스 없음

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

인용 양식

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

MATLAB 릴리스 호환 정보
개발 환경: R14SP3
모든 릴리스와 호환
플랫폼 호환성
Windows macOS Linux
카테고리
Help CenterMATLAB Answers에서 Spreadsheets에 대해 자세히 알아보기
도움

받음: xlswrite_mod, xlswrite1

줌: rician_channel.m

Community Treasure Hunt

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

Start Hunting!
버전 게시됨 릴리스 정보
1.0.0.0