在ASP.NET访问Excel文件

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;";   
 8ADODataSetCommand myCommand = new ADODataSetCommand("SELECT * FROM [Sheet1$]", strConn);   
 9DataSet myDataSet = new DataSet();   
10myCommand.FillDataSet(myDataSet, "ExcelInfo");   
11DataGrid1.DataSource = myDataSet.Tables["ExcelInfo"].DefaultView;   
12DataGrid1.DataBind();   
13}   
14</script>

1<p><asp:label id="Label1" runat="server">Excel表格内容:</asp:label></p>

1<asp:datagrid id="DataGrid1" runat="server"></asp:datagrid>