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

Answer 1

[Andreas Goser]

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.

[bsd]

I applied your logic. It is taking the numeric complex values as character constants and it is displaying the numeric values within single quotes (i.e. as a character constant). Now how can I use these character constants in the form of real and imaginary parts.

Looking for your reply.

BSD

[Jonathan Sullivan]

Did you try str2double?

a = {'3+2i','9-7i'}; % the data you read in, as a string

cellfun(@str2double,a)

[Andreas Goser]

@Jonathan. That should work. @bsd: If not, giving data will allows us to help instead of guess.