Search Excel spreadsheet for specific value

39 次查看（过去 30 天）
Amanda Boone
Amanda Boone 2018-10-19
回答： 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:
375 10 6745 6.898
380 11 6890 7.001
390 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.

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

采纳的回答

YT
YT 2018-10-19
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更早的评论
Kyuri Kim
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
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 []

请先登录，再进行评论。

更多回答（1 个）

Bereketab Gulai
Bereketab Gulai 2020-5-27
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');
The returned Interface provides lots functions you may need. Row will give the row number, Value for the cell...

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品


版本

R2018b

Community Treasure Hunt

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

Start Hunting!

Translated by