.net中导出Excel

1.GridView中数据导出到Excel

public override void VerifyRenderingInServerForm(Control control)
{
}
 public void ExcelOut(GridView gv)
    {
       if (gv.Rows.Count > 0)
       {
           stringdeskPath =System.Environment.GetFolderPath(System.Environment.SpecialFolder.Desktop);
          Response.Clear();
          Response.ClearContent();
          Response.AddHeader("Content-Disposition", "attachment;filename="考勤记录.xls");
          Response.ContentEncoding =System.Text.Encoding.GetEncoding("GB2312");
          Response.ContentType = "application/ms-excel";
          StringWriter sw = new StringWriter();
          HtmlTextWriter htw = new HtmlTextWriter(sw);
          gv.RenderControl(htw);
          Response.Write(sw.ToString());
          Response.Flush();
          Response.End();
       }
       else
       {
          Response.Write("没有数据");
       }
    }

2.Dataset中数据导出到Excel

   

  //建立Excel对象  
       HttpResponse resp;
       resp = Page.Response;
       resp.ContentEncoding =System.Text.Encoding.GetEncoding("GB2312");
       HttpBrowserCapabilities b =Request.Browser;
       if (b.Browser.ToString() == "IE")
       {
           stringfilename = year + "年房地产收费记录.xls";
          resp.AppendHeader("Content-Disposition", "attachment;filename=" +HttpUtility.UrlEncode(filename, System.Text.Encoding.UTF8));
       }
       else
       {
          resp.AppendHeader("Content-Disposition","attachment;filename="收费记录.xls");
       }
       resp.ContentType = "application/ms-excel";
       string colHeaders = "", ls_item = "";
      //定义表对象与行对象，同时用DataSet对其值进行初始化 
       DataTable dt = ds.Tables[0];
       DataRow[] myRow =dt.Select();//可以类似dt.Select("id>10")之形式达到数据筛选目的
       int i = 0;
       int cl = dt.Columns.Count;
      //取得数据表各列标题，各标题之间以t分割，最后一个列标题后加回车符 
       for (i = 0; i < cl; i++)
       {
           if (i ==(cl - 1))//最后一列，加n
           {
              colHeaders +=dt.Columns[i].Caption.ToString() + "\n";
           }
           else
           {
              colHeaders +=dt.Columns[i].Caption.ToString() + "\t";
           }
       }
       resp.Write(colHeaders);
       //向HTTP输出流中写入取得的数据信息 
       //逐行处理数据  
       foreach (DataRow row in myRow)
       {
          //当前行数据写入HTTP输出流，并且置空ls_item以便下行数据    
           for (i =0; i < cl; i++)
           {
              if (i == (cl -1))//最后一列，加n
              {
                 ls_item += row[i].ToString() + "\n";
              }
              else
              {
                 ls_item += row[i].ToString() + "\t";
              }
           }
          resp.Write(ls_item);
           ls_item ="";
       }
       resp.End();