用c#将unicode字符串写入CSV
本文关键字:CSV 字符串 unicode | 更新日期: 2023-09-27 17:51:05
我使用以下代码从unicode字符串创建csv文件:
context.Response.ContentType = "text/csv";
context.Response.ContentEncoding = System.Text.Encoding.Utf8;
context.Response.AddHeader("Content-Disposition", "attachment; filename=" + fundName + ".csv");
context.Response.BinaryWrite(System.Text.Encoding.Unicode.GetPreamble());
String output ="";
output += "Name, callNumber" + "'n";
String output ="علی,34343555" + "'n";
context.Response.Write(output);
问题是unicode字符不能正确显示"علی"。
谢谢你的指导。问候阿里
我宁愿使用streamwriter来编写使用UTF-8编码的unicode字符。片段:
using (StreamWriter sw = new StreamWriter(new FileStream("c:/Temp.csv", FileMode.Create), Encoding.UTF8))
{
sw.WriteLine(string.Join(",", s));
}
代码中的几个问题。
-
context.Response.BinaryWrite(System.Text.Encoding.Unicode.GetPreamble());
写入UTF-32 而不是 UTF-8的BOM。 -
输出变量定义两次
我建议试试这个:
context.Response.ContentType = "text/csv";
context.Response.ContentEncoding = System.Text.Encoding.Utf8;
context.Response.AddHeader("Content-Disposition", "attachment; filename=" + fundName + ".csv");
String output ="";
output += "Name, callNumber" + "'n";
output +="علی,34343555" + "'n";
context.Response.Write(output);
context.Response.End()
使用Encoding.Unicode
编写Unicode CSV文件:
File.WriteAllText("path/to/file.csv", yourString, Encoding.Unicode);
Response.Clear();
Response.AppendHeader("Content-Type", "Application/vnd.ms-excel");
Response.ContentEncoding = Encoding.UTF8;
Response.AppendHeader("Content-Disposition", "attachment; filename=filename1.csv");
var data = Encoding.UTF8.GetBytes("your content with chinese characters");
var result = Encoding.UTF8.GetPreamble().Concat(data).ToArray();
var str = Encoding.UTF8.GetString(result);
Response.Write(str);
Response.Flush();
Response.SuppressContent = true;