السلام عليكم انا اريد احط يعطيني طريقة الاتصال بالاكسل ويعطيني الكود تاعها كامل لو سمحتو
كيفية الاتصال بالاكسل
أختي شوفي هذه الروابط
ربما تفيدك
أو وضحي سؤالك
/index.php?showtopic=223906&st=0&p=1107991&hl=%C5%DF%D3%E1&fromsearch=1entry1107991
/index.php?showtopic=119330&st=0&p=600792&hl=%C5%DF%D3%E1&fromsearch=1entry600792
/index.php?showtopic=101861&st=0&p=515769&hl=%C5%DF%D3%E1&fromsearch=1entry515769
/index.php?showtopic=58159&view=findpost&p=286231&hl=%C5%DF%D3%E1&fromsearch=1
الله أكبر الله أكبر الله أكبر لآ إله إلا الله الله أكبر الله أكبر ولله الحمد
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Excel Operation</title>
<style type="text/css">
.outerspan{width:600px;float:left;margin-bottom:10px;margin-left:200px;font-weight:bold;font-Style:arial;}
.innerspan{width:100px;float:left;}
</style>
</head>
<body>
<form id="form1" runat="server">
<div style="float:left;width:100%">
<asp:Repeater ID="rptUserData" runat="server" OnItemCommand="rptUserData_ItemCommand">
<HeaderTemplate>
<table style="border: 1px solid rgb(186, 186, 186); width: 750px; border-collapse: collapse;"
border="1" cellpadding="5" cellspacing="0" rules="all">
<tr class="arialltbox14breport" style="background-color: WhiteSmoke; height: 30px;"
align="left">
<th style="padding-left: 10px;">
Emp No</th>
<th style="padding-left: 10px;">
Emp Name</th>
<th style="padding-left: 10px;">
Address</th>
<th style="padding-left: 10px;">
Salary</th>
<th style="padding-left: 10px;">
Action</th>
</tr>
</HeaderTemplate>
<ItemTemplate>
<tr style="height: 25px;" class="arialltbox11r">
<td style="padding-left: 10px;">
<asp:Label ID="lblID" runat="server" Text='<%#Eval("EmpNo").ToString() %>'></asp:Label>
</td>
<td style="padding-left: 10px;">
<%#Eval("EmpName").ToString()%>
</td>
<td style="padding-left: 10px;">
<%#Eval("EmpAddress").ToString()%>
</td>
<td style="padding-left: 10px;">
<%#Eval("EmpSalary").ToString()%>
</td>
<td style="padding-left: 10px;">
<asp:LinkButton ID="lnkEdit" runat="server" Text="Edit Data" CommandName="Edit" CommandArgument='<%#Eval("EmpNo").ToString() %>'></asp:LinkButton>
</td>
</tr>
</ItemTemplate>
<FooterTemplate>
</table>
</FooterTemplate>
</asp:Repeater>
</div>
<div style="margin:20px 250px 20px 0px; text-align:right;"><asp:LinkButton ID="lnkInsert" runat="server" OnClick="lnkInsert_Click"><strong>Insert New record</strong></asp:LinkButton></div>
<div style="float:left;padding-top:40px;" id="divInsertUpdate" runat="server" visible="false">
<span class="outerspan"><span class="innerspan">Emp Name:</span><span><asp:TextBox
ID="ename" runat="server"></asp:TextBox></span></span><br />
<span class="outerspan"><span>Address
<asp:TextBox ID="add" runat="server"></asp:TextBox></span></span><br />
<span class="outerspan"><span class="innerspan">Salary</span><span><asp:TextBox
ID="esal" runat="server"></asp:TextBox></span></span><br />
<span class="outerspan"><span class="innerspan"> </span><span><asp:Button ID="btnUpdate" runat="server" Text="Update Excel Data" OnClick="btnUpdate_Click" /><asp:Button ID="btnInsert" runat="server" Text="Insert New Record" Visible="false" OnClick="btnInsert_Click" /></span></span>
</div>
<div>
</div>
</form>
</body>
</html>
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
BindRepeater();
}
private DataTable ReadExcelData(Int32 EmpID)
{
string file = Server.MapPath("employees.xls");
string constr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + file + ";Extended Properties=Excel 8.0;";
string query = "Select EmpNo,EmpName,EmpAddress,EmpSalary from [Sheet1$]";
if (EmpID > 0)
query = query + " WHERE EmpNo=" + EmpID.ToString();
DataSet dsUserData = new DataSet();
using (OleDbConnection Connection = new OleDbConnection(constr))
{
using (OleDbDataAdapter DataAdapter = new OleDbDataAdapter(query, Connection))
{
DataAdapter.Fill(dsUserData, "UserData");
DataAdapter.AcceptChangesDuringFill = false;
DataAdapter.Dispose();
Connection.Close();
}
}
return dsUserData.Tables[0];
}
private void BindRepeater()
{
rptUserData.DataSource = ReadExcelData(-1);
rptUserData.DataBind();
}
protected void rptUserData_ItemCommand(object source, RepeaterCommandEventArgs e)
{
if (e.CommandName == "Edit")
{
DataTable dtData= ReadExcelData(Convert.ToInt32(e.CommandArgument));
if (dtData.Rows.Count > 0)
{
ename.Text = dtData.Rows[0]["EmpName"].ToString();
add.Text = dtData.Rows[0]["EmpAddress"].ToString();
esal.Text = dtData.Rows[0]["EmpSalary"].ToString();
btnUpdate.CommandArgument = dtData.Rows[0]["EmpNo"].ToString();
btnUpdate.Visible = true;
btnInsert.Visible = false;
divInsertUpdate.Visible = true;
}
}
}
protected void lnkInsert_Click(object sender, EventArgs e)
{
btnUpdate.Visible = false;
btnInsert.Visible = true;
divInsertUpdate.Visible = true;
}
protected void btnInsert_Click(object sender, EventArgs e)
{
Int32 LastEmpNO = Convert.ToInt32(((Label)rptUserData.Items[rptUserData.Items.Count - 1].FindControl("lblID")).Text);
LastEmpNO += 1;
string file = Server.MapPath("employees.xls");
string constr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + file + ";Extended Properties=Excel 8.0;";
using (OleDbConnection Connection = new OleDbConnection(constr))
{
Connection.Open();
string query = "INSERT INTO [Sheet1$](EmpNo,EmpName,EmpAddress,EmpSalary) VALUES(" + LastEmpNO + ",\"" + ename.Text.Trim() + "\",\"" + add.Text.Trim() + "\",\"" + esal.Text.Trim() + "\")";
using (OleDbCommand objCmd = new OleDbCommand(query, Connection))
{
objCmd.ExecuteNonQuery();
objCmd.Dispose();
Connection.Close();
}
}
BindRepeater();
divInsertUpdate.Visible = false;
}
private void UpdateRecord()
{
string file = Server.MapPath("employees.xls");
string constr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + file + ";Extended Properties=Excel 8.0;";
using (OleDbConnection Connection = new OleDbConnection(constr))
{
Connection.Open();
string query = "UPDATE [Sheet1$] SET EmpName=\"" + ename.Text.Trim() + "\",EmpAddress=\"" + add.Text.Trim() + "\",EmpSalary=\"" + esal.Text.Trim() + "\" WHERE EmpNo=" + btnUpdate.CommandArgument.ToString();
using (OleDbCommand objCmd = new OleDbCommand(query, Connection))
{
objCmd.ExecuteNonQuery();
objCmd.Dispose();
Connection.Close();
}
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
UpdateRecord();
BindRepeater();
divInsertUpdate.Visible = false;
}
}http://www.myaspnet.com/codedisplay.aspx?id=386
صدق من قال: ("الله في عون العبد مادام العبد في عون اخيه")
السلام عليكم:)
هذا الموضوع يمكن يفيدك.. فيه مثال للتنزيل كمان
والسلام عليكم