ASP.NET:访问Excel 电子表格

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>
Published At
Categories with Web编程
Tagged with
comments powered by Disqus