MATLAB: How to Convert A Matrix into Excel format

Question

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

Answer 1

Look at the xlswrite function.

doc xlswrite