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

1 view (last 30 days)
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 Comments
Ismaeel
Ismaeel on 14 Jun 2017
Thanks Adam, unfortunately, it only saves the real part of the complex matrix. I just tried it.
Adam
Adam on 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.

Sign in to comment.

Accepted Answer

KSSV
KSSV on 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 Comment
Ismaeel
Ismaeel on 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.

Sign in to comment.

More Answers (0)

Community Treasure Hunt

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

Start Hunting!