How can I only use a certain set of rows based on a string when reading an excel file?

So I'm doing a matlab project and we have to read a set of basketball games with xls read and we can only use the SEC conference games to create a table of slightly different data thats in the excel sheet. We can't figure out how to only use the data in the SEC game rows and then print a different table. We created [num text all] = xlsread(filename) and seperated the conference column from the rest. How do we create a variable (secGames) that is composed of only the SEC conference games from the conference column with only the rows of those games and certain columns from the excel spreadsheet?

[dpb]

Hint--

doc ismember
doc strfind

should give you some ideas...

[Carson]

We haven't learned either of those functions and we get points off for using things we haven't learned. Is there a way to achieve this without using those functions?

[dpb]

Well, one must assume there is or it wouldn't have been the assignment...

The pdf mentions things about a previous algorithm and some algorithm in class so I'd presume there would be the place to start. I can't guess effectively at what you have or have not, had so far, sorry.

Answer 1

[Carsci]

You are allowed to use xlsread, right? So it seems this provides a way to do it.

Assume the SEC data is on contiguous rows. Use xlsread 2 times. Read the header rows in one range and the SEC rows in another. Determining the ranges manually is not ideal but you may not yet have learned any functions that do it programatically.

You can expand the multiple use of xlsread to extract only the columns of interest as seperate reads. It is messy as each range has to be rectangular but if you are only allowed to use a limited set of functions then may allow a solution.

[num,txt,raw] = xlsread(filename,range) reads data from the specified range of the first worksheet in the file. Specify range using the syntax 'C1:C2', where C1 and C2 are two opposing corners that define the region.