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

5 views (last 30 days)
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?

Answers (1)

Adam Danz
Adam Danz on 10 Mar 2021
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 Comments
Adam Danz
Adam Danz on 10 Mar 2021
Edited: Adam Danz on 12 Mar 2021
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.

Sign in to comment.

Products


Release

R2020b

Community Treasure Hunt

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

Start Hunting!

Translated by