导出CSV 换行问题。

 

程序方面：

1.Windows 中的换行符"\r\n"

2.Unix/Linux 平台换行符是 "\n"。

3.MessageBox.Show() 的换行符为 "\n"

4.Console 的换行符为 "\n"

为保持平台的通用性，可以用系统默认换行符 System.Environment.NewLine。

 

sql server：换行

select subscriber_id,subscriber_email,company_name from [dbo].[NewsLetterSystem_Subscriber] where subscriber_id=6967035 update [NewsLetterSystem_Subscriber] set company_name=N'ALLY CATERING SOLUTION LIMITED'+CHAR(13)+CHAR(10) +N'安聯餐飲設備有限公司' where subscriber_id=6967035 update [NewsLetterSystem_Subscriber] set company_name=N'ALLY CATERING SOLUTION LIMITED'+CHAR(10) +N'安聯餐飲設備有限公司' where subscriber_id=6967035 update [NewsLetterSystem_Subscriber] set company_name=N'ALLY CATERING SOLUTION LIMITED'+CHAR(13) +N'安聯餐飲設備有限公司' where subscriber_id=6967035

 

C# 程序：

public static string ExportReportInCsv(DataTable dt, string filename, string tmpDir) { string tmpFilename = DateTime.Now.Ticks + "_" + filename; string tmpFilenameWithPath = tmpDir + tmpFilename; FileStream fs = new FileStream(tmpFilenameWithPath, System.IO.FileMode.Create, System.IO.FileAccess.Write); //var encoding = GetFileEncodeType(fs); StreamWriter sw = new StreamWriter(fs, System.Text.Encoding.UTF8); StringBuilder sb = new StringBuilder(); //写出列名称 for (int i = 0; i < dt.Columns.Count; i++) { sb.Append(dt.Columns[i].ColumnName.ToString()); if (i < dt.Columns.Count - 1) { sb.Append(","); } } sw.WriteLine(sb.ToString()); for (int i = 0; i < dt.Rows.Count; i++) { sb.Clear(); for (int j = 0; j < dt.Columns.Count; j++) { string rowsText = dt.Rows[i][j].ToString(); rowsText = HandleWrap(rowsText); sb.Append(rowsText); if (j < dt.Columns.Count - 1) { sb.Append(","); } } sw.WriteLine(sb.ToString()); } sw.Close(); fs.Close(); return tmpFilenameWithPath; } public static string HandleWrap(string content) { if (content.Contains(Environment.NewLine)) { var list = content.Split(Environment.NewLine.ToCharArray(), StringSplitOptions.RemoveEmptyEntries); content = string.Join(" ",list); } content = content.Replace(@"\n", " ").Replace(@"\r\n", " ").Replace((char)13,' ').Replace((char)10, ' '); return content; }

 

转载于:https://www.cnblogs.com/zoro-zero/p/7340077.html

相关资源：JAVA上百实例源码以及开源项目