GridView生成.csv文件

一.CSV

string filename=DateTime.Now.ToString()+".csv";
int rowCount = gridViewDL.Rows.Count + 1;
int colCount = gridViewDL.Columns.Count;
string[] arr = new string[colCount];
StringWriter fileWriter = new StringWriter();
//标题设置
arr[0]="";arr[1]="";arr[2]="";
fileWriter.WriteLine(string.Join(",", arr));
//内容
for(int i=1;i<rowCount;i++)
{
 for(int j=2,col=0;j<colCount;j++,col++)
 {
  string str = gridViewDL.Rows[i - 1].Cells[j].Text;
  if(!string.IsNullOrEmpty(str))
  {
   arr[col] = str.Replace(",",";").Replace(" ",""),Replace("&nbsp;","");//因为string.Join方法

中用的是“，”，所以把文本中的逗号都换成了分号。
  }
  fileWriter.WriteLine(String.Join(",",arr));
 }
}
Response.ClearContent();
Response.AddHeader("content-disposition","attachment;filename="+fileName);
Response.ContentType = "application/excel";
Response.ContentEncoding = System.Text.Encoding.GetEncoding("UTF-8");
Response.Write(fileWriter.ToString());
Response.End();
fileWriter.Close();

 

二：.xls

private void doDownLoad()

{

         try
        {

            System.Data.DataTable dt = BindData();//BindData()为获得要下载的数据

            string filename = "文件名.xls";

            HttpContext.Current.Response.Clear();
            HttpContext.Current.Response.Charset = "";
            HttpContext.Current.Response.AppendHeader("content-disposition", "attachment;filename=" + HttpUtility.UrlEncode(filename, System.Text.Encoding.UTF8));
            HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");
            HttpContext.Current.Response.ContentType = "application/vnd.ms-excel";
            StringWriter stringWrite = new StringWriter();
            HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);

            DataGrid dg = new DataGrid();
            dg.DataSource = dt;
            dg.DataBind();
            dg.RenderControl(htmlWrite);
            HttpContext.Current.Response.Write(stringWrite.ToString());
            HttpContext.Current.Response.End();
        }
        catch
        { }

}