how to transfer complex results into excel??

20 次查看（过去 30 天）
saba
saba 2014-8-7
评论： Hikaru 2014-8-7
when i am copying my complex results using xlsread command its copying only the real part and not imaginary part.please help
  3 个评论
显示 1更早的评论
Hikaru
Hikaru 2014-8-7
xlsread Read Microsoft Excel spreadsheet file.
xlswrite Write to Microsoft Excel spreadsheet file.

请先登录，再进行评论。

请先登录，再回答此问题。

回答（2 个）

Azzi Abdelmalek
Azzi Abdelmalek 2014-8-7
[a,b,c]=xlsread('file.xlsx')
idx=cellfun(@isstr,c)
c(idx)=cellfun(@str2num,c(idx),'un',0)
  2 个评论
saba
saba 2014-8-7
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
Azzi Abdelmalek 2014-8-7
a=[1+i 2 3;4 i 0;-i 2-i 14]
b=arrayfun(@num2str,a,'un',0)
xlswrite('file.xlsx',b)

请先登录，再进行评论。

Hikaru
Hikaru 2014-8-7
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)

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by