How to read values from a table or Excel File and assign it to a variable ?

Question

Ramann Mantha 2014-5-1

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/127873-how-to-read-values-from-a-table-or-excel-file-and-assign-it-to-a-variable

评论： Nikhilesh Gandhre 2019-9-13

Hello, I am writing a MATLAB code for the design of a Horn Antenna. In the process, the code is supposed to read values from a table (or an excel file). To make it more clear, let us assume I have a table of two variables "a" & "b". The value of "a" is to be entered by the user and based on the value entered, the code is supposed to look up the table/or an excel file for a corresponding value of "b" and assign it to "b". How do I do it ?

2 个评论
显示无隐藏无

Azzi Abdelmalek 2014-5-1

for a corresponding value of "b" and assign it to "b"?

Ramann Mantha 2014-5-1

I'm sorry, I meant to say that depending on the value of "a" entered by the user, the code is supposed to find the corresponding value of "b" from the table ! Hope this clears the confusion !

请先登录，再进行评论。

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

Answer 1

Benjamin Avants 2014-5-1

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/127873-how-to-read-values-from-a-table-or-excel-file-and-assign-it-to-a-variable#answer_135298

在 MATLAB Online 中打开

You'll have to load the whole table into memory and then search column a for an entry that matches the user input. Then you use the index of a to get the value for b.

To load the table into memory, use the MATLAB function xlsread.

data = xlsread('myFile.xls')

There are options to restrict how xlsread opens the file if you need to read specific ranges of cells or cells that include text. Look up the documentation if necessary.

The above function call is assumed to work and the file contains two columns "a" and "b".

Finding your "a" value would be something like this:

index = data(:,1) == a;

and saving your "b" value would work like this:

b = data(index,2);

In this case, if "a" exists more than once in the data, you'll get an array of "b"s associated with those "a"s. You can combine the above lines like this:

b = data(data(:,1) == a,2);