在ASP.NET访问Excel文件 (VB.NET and C#)

最新推荐文章于 2017-05-18 11:08:09 发布

最新推荐文章于 2017-05-18 11:08:09 发布 · 168 阅读

文章标签：

#ASP.net #VB.NET #VB #.net #ASP

博客介绍了在ASP.NET中访问Excel文件的相关内容，涉及VB和C#语言，还展示了ASP标签用于显示Excel表格内容。

在ASP.NET访问Excel文件 (VB and C#)

<xmp> C# Code --------------------------------------------- <%@ Page Language="C#" %> <%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Data.ADO" %> <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;"; ADODataSetCommand myCommand = new ADODataSetCommand("SELECT * FROM [Sheet1$]", strConn); DataSet myDataSet = new DataSet(); myCommand.FillDataSet(myDataSet, "ExcelInfo"); DataGrid1.DataSource = myDataSet.Tables["ExcelInfo"].DefaultView; DataGrid1.DataBind(); } </script>
<asp:label id="Label1" runat="server">Excel表格内容:</asp:label>
<asp:datagrid id="DataGrid1" runat="server"> VB.NET Code ---------------------------------------------- <%@ Page Language="VB" %> <%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Data.ADO" %> <script language="VB" runat="server"> Sub Page_Load(sender As Object, e As EventArgs) Dim myDataset As New DataSet() Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;" _ & "Data Source=C:\exceltest.xls;" _ & "Extended Properties=""Excel 8.0;""" 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>
<asp:label id="Label1" runat="server">Excel表格内容:</asp:label>
</asp:datagrid><asp:datagrid id="DataGrid1" runat="server"> </asp:datagrid></xmp>