how to find the location of a specific element in a matrix or in a excel file
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
Kshitij Singh answered .
2025-11-20
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