how to read the complex numbers from ms excel?

5 次查看（过去 30 天）

bsd 2012-4-3

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/34359-how-to-read-the-complex-numbers-from-ms-excel

Hai,

I have created a matrix in ms excel worksheet consisting of 5 rows and 5 columns. The matrix consists of complex numbers. I have to read this data from matlab. I used the command xlsread(), it is showing an empty matrix.

When I used the command xlsread() to read a matrix of real numbers, it worked.

But for my application I need to read the matrix of complex numbers.

Please suggest me a solution for this.

Looking for your reply.

BSD

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

回答（1 个）

Andreas Goser 2012-4-3

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/34359-how-to-read-the-complex-numbers-from-ms-excel#answer_43069

在 MATLAB Online 中打开

I assume you can get this working by importing the strings/character arrays into MATLAB using XLSREAD.

[num,txt,raw] = xlsread(filename)

As a next step, you and convert ther characters into a real and imaginary part. The code depends a bit on how your data is stored and imported though.