blocks|key|1323154|text|看看FileHelpers库。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1323155|从该站点：|1323156|The+FileHelpers+are+a+free+and+easy+to+use++.NET+library+to+import/export++data+from+fixed+length+or+delimited+records+in+files,+strings+or+streams.|style|CODE|1323157|这将确保按照RFC-4180正确处理行终止、转义等方面的各种陷阱。|1323158|entityMap|0|LINK|mutability|MUTABLE|url|http://www.filehelpers.net/|1|https://www.rfc-editor.org/rfc/rfc4180^0|2|B|0|0|0|0|44|0|6|8|1|0^^$0|@$1|2|3|4|5|6|7|V|8|@]|9|@$A|W|B|X|1|Y]]|C|$]]|$1|D|3|E|5|6|7|Z|8|@]|9|@]|C|$]]|$1|F|3|G|5|6|7|10|8|@$A|11|B|12|H|I]]|9|@]|C|$]]|$1|J|3|K|5|6|7|13|8|@]|9|@$A|14|B|15|1|16]]|C|$]]|$1|L|3|-4|5|6|7|17|8|@]|9|@]|C|$]]]|M|$N|$5|O|P|Q|C|$R|S]]|T|$5|O|P|Q|C|$R|U]]]]

Look at the <a href="http://www.filehelpers.net/" rel="nofollow noreferrer">FileHelpers</a> library.
From the site:
<code>The FileHelpers are a free and easy to use .NET library to import/export data from fixed length or delimited records in files, strings or streams. </code>
This will make sure that all kinds of gotchas in line termination, escaping and such are handled correctly, as per <a href="https://www.rfc-editor.org/rfc/rfc4180" rel="nofollow noreferrer">RFC-4180</a>.

blocks|key|1108095|text|把逗号分隔的值放在一起，我总是喜欢指出被低估的string.Join(string+separator,+string[]+elements)静态方法，但如果有帮助器库，那可能是更好的东西。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1108096|entityMap^0|N|1C|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

Putting together comma-separated values I always like to point at the much underrated <code>string.Join(string separator, string[] elements)</code> static method, but if there are helper libraries out there, that's probably better stuff.

blocks|key|1323268|text|将以下方法添加到Car中：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1323269|String+Escape(String+s)
{
++++StringBuilder+sb+=+new+StringBuilder();
++++bool+needQuotes+=+false;
++++foreach+(char+c+in+s.ToArray())
++++{
++++++++switch+(c)
++++++++{
++++++++++++case+'"':+sb.Append("\\\"");+needQuotes+=+true;+break;
++++++++++++case+'+':+sb.Append("+");+needQuotes+=+true;+break;
++++++++++++case+',':+sb.Append(",");+needQuotes+=+true;+break;
++++++++++++case+'\t':+sb.Append("\\t");+needQuotes+=+true;+break;
++++++++++++case+'\n':+sb.Append("\\n");+needQuotes+=+true;+break;
++++++++++++default:+sb.Append(c);+break;
++++++++}
++++}
++++if+(needQuotes)
++++++++return+"\""+%2B+sb.ToString()+%2B+"\"";
++++else
++++++++return+sb.ToString();
}

public+void+SerializeAsCsv(Stream+stream)
{
++++stream.Write(Escape(Name));
++++stream.Write(",");
++++stream.Write(Year.ToString());
++++stream.Write(",");
++++stream.Write(Escape(Model));
++++stream.Write("\n");
}|code-block|syntax|javascript|1323270|现在，您可以序列化整个列表：|1323271|foreach+(Car+car+in+list)
{
++++car.SerializeAsCsv(stream);
}|1323272|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

add the following method to Car:

<pre><code>String Escape(String s)
{
 StringBuilder sb = new StringBuilder();
 bool needQuotes = false;
 foreach (char c in s.ToArray())
 {
 switch (c)
 {
 case '"': sb.Append("\\\""); needQuotes = true; break;
 case ' ': sb.Append(" "); needQuotes = true; break;
 case ',': sb.Append(","); needQuotes = true; break;
 case '\t': sb.Append("\\t"); needQuotes = true; break;
 case '\n': sb.Append("\\n"); needQuotes = true; break;
 default: sb.Append(c); break;
 }
 }
 if (needQuotes)
 return "\"" + sb.ToString() + "\"";
 else
 return sb.ToString();
}

