Importing excel data containing previously defined variables

jvont

2017 11 11

1 个回答

回答已采纳

18 次查看（30 天）

0 个投票

I have a sheet of excel data which contains variables such as x and y. Is there a way to, given the data is defined in the MATLAB workspace, print an array of values based on what x and y are?

x=5;
y=6;
A=[1 2 4 x 8 y 10]; % input
%%PROCESS
B=[1 2 4 5 8 6 10]; % output

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Follow Question

采纳的回答

Akira Agata 2017-11-12

在 MATLAB Online 中打开

0 个投票

yourExcel.PNG

I think the script like this can do what you want.

% Read excel file
[A,~,raw] = xlsread('yourExcel.xlsx');
% Variables
x = 5;
y = 6;
% Replace 'x' and 'y'
idx = strcmp(raw,'x');
A(idx) = x;
idx = strcmp(raw,'y');
A(idx) = y;