how to search specific data from matlab to excel
    4 views (last 30 days)
  
       Show older comments
    
how to search specific data from matlab to excel and then display the row that include the data i've searched to matlab, for example i have an excel data  
R1280XS  11  12  10 
  B2015AT  14  10  10 
  D1112FM  10  14  15 
when i search R1280XS at matlab, 11 12 10 will display in matlab
please help me, i'm stuck with it
0 Comments
Accepted Answer
  Ive J
      
 on 25 Oct 2021
        tab = readtable('myExcel.xlsx'); % see doc for more options
tab(ismember(tab.(1), 'R1280XS'), :) % the row at which the input str matches the first table's column 
2 Comments
More Answers (0)
See Also
Categories
				Find more on Spreadsheets in Help Center and File Exchange
			
	Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