public void SerializeAsCsv(Stream stream)
{
 stream.Write(Escape(Name));
 stream.Write(",");
 stream.Write(Year.ToString());
 stream.Write(",");
 stream.Write(Escape(Model));
 stream.Write("\n");
}
</code></pre>

Now you can serialize the whole list:

<pre><code>foreach (Car car in list)
{
 car.SerializeAsCsv(stream);
}
</code></pre>

blocks|key|1323334|text|我会按照这个article实现一些附加的序列化行为。如果你想变得花哨，你可以在你的项目属性中创建一个设置。此设置将确定您的类是使用csv还是默认序列化。然后，您可以通过所示的here技术访问它。考虑使用静态构造函数来读取appsettings，并使布尔值可供序列化代码访问。Vlads的代码看起来很棒，只需将其插入到您的代码中即可。此外，您还可以考虑其他可能更可取的方法来更改序列化行为。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1323335|或者创建一个名为'SerializeAsCSV‘的接口，并像这样使用它：|1323336|//+MyCoolClass.csv的部分内容：|1323337|+++public+class+MyCoolClass+:+ISerializeAsCSV,+IDisposable
+++{

++++++protected+static+bool+serializesToCSV+=+false;


++++++static+MyCoolClass()
++++++{
+++++++++serializesToCSV+=+
++++++++++++(typeof(MyCoolClass).GetInterface("GrooveySoft.Shared.Interfaces.ISerializeAsCSV")+==+null)
++++++++++++?+false
++++++++++++:+true;

++++++}


++++++public+MyCoolClass(System.Runtime.Serialization.SerializationInfo+info,+System.Runtime.Serialization.StreamingContext+context)
++++++{
++++++++//+your+stuff+here
++++++}

++++++public+void+GetObjectData(System.Runtime.Serialization.SerializationInfo+info,+System.Runtime.Serialization.StreamingContext+context)
++++++{
+++++++++//+your+stuff+here
++++++}

++++}|code-block|syntax|javascript|1323338|//+ISerializeAsCSV.cs的内容|1323339|using+System.Runtime.Serialization;

namespace+GrooveySoft.Shared.Interfaces
{
+++///+<summary>
+++///+indicates+that+implementor+will+serialize+to+csv+format
+++///+</summary>
+++public+interface+ISerializeAsCSV+:+ISerializable
+++{
+++}
}|1323340|这应该是你的入门指南。。。我还没有编译和测试过这个。。但你大概明白了吧。|1323341|entityMap|0|LINK|mutability|MUTABLE|url|http://www.codeproject.com/KB/cs/objserial.aspx|1|http://msdn.microsoft.com/en-us/library/system.configuration.appsettingsreader.aspx^0|6|7|0|2F|4|1|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|12|8|@]|9|@$A|13|B|14|1|15]|$A|16|B|17|1|18]]|C|$]]|$1|D|3|E|5|6|7|19|8|@]|9|@]|C|$]]|$1|F|3|G|5|6|7|1A|8|@]|9|@]|C|$]]|$1|H|3|I|5|J|7|1B|8|@]|9|@]|C|$K|L]]|$1|M|3|N|5|6|7|1C|8|@]|9|@]|C|$]]|$1|O|3|P|5|J|7|1D|8|@]|9|@]|C|$K|L]]|$1|Q|3|R|5|6|7|1E|8|@]|9|@]|C|$]]|$1|S|3|-4|5|6|7|1F|8|@]|9|@]|C|$]]]|T|$U|$5|V|W|X|C|$Y|Z]]|10|$5|V|W|X|C|$Y|11]]]]

I'd implement some addtional serialzation behaviors as per this <a href="http://www.codeproject.com/KB/cs/objserial.aspx" rel="nofollow noreferrer">article</a>. If you want to get fancy, you can create a setting in your projects properties. This setting would determine if your class used csv or default serialialization. You'd then access it through the techniques shown <a href="http://msdn.microsoft.com/en-us/library/system.configuration.appsettingsreader.aspx" rel="nofollow noreferrer">here</a>. Consider using a static constructor to read appsettings and make a boolean value accessable to your serialization code. Vlads' code looks great, just plug it in to your code. Also you can consider other, maybe more desirable ways to change your serialzation behavior.

Or Create an interface called 'SerializeAsCSV' and use it kind of like this:

