C# Code
---------------------------------------------
1@ Page Language="C#"
1@ Import Namespace="System.Data"
1@ Import Namespace="System.Data.ADO"
1<script language="C#" runat="server">
2protected void Page_Load(Object Src, EventArgs E)
3{
4string strConn;
5strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +
6"Data Source=C:\\\exceltest.xls;" +
7"Extended Properties=Excel 8.0;";
8'You must use the $ after the object you reference in the spreadsheet
9ADODataSetCommand myCommand = new ADODataSetCommand("SELECT * FROM [Sheet1$]", strConn);
10
11DataSet myDataSet = new DataSet();
12myCommand.FillDataSet(myDataSet, "ExcelInfo");
13DataGrid1.DataSource = myDataSet.Tables["ExcelInfo"].DefaultView;
14DataGrid1.DataBind();
15}
16</script>
1<p><asp:label id="Label1" runat="server">SpreadSheet Contents:</asp:label></p>
1<asp:datagrid id="DataGrid1" runat="server"></asp:datagrid>
VB.NET Code
----------------------------------------------
1@ Page Language="VB"
1@ Import Namespace="System.Data"
1@ Import Namespace="System.Data.ADO"
1<script language="VB" runat="server">
2Sub Page_Load(sender As Object, e As EventArgs)
3Dim myDataset As New DataSet()
4
5'You can also use the Excel ODBC driver I believe - didn't try though
6Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
7"Data Source=C:\exceltest.xls;" & _
8"Extended Properties=""Excel 8.0;"""
9
10'You must use the $ after the object you reference in the spreadsheet
11Dim myADODataSetCommand As New ADODataSetCommand("SELECT * FROM [Sheet1$]", strConn)
12myADODataSetCommand.TableMappings.Add("Table", "ExcelTest")
13myADODataSetCommand.FillDataSet(myDataset)
14
15DataGrid1.DataSource = myDataset.Tables(0).DefaultView
16DataGrid1.DataBind()
17End Sub
18</script>
1<p><asp:label id="Label1" runat="server">SpreadSheet Contents:</asp:label></p>
1<asp:datagrid id="DataGrid1" runat="server"></asp:datagrid>