How to Convert A Matrix into Excel format

1 visualizzazione (ultimi 30 giorni)
H
H il 10 Mag 2012
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

Risposta accettata

Geoff
Geoff il 10 Mag 2012
Look at the xlswrite function.
doc xlswrite

Più risposte (0)

Community Treasure Hunt

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

Start Hunting!

Translated by