How do I use an if statement to check if a data is present on a excel sheet?

3 次查看(过去 30 天)
I want to create an if condition that should check if student name and ID is present in the excel sheet.
If it is present it shoul execute the code i want it to run.
I am trying xlsread but is not working for me any suggestion?

回答(1 个)

Adam Danz
Adam Danz 2021-3-10
At the top of the documentation page for xlsread there is warning that xlsread is not recommended and it suggests alternative functions (readtable, readmatrix).
If you're checking that a particular header (variable name) exists, you can use those function to read in just the header row(s).
If you're checking if a paricular name and ID exists you'll need to read in the entire table and the search the name and ID columns (hint: isequal, strcmpi, ismember).
If you get stuck and have any problems, show us where you're at and describe the issue.
  2 个评论
Adithya Narasimhan
Adithya Narasimhan 2021-3-10
Can I use somthing like
a = input('Enter name: ');
if a == readtable('StudentIDverify.xlsx')
does this work?
Adam Danz
Adam Danz 2021-3-10
编辑:Adam Danz 2021-3-12
Not quite.
Try reading in the table using readtable and look at what it produces.
'a' will presumably be a character vector but the readtable function will read in an entire table.

请先登录,再进行评论。

标签

产品


版本

R2020b

Community Treasure Hunt

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

Start Hunting!

Translated by