MATLAB: Looking for a string in Excel file with multiple sheets

excelMATLABsearch stringSpreadsheet Link

Hello,

I want to read an Excel file with multiple sheets. From the file, I want to search for a particular string.

How shall I do it?

Any ideas?

Thanks

Best Answer

You should try looking up the xlsread, strmatch, find and strncmp functions in the help. There are comprehensive examples that should demonstrate what you need to do.

If you are still struggling then please upload some sample data.

Related Solutions

MATLAB: How to read vector of strings into MATLAB

[numbers, strings, everything] = xlsread(filename);

MATLAB: Xlsread with protected sheets

There is a very old file in the File Exchange that claims to be able to protect/unprotect Excel files: http://www.mathworks.com/matlabcentral/fileexchange/6046-xlsprotect

Here is a thread on the older MATLAB newsgroup forum about this function: http://www.mathworks.com/matlabcentral/newsreader/view_thread/98978

Best Answer

Related Solutions

MATLAB: How to read vector of strings into MATLAB

MATLAB: Xlsread with protected sheets

Related Question