ASP.NET:Dispaly data from an EXCEL spreadsheet

Asp.net|excel This code is written in response to a, posted on one of Charles Carroll ' s asp.net lists. Can sign up for one or all of the lists. This page provides a simple example of the how to query an EXCEL spreadsheet the from a asp.net page using vb.net.

Code:

<%@ Page language= "VB"%>
<%@ Import namespace= "System.Data"%>
<%@ Import namespace= "System.Data.OleDb"%>
<script language= "VB" runat= "Server" >
Sub Page_Load (sender as Object, E as EventArgs)
Dim myDataSet as New DataSet ()

Dim strconn as String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data source=" & Replace (Server.MapPath ("."), "\", "\") & "\\exceltest.xls" & _
"Extended properties=" "Excel 8.0;" ""

' You must use the ' $ after the ' object for your reference in the spreadsheet
Dim Myoledbdataadapter as New oledbdataadapter ("select * from [sheet1$]", strconn)
Myoledbdataadapter.fill (myDataSet)

DataGrid1.DataSource = mydataset.tables (0). DefaultView
Datagrid1.databind ()
End Sub
</script>