MATLAB Answers

Reading complex numbers from Excel

38 views (last 30 days)
Abhinay Priyatham
Abhinay Priyatham on 7 Nov 2019
Answered: Ankit on 8 Nov 2019
Hi,
I have an excel sheet which has one column consisting of series of rows filled with complex numbers
eg:
-0.00340875447356980 - 0.143829744894360i
0.00826437724550120 - 0.0203601960662560i
0.0175899073253476 + 0.0143665796766208i
I have two variables 'a' and 'b'. I would like to import all the real values from the excel sheet to 'a' and all the imaginary values to 'b'.

Accepted Answer

Ankit
Ankit on 8 Nov 2019
Step.1: Reading values from the excel sheet (see attachment).
[num,txt,raw] = xlsread('imag_real.xlsx')
Step.2: Apply a str2double to each cell of a cell array i.e. raw
data = cellfun(@str2double,raw)
Step.3: Storing real values to a and imaginary values to b
a = real(data);b = imag(data);

More Answers (0)

Community Treasure Hunt

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

Start Hunting!