MATLAB Answers

How to read two Excel files and assign columns as variables in MATLAB?

47 views (last 30 days)
FW
FW on 4 Apr 2019
Edited: FW on 5 Apr 2019
Hello, I am using MATLAB 2017b. I have two Excel.xlsx files, call them A and B, containing time vs. instrument signals under two different conditions. I would like treat the columns of A and B as variables for performing further operations such division in the Fourier domain. The first column in A.xlsx is "t" and second column "S", and the first column in B.xlsx as X and second one as S0. I checked from the web and youtube videos to use xlsread, how do you assign a variable name to a particle column in MATLAB. Thanks.

  0 Comments

Sign in to comment.

Accepted Answer

Walter Roberson
Walter Roberson on 5 Apr 2019
num = xlsread('A.xlsx');
t = num(:,1);
S = num(:,2);
num = xlsread('B.xlsx');
X = num(:,1);
t0_and_S0 = num(:,2);
or
A = readtable('A.xlsx');
B = readtable('B.xlsx');
t = A.t;
S = A.S;
X = B.X;
t0_and_S0 = B{:,2}; %I do not want to guess the variable name it ended up with

  0 Comments

Sign in to comment.

More Answers (0)

Community Treasure Hunt

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

Start Hunting!