how to read the complex numbers from ms excel?
5 次查看(过去 30 天)
显示 更早的评论
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 个评论
回答(1 个)
Andreas Goser
2012-4-3
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.
3 个评论
Jonathan Sullivan
2012-4-3
Did you try str2double?
a = {'3+2i','9-7i'}; % the data you read in, as a string
cellfun(@str2double,a)
Andreas Goser
2012-4-3
@Jonathan. That should work. @bsd: If not, giving data will allows us to help instead of guess.
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!