search through an excel file, and save sheet and cells as variables

Question

avram alter 2020-1-28

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/502430-search-through-an-excel-file-and-save-sheet-and-cells-as-variables

回答： avram alter 2020-1-29

Book1.xlsx

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 4x8 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.

2 个评论
显示无隐藏无

Mohammad Sami 2020-1-29

The data needs to be loaded into Matlab first, before you can actually search the string you are looking for.

avram alter 2020-1-29

yeah, or course. i left that out here as I thought it was extraneous. thank you!

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

avram alter 2020-1-29

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/502430-search-through-an-excel-file-and-save-sheet-and-cells-as-variables#answer_412708

在 MATLAB Online 中打开

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