 |
|
|
 首页 |
名片设计 CorelDRAW Illustrator AuotoCAD Painter 其他软件 Photoshop Fireworks Flash |
|
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;"; \\'You must use the $ after the object you reference in the spreadsheet 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">SpreadSheet Contents:</asp:Label></p> <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() \\'You can also use the Excel ODBC driver I believe - didn\\'t try though Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=C:exceltest.xls;" & _ "Extended Properties=""Excel 8.0;""" \\'You must use the $ after the object you reference in the spreadsheet 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">SpreadSheet Contents:</asp:Label></p> <asp:DataGrid id=DataGrid1 runat="server"/> 返回类别: 教程 上一教程: 实现聊天室在线人员无刷新所需要的JavaScript技术 - 3 下一教程: 开发连接远程SQL Server 的ASP程序应注重的问题 您可以阅读与"ASP.NET:访问Excel 电子表格"相关的教程: · ASP与电子表格EXCEL的交互操作 · 利用ASP.NET来访问Excel文档 · asp实现在web中显示电子表格数据（四）创建文件选择列表 · asp实现在web中显示电子表格数据（二）生成HTML表格 · ASP实现在WEB中显示电子表格数据(一)显示数据表格的应用 |
  |
| 快精灵印艺坊 版权所有 |
首页 会员中心在线印刷在线编辑付款方式索取样品设计指南连锁门店
|
||
