Unicoded CSV supports chinese characters but excell shows all columns in a single column (may be an excell unicode csv issue) RSS

• • Reply
  

  TheDevMan

  0 Points

  2 Posts

  Unicoded CSV supports chinese characters but excell shows all columns in a single column (may be ...

  Dec 06, 2007 04:43 PM|LINK

  so i have the unicoded CSV that supports chinese but excel doesn't like it, it put all the columns into a single columns.  Any though?

  Response.Clear();

  Response.Cache.SetCacheability(HttpCacheability.NoCache);

  Response.ContentEncoding = Encoding.Unicode;

  Response.Charset = "Unicode";

  Response.AddHeader("Content-Type", "text/csv");

  Response.AddHeader("Content-Disposition", "inline;filename=consultantList.csv");Response.BinaryWrite(Encoding.Unicode.GetPreamble());

  Response.Write(csv.ToString());

  Response.End();