## Contents

Language : Matlab 2008a Authors : Autar Kaw Last Revised : December 12, 2010 Abstract: This program shows you how to read an excel file in MATLAB The example has student numbers in first column and their score in the second column

```clc
clear all
disp('This program shows how to read an excel file in MATLAB')
disp('Matlab 2008a')
disp('Authors : Autar Kaw')
disp('Last Revised : December 12, 2010')
disp('http://numericalmethods.eng.usf.edu')
disp('  ')
```
```This program shows how to read an excel file in MATLAB
Matlab 2008a
Authors : Autar Kaw
Last Revised : December 12, 2010
http://numericalmethods.eng.usf.edu

```

## INPUTS

We have two column data and it has headers in the first row. That is why we read the data from A2 to B32.

```A=xlsread('c:\users\grades.xls','A2:B32');
disp(A)
disp('  ')
```
```The data read from the excel spreadsheet is
1    15
2    21
3    24
4    27
5    15
6    24
7    17
8    20
9    22
10    19
11    19
12    23
13    22
14    26
15    23
16    25
17    18
18    22
19    21
20    19
21    21
22    15
23    18
24    22
25    24
26    17
27    18
28    19
29    27
30    24
31    20

```

## SOLUTION

Finding the number of rows and columns

```sizem=size(A);
rows_A=sizem(1);
cols_A=sizem(2);
% Assigning the scores to a vector called score
for i=1:1:rows_A
score(i)=A(i,2);
end
% Using the max command to find the maximum score
% HW: Write your own function "max"
maxscore=max(score);
% Finding which student got the highest score
for i=1:1:rows_A
if score(i)==maxscore
student_no=i;
break;
end
% HW: What if more than one student scored the highest grade??
end
```

## OUTPUT

```disp('  ')
disp ('OUTPUT')
fprintf('Student Number# %g scored the maximum score of %g',...
student_no,maxscore)
disp(' ')
```
```
OUTPUT
Student Number# 4 scored the maximum score of 27
```