이 제출물을 팔로우합니다
- 팔로우하는 게시물 피드에서 업데이트를 확인할 수 있습니다
- 정보 수신 기본 설정에 따라 이메일을 받을 수 있습니다
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 (2026). xlswrite_mod (https://kr.mathworks.com/matlabcentral/fileexchange/18057-xlswrite_mod), MATLAB Central File Exchange. 검색 날짜: .
| 버전 | 퍼블리시됨 | 릴리스 정보 | Action |
|---|---|---|---|
| 1.0.0.0 |
