How to Convert A Matrix into Excel format

조회 수: 1 (최근 30일)
H
H 2012년 5월 10일
hello,
I have the following matrices:
[A] = 5000 Rows * 100 Columns;
[B] = 5000 Rows * 100 Columns;
how would i come about in MATLAB to do the following:
[C11]=[column1 of matrix A, column 1 of matrix B] 5000x2
[C22]=[column2 of matrix A, column 2 of matrix B] 5000x2
.
.
.
[C100100] = [column100 of matrix A, column 100 of matrix B] 5000x2
once i got all the [C] matrices... how can would I then export/save each one into a separate excel File automatically in MATLAB
in this case 100 Excel files
thank-you very much for any help

채택된 답변

Geoff
Geoff 2012년 5월 10일
Look at the xlswrite function.
doc xlswrite

추가 답변 (0개)

카테고리

Help CenterFile Exchange에서 Spreadsheets에 대해 자세히 알아보기

Community Treasure Hunt

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

Start Hunting!

Translated by