Hi Naomi,
From my understanding, you want to compare user input with data already present in an Excel file and input it in the sheet if it is a new entry.
You can do this by first reading the Excel sheet -
opts = spreadsheetImportOptions("NumVariables", 2);
% Specify sheet and range
opts.Sheet = "Sheet1";
% Specify column names and types
opts.VariableNames = ["RollNo", "Name"];
opts.VariableTypes = ["double", "string"];
filepath= "PATH TO YOUR SHEET";
% Import the data
data = readtable(filepath, opts, "UseExcel", false);
Then take user input using the input function and check to see if such an entry exists or not using the find function. If it is a new entry, then we input it into the sheet using writecell function -
roll = input('Enter Roll no.: ');
% If the input entry doesn't exist, then the find funtion will return an
% empty matrix
if isempty(find(data.RollNo==roll, 1))
name = input('Enter Name: ',"s");
info={roll,name};
writecell(info,filepath,'WriteMode','append');
else
disp("Duplicate Entry")
end
For more details, you can refer to the following documentations on reading and writing from excel sheets and the input function -
