阅读背景:

在ASP.NET中导出到excel时,中文字符变得不可读

来源:互联网 
public class HomeController : Controller
{        
    static List<User> GetUsers()
    {
        List<User> list = new List<User>() { 
        new User{Id=1,Name="张三"},
        new User{Id=2,Name="lisi"},
        new User{Id=3,Name="wangwu"}
        };
        return list;
    }
    public void SaveToExcel()
    {
        StringBuilder sb = new StringBuilder();
        sb.Append("id").Append("\t");
        sb.Append("name").Append("\n");
        List<User> list = GetUsers();
        foreach (var item in list)
        {
            sb.Append(item.Id).Append("\t");
            sb.Append(item.Name).Append("\n");
        }
        Response.Clear();
        Response.Buffer = true;
        Response.Charset = "UTF-8";
        Response.ContentEncoding = Encoding.UTF8;
        Response.ContentType = "application/ms-excel";
        Response.AppendHeader("Content-Disposition", "attachment; filename=card.xls");
        Response.Write(sb.ToString());
        Response.End();
    }
public class HomeController : Controller
{     



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: