Clear Filters
Clear Filters

picking data from excel

4 views (last 30 days)
Purushottama Rao
Purushottama Rao on 6 May 2015
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.

Accepted Answer

Nobel Mondal
Nobel Mondal on 6 May 2015
matlab provides an extensive documentation on xlsread. Please try and see if this helps
doc xlsread
  3 Comments
Nobel Mondal
Nobel Mondal on 6 May 2015
Edited: Nobel Mondal on 6 May 2015
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
Purushottama Rao on 7 May 2015
Thanks a lot. That gave me good info

Sign in to comment.

More Answers (0)

Tags

No tags entered yet.

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!