Reading complex numbers from Excel
17 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
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'.
0 Commenti
Risposta accettata
Ankit
il 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);
0 Commenti
Più risposte (1)
Vedere anche
Categorie
Scopri di più su Spreadsheets in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!