生成.csv文件给用户下载
求解，，谁知道Asp.net 生成.csv文件给用户下载，而且 用excel 打开不乱码？ 我找了个方法但肜excel打开会乱码~ asp.net
[解决办法]
Response.Clear();
Response.Charset = "UTF-8";
Response.ContentEncoding = System.Text.Encoding.UTF8;
Response.HeaderEncoding = System.Text.Encoding.UTF8;
Response.ContentType = "text/csv";
Response.BinaryWrite(new byte[] { 0xEF, 0xBB, 0xBF }); //这句是重点哦，不乱码的保证
Response.AddHeader("Content-Disposition", string.Format("attachment;filename=Customer{0:yyyy-MM-dd}.csv;", DateTime.Now));
System.Text.StringBuilder sb = new System.Text.StringBuilder();
//sb 中定义生成.csv文件的格式 中间以"\t"分开
Response.AddHeader("Content-Disposition", "attachment; filename=vhost" + string.Format("{0:yyyyMMddhhmmss}", DateTime.Now) + ".xls");
Response.ContentType = "application/text";
Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
Response.Write(sb);
Response.End();
//convert the dataset to CSV
StringBuilder sb = new StringBuilder();
for (int i = 0; i < this.GridViewSearchResult.Columns.Count; i++)
{
if (this.GridViewSearchResult.Columns[i].Visible)
{
sb.Append(@"""" + this.GridViewSearchResult.Columns[i].HeaderText + @"""" + ",");
}
}
sb.Append("\n");
foreach (DataRow row in ds.Tables[0].Rows)
{
for (int j = 0; j < this.GridViewSearchResult.Columns.Count;j++ )
{
sb.Append(@""""+row[this.GridViewSearchResult.Columns[j].HeaderText ].ToString().Replace(@"""",@"""""")+ @"""" + ",");
}
sb.Append("\n");
}
sb.Remove(sb.Length - 2, 1);
//save CSV to client
this.Response.Clear();
this.Response.ContentEncoding = System.Text.Encoding.Default;
this.Response.ContentType = "test/csv";
this.Response.AppendHeader("content-disposition", "attachment; filename=" + string.Format("{0:yyyyMMddhhmmss}", DateTime.Now) + ".csv");
this.Response.Write(sb);
this.Response.End();
