MATLAB: Search through an excel file, and save sheet and cells as variables

excelfindMATLAB

I have an excel file that wil have up to 15 sheets in it. I have added a small example here that demonstrates what it looks like. basically, each sheet has 4×8 cells filled with an alphanumeric codes, with no codes repeating. Is there a way to enter one of the codes, and then matlab will search through the excel file, returning the sheet name and row to be saved in a variable?

for example, in the file I added here, Sheet2, row 4 begins with qwwj8434. for example

code = input('please enter code: ', 's');
>> qwwj8434
Sheet_name = Sheet2
Row_name = 4

I would specifically just be looking for the first code per row, if that helps at all.

Any help would be much appreciated.

Best Answer

Walter Roberosn provided the correct answer for me in a different thread: https://www.mathworks.com/matlabcentral/answers/502472-find-strings-in-excel-on-different-sheets?s_tid=prof_contriblnk

this is what the code looks like:

filename = 'examplesheet.xlsx';
[~, sheets] = xlsfinfo(filename);
rows_found = [];
sheets_found = {};
in = input('input code: ', 's');
for K = 1 : length(sheets)
    this_sheet = sheets{K};
    [~, ~, raw] = xlsread(filename, this_sheet);
    [rowNum, colNum] = find( strcmp(in, raw));
    if ~isempty(rowNum)
        rows_found = [rows_found; rowNum];
        sheets_found = [sheets_found; repmat({this_sheet}, length(rowNum), 1)];
    end
end

Related Solutions

MATLAB: Find strings in excel on different sheets

filename = 'examplesheet.xlsx';
[~, sheets] = xlsfinfo(filename);
rows_found = [];
sheets_found = {};
for K = 1 : length(sheets)
    this_sheet = sheets{K};
    [~, ~, raw] = xlsread(filename, this_sheet);
    [rowNum, colNum] = find( strcmp(in, raw));
    if ~isempty(rowNum)
        rows_found = [rows_found; rowNum];
        sheets_found = [sheets_found; repmat({this_sheet}, length(rowNum), 1)];
    end
end

Output is a numeric matrix rows_found and a cell array of character strings sheets_found . rows_found(K) is arow number and sheets_found{K} is the corresponding sheet name.

MATLAB: Array exceeds limits when scanning serial info

I'm a bit confused by all the code you've posted. If I understood correctly the problem is with:

in = char(zeros(1,14));
decision = fscanf(tags{portidx});   
in = decision(11:24);

For a start, the first line doesn't do anything useful. Whenever you assign something to a non-indexed variable, whatever was in the variable before doesn't matter it's completely wiped out when doing the assigment:

in = something;  %doesn't matter what in was before the line. The content is completely replaced

Now, the error is Index exceeds the number of array elements (12), on the line:

in = decision(11:24);

The variable that is being indexed here is not in, it's decision. So the error tells you that the indices 11 to 24 exceed the number of elemens in |decisions. It also tells you tall number of elements is 12. So, the problem is clear, your fscanf only returned 12 characters. You'll have to figure out why. Perhaps it's a problem with your instrument. Looking at the content at what you received may give you a clue. Maybe it's an error code.

When dealing with IO, I would certainly never assume that you get what you wanted without checking that it is actually the case, so changing your code to:

[decision, receivedcount] = fscanf(tags{portidx});
if receivedcount < 24
    error('Received less data than expected. Received data was: %s', decision)
end
%now we know we've got at least 24 characters. 
%You may still want to check that the characters you receive conform to the pattern you expect. This is left as an exercise to the reader.
in = decision(11:24);
%...

Best Answer

Related Solutions

MATLAB: Find strings in excel on different sheets

MATLAB: Array exceeds limits when scanning serial info

Related Question