MATLAB: 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.

Best Answer

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

doc xlsread

Related Solutions

MATLAB: How to rename a sheet in Excel using the COM interface in MATLAB

You can rename an Excel sheet using the "Name" property of a sheet object. For example the following renames the first sheet of an Excel file:

filename = 'C:\SomeExcelFile.xls';
% Open Excel Automation server
Excel = actxserver('Excel.Application');
% Make Excel visible
Excel.Visible=1;
% Open Excel file
Workbook = Excel.Workbooks.Open(filename);
% Get the list of sheets in the workbook
Sheets = Excel.ActiveWorkbook.Sheets;
% Rename the first sheet
Sheets.Item(1).Name = 'This is sheet 1';

The following code then saves the Workbook, quits Excel and removes the COM server:

% Save the file
Workbook.Save();
% Quit Excel, remove the COM server and delete the related objects
Excel.Quit();
Excel.delete();
clear Excel;
clear Workbook;
clear Sheets;

MATLAB: Undefined variable “handles”

The variable 'handles' is not known inside your function set_row. You have to define set_rows with an additional parameter 'handles'

function my_rows = set_rows(row, handles)

and call it accordingly

my_rows = set_row(row, handles)

Best Answer

Related Solutions

MATLAB: How to rename a sheet in Excel using the COM interface in MATLAB

MATLAB: Undefined variable “handles”

Related Question