Search Excel spreadsheet for specific value

Question

Amanda Boone 2018-10-19

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/424972-search-excel-spreadsheet-for-specific-value

回答： Bereketab Gulai 2020-5-27

Hi, I'm looking to create a program that will search through an excel spreadsheet in the first column to find a specific value. Once that value is found, import the entire row, and break down each item in that row to assign it to a variable. For example:

If I excel file looks like this:

  10    6745    6.898
  11    6890    7.001
  12    7001    7.102

and T=380, I need Matlab to search for the row where the first column is equal to T. Once the row is imported, assign P=11, h=6890, and s=7.001

I'm just not sure how to do this with Matlab. I've looked around and found xlsread('filename') to actually read the spreadsheet, but I don't know how to pull the row and break it apart. Please, any help would be appreciated.

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

请先登录，再进行评论。

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

Answer 1

YT 2018-10-19

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/424972-search-excel-spreadsheet-for-specific-value#answer_342300

在 MATLAB Online 中打开

Something like this?

%read your sheet
X = xlsread('my-excel-sheet.xlsx');
%the value your looking for
T = 380;
%get entire row where first column value = T
V = X(X(:,1) == T,:); 
%your other values assigned here
P = V(2); 
h = V(3);
s = V(4);

3 个评论
显示 1更早的评论隐藏 1更早的评论

Kyuri Kim 2020-5-20

Hi, may I ask you something?

I'm keep making errors in

V = X(X(:,1) == T,:);

It says "The index at position 2 exceeds the array boundary."

Thank you for your help :)

Walter Roberson 2020-5-20

Your X has 0 columns so X(:,1) does not exist.

The array that is denoted as [] has 0 rows and 0 columns so if you initialized to [] then it is still []

请先登录，再进行评论。

Answer 2

Bereketab Gulai 2020-5-27

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/424972-search-excel-spreadsheet-for-specific-value#answer_440300

在 MATLAB Online 中打开

Here is answer using actxserver:

excelApp = actxserver("excel.Application");
excelApp.Visible = false;
book1 = excelApp.Workbooks.Open('D:\Temporary stuff\Book1.xlsx');
% Sheet item 1 ...
sheetOne = book1.Sheets.Item(1);
foundInterfaceObj = sheetOne.Range("A:A").Find('Eric');