在asp.net中调用Excel 文件 转贴:Andy.m 日期:2003-07-12 人气:38 |
vb.net源代码 <%@ 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() ''我们可以使用Excel ODBC driver Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=C:/exceltest.xls;" & _ "Extended Properties=""Excel 8.0;""" ''我们必须使用$在sheet后面 Dim myData As New OledbDataAdapter("SELECT * FROM [Sheet1$]", strConn) myData.TableMappings.Add("Table", "ExcelTest") myData.Fill(myDataset) DataGrid1.DataSource = myDataset.Tables(0).DefaultView DataGrid1.DataBind() End Sub </script> <html> <head></head> <body> <p><asp:Label id=Label1 runat="server">SpreadSheet Contents:</asp:Label></p> <asp:DataGrid id=DataGrid1 runat="server"/>/ </body> </html> C# Syntax <%@ Page Language="C#" %> <%@ Import Namespace="System.Data.OleDb" %> <%@ Import Namespace="System.Data" %> <%@ Import Namespace="System" %> <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;"; OleDbDataAdapter myCommand = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", strConn); DataSet myDataSet = new DataSet(); myCommand.Fill(myDataSet, "ExcelInfo"); DataGrid1.DataSource = myDataSet.Tables["ExcelInfo"].DefaultView; DataGrid1.DataBind(); } </script> <html> <head></head> <body> <p><asp:Label id=Label1 runat="server">SpreadSheet Contents:</asp:Label></p> <asp:DataGrid id=DataGrid1 runat="server"/>/ </body> </html> |
在asp.net中调用Excel 文件
最新推荐文章于 2024-09-20 12:59:07 发布