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

Question

FW 2019-4-4

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/454524-how-to-read-two-excel-files-and-assign-columns-as-variables-in-matlab

编辑： FW 2019-4-5

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 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Walter Roberson 2019-4-5

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/454524-how-to-read-two-excel-files-and-assign-columns-as-variables-in-matlab#answer_369157

在 MATLAB Online 中打开

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