A .NET library for technical solutions to CSV files: CsvHelper Chinese documentation-C#.Net Tutorial-php.cn

CsvHelper is a .NET library for reading and writing CSV files. CsvHelper can be downloaded through Visual Studio's package manager. Automatic mapping definition: When no mapping file is provided, the default is automatic mapping, and automatic mapping will be mapped to the attributes of the class in order.

GitHub address

Read

Read all records

var csv = new CsvReader( textReader ); var records = csv.GetRecords(); // 把 CSV 记录映射到 MyClass，返回的 records 是个 IEnumerable 对象

Copy after login

If you want to customize the mapping relationship, you can see the mapping section below.
Since records is an IEnumerable object, a record will be returned only when accessed, and a record will be returned once accessed. If you want to access it like a list, you can do the following:

var csv = new CsvReader( textReader ); var records = csv.GetRecords().ToList();

Copy after login

Manually read records

You can read the data of each row in a row loop

var csv = new CsvReader( textReader ); while( csv.Read() ) { var record = csv.GetRecord(); }

Copy after login

Read individually The field

var csv = new CsvReader( textReader ); while( csv.Read() ) { var intField = csv.GetField( 0 ); var stringField = csv.GetField( 1 ); var boolField = csv.GetField( "HeaderName" ); }

Copy after login

If the read type may be different from expected, you can use TryGetField

