简单Datagrid 导入 Excel

using System.IO;

  private DataSet _dataSet = new DataSet();
  private DataTable _dataTable = new DataTable();

///////////////////////////////////////按钮事件//////////////////////////////////////////////
private void btn_Excel_Click(object sender, System.EventArgs e)
  {
   _dataSet = BudgetAD.GetFieldValue(Inquiry());
   ExportExcel(_dataSet);
  }
///////////////////////////////////////////导出EXCEL文件方法//////////////////////////////////
public void ExportExcel(DataSet _dsTemp)
  {
   StringWriter sw=new StringWriter();
   string Title = "序号\t";
  
   foreach(DataColumn col in _dsTemp.Tables[0].Columns)
   {
    Title+=col.ColumnName+"\t";                
   }
   //Title = HttpUtility.UrlEncode(Title,System.Text.Encoding.UTF8);
   sw.WriteLine(Title);
   Page.RegisterStartupScript("alertMsg","<script>alert('"+Title+"')</script>");
  
   if (_dsTemp!=null)
   {
    int j=0;
    foreach (DataRow dr in _dsTemp.Tables[0].Rows)
    {
     string Value = "";
     j++;
     Value +=j.ToString()+"\t";
     for(int i=0;i<_dsTemp.Tables[0].Columns.Count;i++)
     {
      Value += "=\"" + dr[i].ToString() + "\"\t";
      //Value +="'"+dr[i].ToString()+"\t";
     }
     sw.WriteLine(Value);
    }
    
    sw.Close();
    Response.Clear();  
    //Response.Buffer = true;
    Response.AddHeader("Content-Disposition", "attachment; filename="+System.Web.HttpUtility.UrlEncode("SPA_SuperUser",System.Text.Encoding.UTF8)+".xls");
    Response.ContentType="application/ms-excel";  
    Response.ContentEncoding=System.Text.Encoding.GetEncoding("gb2312");
    Response.Write(sw);
    Response.End();
   }
  }