C#写建Execle

 void Els(DataSet ds)
  {
   //=========================================
   string url = "../OrdersExecle/"+ ds.Tables[0].Rows[0]["OrderID"].ToString() +".xls"; //文件名和路径
 
   hplDownload.NavigateUrl = url;
   bool flag = File.Exists(Server.MapPath(url)); //文件是否以存在

   string OledbSql;

   if(flag == false)
   {                       //不存在
    string connStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath(url)+";Extended Properties=Excel 8.0;";
    OleDbConnection conn = new OleDbConnection(connStr);
    OleDbCommand comm = new OleDbCommand();
    comm.Connection = conn;
    conn.Open();
    comm.Connection = conn;
    //=========================================

    #region 建立Oledb连接，创建xls
    OledbSql = "create table 订单详情(药品名称 varchar,产地 varchar,规格 varchar,生产批号 varchar,有效期 varchar,购买数量 varchar,单位 varchar,单价 varchar,包装 varchar,件数 varchar, 库区 varchar,开票日期 varchar,金额 varchar)";

    comm.CommandText = OledbSql;
    comm.ExecuteNonQuery();                        //创建Execle

    foreach(DataRow dr in ds.Tables[0].Rows)
    {
     OledbSql = "insert into 订单详情 values('"+dr["DrugName"].ToString()+"','"+dr["MadeArea"].ToString()+"','"+dr["Spec"].ToString()+"','"+dr["AuthorizeCoding"].ToString()+"','"+dr["yxq"].ToString()+"','"+dr["BuyNum"].ToString()+"','"+dr["DW"].ToString()+"','"+dr["Price"].ToString()+"','"+dr["packaging"].ToString()+"','"+dr["PieceNum"].ToString()+"','"+dr["pypbh"].ToString()+"','"+dr["insertTime"].ToString()+"','"+dr["HTotalPrice"].ToString()+"')";
     
     comm.CommandText = OledbSql;
     comm.ExecuteNonQuery();                       //数据写入Execle

//不知道这里可不可以用事务，知道的各位请指点啊
    }
  
    #endregion
 
     comm.Dispose();
     conn.Close();
     conn.Dispose();
   }
   //----------------------------------------------------------------