How to Convert A Matrix into Excel format

1 view (last 30 days)
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

Accepted Answer

Geoff
Geoff on 10 May 2012
Look at the xlswrite function.
doc xlswrite

More Answers (0)

Community Treasure Hunt

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

Start Hunting!