Due date: November 9, 1999

(1) Write an asp program searchdata.asp that searches a MS Excel worksheet,data4.xsl.  Here is the contents of data4.xsl:

Note that you can download and save data4.xsl into your own account.  However, do not attempt to open the file because you may change the version of Excel and create a compatibility problem.

The format of the spreadsheet includes:

• Row 1 contains the names of the columns.
• Rows 2 to n contains a student grade for each row.
• Row (n+1): empty row
• Row (n+2) on: statistical report with the names of the statistical parameters in the first column.
• The first column is always the name.  The second column is always the social security number, the key.
• There are at most 20 columns and 40 rows.

For example, for the url:

http://lattes.uhcl.edu/youraccount/searchdata.asp?ssnum=111-11-1111

your page should respond:

for

http://lattes.uhcl.edu/youraccount/searchdata.asp?ssnum=123-45-6789

and for

http://lattes.uhcl.edu/youraccount/searchdata.asp?ssnum=999-99-9999

Your output should be as close to the example above as possible.

Hint: here is a useful article on how to access an MS Excel ODBC sources using ASP.