D
delphibbs_wayne
Unregistered / Unconfirmed
GUEST, unregistred user!
我想用ASP.NET调用Excel2000的数据，可不知道怎么做，我的代码如下，不过不成功。
<%@ Page Language="c#" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<script Language="c#" runat="server">
protected void Page_Load(Object sender,EventArgs e)
{
string strConnection = "Provider=Microsoft.Jet.OleDb.4.0;";
strConnection += "Data Source=" + Server.MapPath("samples.xls");
strConnection += "Extended Properties=Excel 8.0";
strSQL = "SELECT * FROM [Sheet1$]";
OleDbConnection objConnection = new OleDbConnection(strConnection);
OleDbDataAdapter objDataAdapter = new OleDbDataAdapter(strSQL,objConnection);
DataSet objDataSet = new DataSet();
objDataAdapter.Fill(objDataSet,"ExcelInfo");
DataGrid1.DataSource = objDataSet.Tables["ExcelInfo"].DefaultView;
DataGrid1.DataBind();
}
</script>
<html>
<head>
<title>ExcelTest</title>
</head>
<body>
<asp:Label id="label1" text="Excel表格内容" runat="server"/>
<p>
<asp
ataGrid id="DataGrid1" runat="server"/>
</body>
</html>
请求帮助，谢谢！
<%@ Page Language="c#" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<script Language="c#" runat="server">
protected void Page_Load(Object sender,EventArgs e)
{
string strConnection = "Provider=Microsoft.Jet.OleDb.4.0;";
strConnection += "Data Source=" + Server.MapPath("samples.xls");
strConnection += "Extended Properties=Excel 8.0";
strSQL = "SELECT * FROM [Sheet1$]";
OleDbConnection objConnection = new OleDbConnection(strConnection);
OleDbDataAdapter objDataAdapter = new OleDbDataAdapter(strSQL,objConnection);
DataSet objDataSet = new DataSet();
objDataAdapter.Fill(objDataSet,"ExcelInfo");
DataGrid1.DataSource = objDataSet.Tables["ExcelInfo"].DefaultView;
DataGrid1.DataBind();
}
</script>
<html>
<head>
<title>ExcelTest</title>
</head>
<body>
<asp:Label id="label1" text="Excel表格内容" runat="server"/>
<p>
<asp
ataGrid id="DataGrid1" runat="server"/></body>
</html>
请求帮助，谢谢！