How do I use an if statement to check if a data is present on a excel sheet?
8 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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?
0 commentaires
Réponses (1)
Adam Danz
le 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 commentaires
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!