开发者

No quotef for first value in csv

开发者 https://www.devze.com 2023-03-21 18:55 出处:网络
I am trying to make a very simple CSV file, everything works except one ti开发者_StackOverflow中文版ny thing : when the file get opened in Excel, the very first value of each entry isn\'t quoted, e.g

I am trying to make a very simple CSV file, everything works except one ti开发者_StackOverflow中文版ny thing : when the file get opened in Excel, the very first value of each entry isn't quoted, e.g :

username,"fullname","fullname@company.com"

And here is the code :

StringBuilder sb = new StringBuilder();

// Get user info
foreach (User u in listUsers)
{
    sb.AppendFormat("\"{0}\",\"{1}\",\"{2}\"\r\n", u.Username, u.Fullname, u.EMail);
}

// Generate csv
Response.Clear();
Response.ContentType = "text/csv";
Response.AddHeader("content-disposition", "attachment; filename=\"" + "UsersExport.csv" + "\"");
Response.Write(sb.ToString());
Response.End();

Any idea?

0

精彩评论

暂无评论...
验证码 换一张
取 消