how to find the location of a specific element in a matrix or in a excel file

Aiman Zara · Apr 15, 2023 · 2.1K views
Question
i need to find the location of each element from the matrix/excel, how can i do it through matlab functions? if not possible with functions than how ca I do this with loop? please provide me a sample code to do so. Actually I think functions would work great for large data processing, loops will take more time. Attaching a sample file  Stage health Object 1 good chair 2 good table 3 bad fan 4 average bag 5 average laptop  
Expert Answer
Profile picture of Kshitij Singh
Kshitij Singh PhD Expert
Answered Aug 20, 2026

What do you mean "to find the location of each element"? You mean just read the file, don't you; the location is really of very little significance for a regular file structure such as that file contains. 

 

fn='example.xlsx';
tData=readtable(fn);
tData=convertvars(tData,@iscellstr,'categorical')
tData = 5×3 table
    Stage    health     Object
    _____    _______    ______

      1      good       chair 
      2      good       table 
      3      bad        fan   
      4      average    bag   
      5      average    laptop

 

Have a different question? Ask here

Get a Free Consultation or a Sample Assignment Review!