本人小菜鸟,最近在将Json文件整理成Excel档(几百行且字段多的很,手动对起来实在累),想着个人习惯Csv更方便程序处理,就加了中间人Json->Csv->Excel,这些都是大前提。
private void button2_Click(object sender, EventArgs e)
{
try
{
string path = Environment.CurrentDirectory + "\\aaa_" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".csv";
FileStream stream = System.IO.File.Create(path);
stream.Close();
stream.Dispose();
using (StreamWriter writer = new StreamWriter(path, true))
{
string WriteRecord = textBox1.Text;
WriteRecord = WriteRecord.Substring(0, WriteRecord.Length - 1);
writer.WriteLine(WriteRecord,Encoding.UTF8);
writer.Flush();
writer.Close();
}
}
catch(Exception ex)
{
Trace.WriteLine(ex.ToString());
}
}
很简单的代码,网上都可以找到的文件流写入。问题在于的想写入“\\d{12}$”,抛异常了
原因出在大括号“{ }”不能用UTF8或者GB2312,为什么?
去掉Encoding.UTF8肯定是可以的,但是会是乱码
用UTF-8是因为Json文件里包含中英文和各种字符,Csv转Excel 中文会乱码,先在这里放着,小小研究一下回复自己