// Partial Contents of MyCoolClass.csv:

<pre><code> public class MyCoolClass : ISerializeAsCSV, IDisposable
 {

 protected static bool serializesToCSV = false;


 static MyCoolClass()
 {
 serializesToCSV = 
 (typeof(MyCoolClass).GetInterface("GrooveySoft.Shared.Interfaces.ISerializeAsCSV") == null)
 ? false
 : true;

 }


 public MyCoolClass(System.Runtime.Serialization.SerializationInfo info, System.Runtime.Serialization.StreamingContext context)
 {
 // your stuff here
 }

 public void GetObjectData(System.Runtime.Serialization.SerializationInfo info, System.Runtime.Serialization.StreamingContext context)
 {
 // your stuff here
 }

 }
</code></pre>

// contents of ISerializeAsCSV.cs

<pre><code>using System.Runtime.Serialization;

namespace GrooveySoft.Shared.Interfaces
{
 /// &lt;summary&gt;
 /// indicates that implementor will serialize to csv format
 /// &lt;/summary&gt;
 public interface ISerializeAsCSV : ISerializable
 {
 }
}
</code></pre>

This should get your started . . . I haven't compiled and tested this . . but you get the general idea.

blocks|key|1323373|text|另一个选择是Linq+to+CSV，这是一个可以从NuGet获得的包。有关用法示例，请参阅Combine+contents+of+two+files+using+LINQ+to+CSV。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1323374|entityMap|0|LINK|mutability|MUTABLE|url|https://www.nuget.org/packages/LinqToCsv|1|https://stackoverflow.com/questions/16845838^0|6|B|0|19|1B|1|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@$A|O|B|P|1|Q]|$A|R|B|S|1|T]]|C|$]]|$1|D|3|-4|5|6|7|U|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]|L|$5|G|H|I|C|$J|M]]]]

Another option is <a href="https://www.nuget.org/packages/LinqToCsv" rel="nofollow noreferrer">Linq to CSV</a>, a package available from NuGet. See <a href="https://stackoverflow.com/questions/16845838">Combine contents of two files using LINQ to CSV</a> for example usage.

blocks|key|1108318|text|我一直在寻找解决方案，但我找到的答案都不能满足我对简单性的追求。我意识到我已经用我的自动CRUD代码得到了答案。我重新调整了它的用途，并编写了以下代码：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1108319|using+System.Reflection;
++++///+<summary>
++++///+Using+a+bit+of+reflection+to+build+up+the+strings.
++++///+</summary>
++++public+static+string+ToCsvHeader(this+object+obj)
++++{
++++++++Type+type+=+obj.GetType();
++++++++var+properties+=+type.GetProperties(BindingFlags.DeclaredOnly+%7C
+++++++++++++++++++++++++++++++++++++++BindingFlags.Public+%7C
+++++++++++++++++++++++++++++++++++++++BindingFlags.Instance);

++++++++string+result+=+string.Empty;
++++++++Array.ForEach(properties,+prop+=>
++++++++{
++++++++++++result+%2B=+prop.Name+%2B+",";
++++++++});

++++++++return+(!string.IsNullOrEmpty(result)+?+result.Substring(0,+result.Length+-+1)+:+result);
++++}

++++public+static+string+ToCsvRow(this+object+obj)
++++{
++++++++Type+type+=+obj.GetType();
++++++++var+properties+=+type.GetProperties(BindingFlags.DeclaredOnly+%7C
+++++++++++++++++++++++++++++++++++++++BindingFlags.Public+%7C
+++++++++++++++++++++++++++++++++++++++BindingFlags.Instance);

++++++++string+result+=+string.Empty;
++++++++Array.ForEach(properties,+prop+=>
++++++++{
++++++++++++var+value+=+prop.GetValue(obj,+null);
++++++++++++var+propertyType+=+prop.PropertyType.FullName;
++++++++++++if+(propertyType+==+"System.String")
++++++++++++{
++++++++++++++++//+wrap+value+incase+of+commas
++++++++++++++++value+=+"\""+%2B+value+%2B+"\"";
++++++++++++}

++++++++++++result+%2B=+value+%2B+",";

++++++++});

++++++++return+(!string.IsNullOrEmpty(result)+?+result.Substring(0,+result.Length+-+1)+:+result);
++++}|code-block|syntax|javascript|1108320|这将为每个对象添加一个扩展方法。用法如下：|1108321|var+burgers+=+new+List<Cheeseburger>();
var+output+=+burgers.ToCsvHeader();
output+%2B=+Environment.NewLine;

