MATLAB: Read from excel and compare text

importing excel dataMATLABxlsread

I need to read a column from excel for example say I need to read user_id column from excel and the excel sheet is present in some other folder at desktop.after I read the column containing user_id's I need to search for a particular user_id. How do I do that …?

Best Answer

readtable() to get the data into place. strcmp() or ismember() the appropriate column of the table.

Related Solutions

MATLAB: I have a problem to write to a excel

You got it almost:

q = size(record, 1);  % Safer than LENGTH
r = q + 1;
xlswrite('C:\Users\AFQ1KOR\Desktop\newfolder\Book11.xlsx', d, ...
         sprintf('A%d:B%d', r, r);

'Ar:Br' does not insert the contents of the variable r in the char vector. Use sprintf to insert the number to the char vector.

MATLAB: How to convert a string into its binary equivalent

user_id = 'banerjee.raktim'; 
password = '123456789';
user_id = [user_id repmat('*',1,20)];
user_id = user_id(1:20);
password = [password repmat('*',1,20)];
password = password(1:20);
userid_final = reshape(dec2bin(user_id,8),1,[]);
password_final = reshape(dec2bin(password,8),1,[]);
watermark = [userid_final password_final];

Best Answer

Related Solutions

MATLAB: I have a problem to write to a excel

MATLAB: How to convert a string into its binary equivalent

Related Question