.net中导出Excel

来源：互联网发布：unity3d 官方换装demo 编辑：程序博客网时间：2024/06/05 22:36

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();

0 0