var csv = new CsvReader( textReader ); while( csv.Read() ) { int intField; if( !csv.TryGetField( 0, out intField ) ) { // Do something when it can't convert. } }

Copy after login

parse

If you want each line to be returned as a string, you can use CsvParser .

var parser = new CsvParser( textReader ); while( true ) { var row = parser.Read(); // row 是个字符串 if( row == null ) { break; } }

Copy after login

Write

Write all records

var csv = new CsvWriter( textWriter ); csv.WriteRecords( records );

Copy after login

var csv = new CsvWriter( textWriter ); foreach( var item in list ) { csv.WriteRecord( item ); }

Copy after login

var csv = new CsvWriter( textWriter ); foreach( var item in list ) { csv.WriteField( "a" ); csv.WriteField( 2 ); csv.WriteField( true ); csv.NextRecord(); }

Copy after login

Mapping

Automatic mapping

If no mapping file is provided, the default For automatic mapping, automatic mapping will be mapped to the attributes of the class in order. If the attribute is a custom class, it will continue to be filled in according to the attributes of this custom class. If a circular reference occurs, automatic mapping stops.

Manual Mapping

If the CSV file and the custom class do not exactly match, you can define a matching class to handle it.

public sealed class MyClassMap : CsvClassMap { public MyClassMap() { Map( m => m.Id ); Map( m = > m.Name ); } }

Copy after login

This article is translated by tangyikejun

Reference mapping

If the attribute is a custom class that corresponds to multiple columns of the CSV file, you can use reference mapping.

public sealed class PersonMap : CsvClassMap { public PersonMap() { Map( m => m.Id ); Map( m => m.Name ); References( m => m.Address ); } } public sealed class AddressMap : CsvClassMap { public AddressMap() { Map( m => m.Street ); Map( m => m.City ); Map( m => m.State ); Map( m => m.Zip ); } }

Copy after login

Subscript specification

You can specify mapping by column subscript

public sealed class MyClassMap : CsvClassMap { public MyClassMap() { Map( m => m.Id ).Index( 0 ); Map( m => m.Name ).Index( 1 ); } }

Copy after login

Column name specification

You can also specify mapping by column name, which requires csv The file has a header record, which means that the first line records the column name

public sealed class MyClassMap : CsvClassMap { public MyClassMap() { Map( m => m.Id ).Name( "The Id Column" ); Map( m => m.Name ).Name( "The Name Column" ); } }

Copy after login

Same name processing

public sealed class MyClassMap : CsvClassMap { public MyClassMap() { Map( m => m.FirstName ).Name( "Name" ).NameIndex( 0 ); Map( m => m.LastName ).Name( "Name" ).NameIndex( 1 ); } }

Copy after login

Default value

public sealed class MyClassMap : CsvClassMap { public override void MyClassMap() { Map( m => m.Id ).Index( 0 ).Default( -1 ); Map( m => m.Name ).Index( 1 ).Default( "Unknown" ); } }

Copy after login

Type conversion

public sealed class MyClassMap : CsvClassMap { public MyClassMap() { Map( m => m.Id ).Index( 0 ).TypeConverter(); } }

Copy after login

can Optional type conversion

The default converter will handle most type conversions, but sometimes we may need to make some small changes. At this time, we can try to use optional type conversion.

public sealed class MyClassMap : CsvClassMap { public MyClassMap() { Map( m => m.Description ).Index( 0 ).TypeConverterOption( CultureInfo.InvariantCulture ); // Map( m => m.TimeStamp ).Index( 1 ).TypeConverterOption( DateTimeStyles.AdjustToUniversal ); // 时间格式转换 Map( m => m.Cost ).Index( 2 ).TypeConverterOption( NumberStyles.Currency ); // 数值类型转换 Map( m => m.CurrencyFormat ).Index( 3 ).TypeConverterOption( "C" ); Map( m => m.BooleanValue ).Index( 4 ).TypeConverterOption( true, "sure" ).TypeConverterOption( false, "nope" ); // 内容转换 } }

Copy after login

ConvertUsing

public sealed class MyClassMap : CsvClassMap { public MyClassMap() { // 常数 Map( m => m.Constant ).ConvertUsing( row => 3 ); // 把两列聚合在一起 Map( m => m.Aggregate ).ConvertUsing( row => row.GetField( 0 ) + row.GetField( 1 ) ); // Collection with a single value. Map( m => m.Names ).ConvertUsing( row => new List{ row.GetField( "Name" ) } ); // Just about anything. Map( m => m.Anything ).ConvertUsing( row => { // You can do anything you want in a block. // Just make sure to return the same type as the property. } ); } }

Copy after login

Runtime Mapping

Mappings can be created at runtime.

var customerMap = new DefaultCsvClassMap(); // mapping holds the Property - csv column mapping foreach( string key in mapping.Keys ) { var columnName = mapping[key].ToString(); if( !String.IsNullOrEmpty( columnName ) ) { var propertyInfo = typeof( Customer ).GetType().GetProperty( key ); var newMap = new CsvPropertyMap( propertyInfo ); newMap.Name( columnName ); customerMap.PropertyMaps.Add( newMap ); } } csv.Configuration.RegisterClassMap(CustomerMap);

Copy after login

This article was translated by tangyikejun

Configuration

Allow comments

// Default value csv.Configuration.AllowComments = false;

Copy after login

Automapping

var generatedMap = csv.Configuration.AutoMap();

Copy after login

Cache

TextReader Or the cache of reading and writing in TextWriter

// Default value csv.Configuration.BufferSize = 2048;

Copy after login

Comment

The commented out line will not be loaded in

// Default value csv.Configuration.Comment = '#';

Copy after login

Byte count

Record the current read How many bytes have been retrieved? Configuration.Encoding needs to be set to be consistent with the CSV file. This setting will affect the speed of parsing.

// Default value csv.Configuration.CountBytes = false;

Copy after login

Culture information

// Default value csv.Configuration.CultureInfo = CultureInfo.CurrentCulture;

Copy after login

Separator

// Default value csv.Configuration.Delimiter = ",";

Copy after login

Column number change

If turned on, a CsvBadDataException will be thrown if the column number changes

// Default value csv.Configuration.DetectColumnCountChanges = false;

Copy after login

Encoding

// Default value csv.Configuration.Encoding = Encoding.UTF8;

Copy after login

Whether there is a header record

// Default value csv.Configuration.HasHeaderRecord = true;

Copy after login

Ignore spaces in column names

Whether spaces in column names are ignored

// Default value csv.Configuration.IgnoreHeaderWhiteSpace = false;

Copy after login

Ignore private access

Whether to ignore private accessors when reading and writing

// Default value csv.Configuration.IgnorePrivateAccessor = false;

Copy after login

Ignore read exceptions

Continue reading after an exception occurs during reading

// Default value csv.Configuration.IgnoreReadingExceptions = false;

Copy after login

Ignore quotation marks

Do not use quotes as escape characters

// Default value csv.Configuration.IgnoreQuotes = false;

Copy after login

Whether column names are case-sensitive

// Default value csv.Configuration.IsHeaderCaseSensitive = true;

Copy after login

Map access

You can access custom class mappings

var myMap = csv.Configuration.Maps[typeof( MyClass )];

Copy after login

Attribute binding tag

Used to find attributes of custom classes

// Default value csv.Configuration.PropertyBindingFlags = BindingFlags.Public | BindingFlags.Instance;

Copy after login

This article was translated by tang yi ke jun

Quote

Define the escape character used to escape delimiters, brackets or line endings

// Default value csv.Configuration.Quote = '"';

Copy after login

Quotation marks for all fields

Whether to quote all fields when writing to csv. QuoteAllFields and QuoteNoFields cannot be true at the same time.

// Default value csv.Configuration.QuoteAllFields = false;

Copy after login

All fields are not quoted

QuoteAllFields and QuoteNoFields cannot be true at the same time.

// Default value csv.Configuration.QuoteNoFields = false;

Copy after login

Read exception callback

csv.Configuration.ReadingExceptionCallback = ( ex, row ) => { // Log the exception and current row information. };

Copy after login

Register class mapping

If class mapping is used, it needs to be registered before it will be actually used.

csv.Configuration.RegisterClassMap(); csv.Configuration.RegisterClassMap();

Copy after login

Skip blank records

If all fields are empty, they will be considered empty fields

// Default value csv.Configuration.SkipEmptyRecords = false;

Copy after login

Trim fields

Put the field content Trailing whitespace characters are deleted.

// Default value csv.Configuration.TrimFields = false;

Copy after login

Trim column name

// Default value csv.Configuration.TrimHeaders = false;

Copy after login

Unbinding class mapping

// Unregister single map. csv.Configuration.UnregisterClassMap(); // Unregister all class maps. csv.Configuration.UnregisterClassMap();

Copy after login

Whether an empty field throws an exception

// Default value csv.Configuration.WillThrowOnMissingField = true;

Copy after login

Type conversion

Type Conversions are CsvHelper's way of converting strings to .NET types (and vice versa).

Others

View exception information

Exception.Data["CsvHelper"] // Row: '3' (1 based) // Type: 'CsvHelper.Tests.CsvReaderTests+TestBoolean' // Field Index: '0' (0 based) // Field Name: 'BoolColumn' // Field Value: 'two'

Copy after login

DataReader and DataTable

DataReader object is written to CSV

var hasHeaderBeenWritten = false; while( dataReader.Read() ) { if( !hasHeaderBeenWritten ) { for( var i = 0; i < dataReader.FieldCount; i++ ) { csv.WriteField( dataReader.GetName( i ) ); } csv.NextRecord(); hasHeaderBeenWritten = true; } for( var i = 0; i < dataReader.FieldCount; i++ ) { csv.WriteField( dataReader[i] ); } csv.NextRecord(); }

Copy after login

DataTable object is written to CSV

using( var dt = new DataTable() ) { dt.Load( dataReader ); foreach( DataColumn column in dt.Columns ) { csv.WriteField( column.ColumnName ); } csv.NextRecord(); foreach( DataRow row in dt.Rows ) { for( var i = 0; i < dt.Columns.Count; i++ ) { csv.WriteField( row[i] ); } csv.NextRecord(); } }

Copy after login

CSV to DataTable

while( csv.Read() ) { var row = dt.NewRow(); foreach( DataColumn column in dt.Columns ) { row[column.ColumnName] = csv.GetField( column.DataType, column.ColumnName ); } dt.Rows.Add( row ); }

Copy after login

.net CsvHelper 2.0

jQuery EasyUI API Chinese Documentation - Documentation Documentation_jquery