burgers.ForEach(burger+=>
{
++++output+%2B=+burger.ToCsvRow();
++++output+%2B=+Environment.NewLine;
});
var+path+=+"[where+ever+you+want]";
System.IO.File.WriteAllText(path,+output);|1108322|上面可能有一种更好的方法来编写这两个方法，但这种方法非常适合我的情况。希望这能帮助到别人。|1108323|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|S|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

I was searching for a solution for this, but none of the answers I found satisfied my drive for simplicity. I realised I had the answer already with my auto CRUD code. I repurposed it and came up with the following code:

<pre><code>using System.Reflection;
 /// &lt;summary&gt;
 /// Using a bit of reflection to build up the strings.
 /// &lt;/summary&gt;
 public static string ToCsvHeader(this object obj)
 {
 Type type = obj.GetType();
 var properties = type.GetProperties(BindingFlags.DeclaredOnly |
 BindingFlags.Public |
 BindingFlags.Instance);

 string result = string.Empty;
 Array.ForEach(properties, prop =&gt;
 {
 result += prop.Name + ",";
 });

 return (!string.IsNullOrEmpty(result) ? result.Substring(0, result.Length - 1) : result);
 }

 public static string ToCsvRow(this object obj)
 {
 Type type = obj.GetType();
 var properties = type.GetProperties(BindingFlags.DeclaredOnly |
 BindingFlags.Public |
 BindingFlags.Instance);

 string result = string.Empty;
 Array.ForEach(properties, prop =&gt;
 {
 var value = prop.GetValue(obj, null);
 var propertyType = prop.PropertyType.FullName;
 if (propertyType == "System.String")
 {
 // wrap value incase of commas
 value = "\"" + value + "\"";
 }

 result += value + ",";

 });

 return (!string.IsNullOrEmpty(result) ? result.Substring(0, result.Length - 1) : result);
 }
</code></pre>

This would add an extension method on to every object. Usage like this:

<pre><code>var burgers = new List&lt;Cheeseburger&gt;();
var output = burgers.ToCsvHeader();
output += Environment.NewLine;

burgers.ForEach(burger =&gt;
{
 output += burger.ToCsvRow();
 output += Environment.NewLine;
});
var path = "[where ever you want]";
System.IO.File.WriteAllText(path, output);
</code></pre>

There is probably a better way to write these two methods above, but this works perfectly for my situation. Hope it helps someone.

blocks|key|1323536|text|您可以简单地覆盖ToString方法或创建一个ToCSVRow()方法|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1323537|++++public+String+ToCSVRow()
++++{
++++++++return+Name+%2B+","+%2B+Year.ToString()+%2B+","+%2B+Model;
++++}|code-block|syntax|javascript|1323538|然后在需要的地方做一些类似的事情。|1323539|++++using+(StreamWriter+file+=+new+StreamWriter(@"C:\Wherever\yourfilename.txt"))
++++++++{
++++++++++++foreach+(var+item+in+yourlist)
++++++++++++{
++++++++++++++++file.WriteLine(item.ToCSVRow());
++++++++++++}
++++++++}|1323540|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

You could simply override the ToString method or create a ToCSVRow() method as such 

<pre><code> public String ToCSVRow()
 {
 return Name + "," + Year.ToString() + "," + Model;
 }
</code></pre>

And then just do something like this where needed.

<pre><code> using (StreamWriter file = new StreamWriter(@"C:\Wherever\yourfilename.txt"))
 {
 foreach (var item in yourlist)
 {
 file.WriteLine(item.ToCSVRow());
 }
 }
</code></pre>

If I have a list of objects called "Car":

<pre><code>public class Car
{
 public string Name;
 public int Year;
 public string Model;
}
</code></pre>

How do I convert a list of objects, e.g. List&lt;Car&gt; to a csv?

How can I convert a list of objects to csv?

如果我有一个名为“Car”的对象列表：public class Car{     public string Name;     public int Year;     public string Model;}如何将对象列表转换为csv？

问如何将对象列表转换为csv？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何将对象列表转换为csv？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何将对象列表转换为csv？
EN