For Example

数值为<代码>9,11,32”。我必须出口。

But when I do the first column conatins 9 then in next column 11.

我想在CSV档案的同一栏中显示9,11,32<>/code>。我如何这样做?

Answer 1

简单地把你的数据放在像“......”+你的数据+“”。

StringWriter csv = new StringWriter();
// Generate header of the CSV file
csv.WriteLine(string.Format("{0},{1}", "Header 1", "Header 2"));
// Generate content of the CSV file
foreach (var item in YourListData)
{
    csv.WriteLine(string.Format("{0},{1}", item.Data1, """ + item.Data2 + """));
}

return File(new System.Text.UTF8Encoding().GetBytes(csv.ToString()), "application/csv", string.Format("{0}{1}", "YourFileName", ".csv"));

例如: 您的数据2 可能含有 com子“,”

Answer 2

Fields with embedded commas must be delimited with double-quote characters.

<>光线>
1. abc, xyz
2. pqr

<<>strong>csv edition:

"abc, xyz" , pqr

含有<条码>双重引用的特征的方面必须以双重引用为重,嵌入的双重引用必须分别以连续的双字母为代表。

http://www.ohchr.org。
```
Welcome to "My World"
```
<<>strong>csv edition:
```
"Welcome to ""My World"""
```

Answer 3

如果在数据中有一个ma子,你需要将。引言如下:

"123,56","A dog, cat and a frog"

Answer 4

StringBuilder sb = new StringBuilder();          
        foreach (DataColumn col in dt.Columns)
        {
            if (col.ColumnName.Contains(","))
            {
                sb.Append(String.Format(""{0}",", col.ColumnName));
            }
            else
            {
                sb.Append(String.Format("{0},", col.ColumnName));
            }
        }

Answer 5

双重引用的价值。

string ValueToEscape = "a,b";

""" + ValueToEscape + """

CSV Output = a,b

Answer 6

书写使双面引述的价值分离,没有空间为 com子分离的数值形成一栏。

页: 1 页: 1 价值Code01 &Val1,Val2,Val3。制作记本栏下特定数据记号的记号,并用剪辑予以保存。

Code,Description
Code01,"Val1,Val2,Val3"

For Example

友情链接