how to transfer complex results into excel??

when i am copying my complex results using xlsread command its copying only the real part and not imaginary part.please help

[Hikaru]

I'm not sure if I understood your question. You want to copy complex numbers from MATLAB to excel, right? If so, why are you using the xlsread command? How big is the array containing the complex numbers?

[saba]

its a huge array.i cant copy paste it.

[Hikaru]

xlsread Read Microsoft Excel spreadsheet file.

xlswrite Write to Microsoft Excel spreadsheet file.

Answer 1

[Azzi Abdelmalek]

[a,b,c]=xlsread('file.xlsx')
idx=cellfun(@isstr,c)
c(idx)=cellfun(@str2num,c(idx),'un',0)

[saba]

sir i get my results as a matrix whose elements are complex numbers. i need to transfer this matrix to excel with each element stored in a cell as xls file

[Azzi Abdelmalek]

a=[1+i 2 3;4 i 0;-i 2-i 14]
b=arrayfun(@num2str,a,'un',0)
xlswrite('file.xlsx',b)

Answer 2

[Hikaru]

Try this.

Say A is a vector containing the complex numbers.

A = [2+3i;3+i;4-2i]; % example
B = num2str(A);
C = cellstr(B);
xlswrite('filename.xlsx',C)