picking data from excel

Question

Purushottama Rao 2015-5-6

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/215320-picking-data-from-excel

评论： 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.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Nobel Mondal 2015-5-6

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/215320-picking-data-from-excel#answer_178039

在 MATLAB Online 中打开

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

doc xlsread

3 个评论
显示 1更早的评论隐藏 1更早的评论

Nobel Mondal 2015-5-6

编辑：Nobel Mondal 2015-5-6

在 MATLAB Online 中打开

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, :);