picking data from excel

Hi I have an excel sheet which contains the names of the people (strings)as the first coulmn. Remaining coloumns contains the information (numeric data) such as height,age etc..

I would like to pick up the data corresponding to the given name and display it. Pls help me.

Answer 1

[Nobel Mondal]

matlab provides an extensive documentation on xlsread. Please try and see if this helps

doc xlsread

[Purushottama Rao]

Do you suggest me to use strcmp once i read the data from Excel? IF strcmp results true, how to take out the remaining coulmns out for that row.

[Nobel Mondal]

This is a rough outline. You may refer the documentation for finding specific refinement for your use case (like, sheet names, cell ranges etc)

1.

[~,~,rawdata] = xlsread('myspreadsheet.xlsx'); % Get everything in a cell-array
myRow = find(strcmp(rawdata, my_match_string));
myRowInfo = rawdata(myRow, 2:end);

You would get all the numeric values in that row in a cell array.

2. Assuming, your first row is reserved for the column names (and first column for the people-name), your numeric data should be in a (totalrows-1, totalcolumns-1) block in the spreadsheet. In this case, the following code should give you a numeric array.

[numdata, txtdata, ~] = xlsread('myspreadsheet.xlsx'); % get numbers and strings separately
myRow = find(strcmp(txtdata, my_match_string));
myRowInfo = numdata(myRow-1, :);

[Purushottama Rao]

Thanks a lot. That gave me good info