picking data from excel

2 次查看（过去 30 天）
Purushottama Rao
Purushottama Rao 2015-5-6
评论： Purushottama Rao 2015-5-7
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.

请先登录，再回答此问题。

采纳的回答

Nobel Mondal
Nobel Mondal 2015-5-6
matlab provides an extensive documentation on xlsread. Please try and see if this helps
doc xlsread
  3 个评论
显示 1更早的评论
Nobel Mondal
Nobel Mondal 2015-5-6
编辑：Nobel Mondal 2015-5-6
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 2015-5-7
Thanks a lot. That gave me good info

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

尚未输入任何标签。

Community Treasure Hunt

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

Start Hunting!

Translated by