<script language="C#" runat="server"> PRotected void Page_Load(Object Src, EventArgs E) { string strConn; strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=C://Exceltest.xls;" + "Extended Properties=Excel 8.0;"; 'You must use the $ after the object you reference in the spreadsheet ADODataSetCommand myCommand = new ADODataSetCommand("SELECT * FROM [Sheet1$]", strConn);
<script language="VB" runat="server"> Sub Page_Load(sender As Object, e As EventArgs) Dim myDataset As New DataSet()
'You can also use the Excel ODBC driver I believe - didn't try though Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=C:/exceltest.xls;" & _ "Extended Properties=""Excel 8.0;"""
'You must use the $ after the object you reference in the spreadsheet Dim myADODataSetCommand As New ADODataSetCommand("SELECT * FROM [Sheet1$]", strConn) myADODataSetCommand.TableMappings.Add("Table", "ExcelTest") myADODataSetCommand.FillDataSet(myDataset)
DataGrid1.DataSource = myDataset.Tables(0).DefaultView DataGrid1.DataBind() End Sub </script> <p><asp:Label id=Label1 runat="server">SpreadSheet Contents:</asp:Label></p> <asp:DataGrid id=DataGrid1 runat="server"/>
