How to copy a complex matrix in the workspace to an m-file?

1 Ansicht (letzte 30 Tage)
Ismaeel
Ismaeel am 13 Jun. 2017
Kommentiert: Ismaeel am 14 Jun. 2017
I need to copy a large complex matrix from the workspace to be saved in m-file as a matrix (notice the complex sign (i or j or 1i) is not multiplied by (*). Part of the matrix is shown in the picture below.
Notice that I cannot use the code used for generating the matrix in the place (m-file) I work on for some complexity reason. Thanks in advance for your help
  7 Kommentare
Ismaeel
Ismaeel am 14 Jun. 2017
Thanks Adam, unfortunately, it only saves the real part of the complex matrix. I just tried it.
Adam
Adam am 14 Jun. 2017
Does Excel itself even support complex data? You can separate it into real and imaginary parts and save those to their own columns.

Melden Sie sich an, um zu kommentieren.

Akzeptierte Antwort

KSSV
KSSV am 14 Jun. 2017
A = rand(5) ;
B = rand(5) ;
C = A+1i*B ;
C_str = num2str(C);
C_cell = cellstr(C_str);
xlswrite('test.xlsx',C_cell)
  1 Kommentar
Ismaeel
Ismaeel am 14 Jun. 2017
Thank you so much KSSV, it works with some changes in the excel file after being saved. Appreciate it. Thanks also go to Adam and Stephen.

Melden Sie sich an, um zu kommentieren.

Weitere Antworten (0)

Community Treasure Hunt

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

Start Hunting!

Translated by