Class CsvHelper
Inheritance
System.Object
CsvHelper
Inherited Members
System.Object.ToString()
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
Assembly: cs.temp.dll.dll
Syntax
public static class CsvHelper
Fields
CsvQuoteCharacter
CsvQuoteCharacter, '"' by default
Declaration
public static char CsvQuoteCharacter
Field Value
Type |
Description |
System.Char |
|
CsvSeparatorCharacter
CsvSeparatorCharacter, ',' by default
Declaration
public static char CsvSeparatorCharacter
Field Value
Type |
Description |
System.Char |
|
Methods
GetCsvText(Nullable<DataTable>, Boolean)
Declaration
public static string GetCsvText(this DataTable? dataTable, bool includeHeader = true)
Parameters
Type |
Name |
Description |
System.Nullable<DataTable> |
dataTable |
|
System.Boolean |
includeHeader |
|
Returns
Type |
Description |
System.String |
|
GetCsvText<TEntity>(IEnumerable<TEntity>, Boolean)
Declaration
public static string GetCsvText<TEntity>(this IEnumerable<TEntity> entities, bool includeHeader = true)
Parameters
Type |
Name |
Description |
IEnumerable<TEntity> |
entities |
|
System.Boolean |
includeHeader |
|
Returns
Type |
Description |
System.String |
|
Type Parameters
ToCsvBytes(DataTable)
Declaration
public static byte[] ToCsvBytes(this DataTable dt)
Parameters
Type |
Name |
Description |
DataTable |
dt |
|
Returns
Type |
Description |
System.Byte[] |
|
ToCsvBytes(DataTable, Boolean)
Declaration
public static byte[] ToCsvBytes(this DataTable dataTable, bool includeHeader)
Parameters
Type |
Name |
Description |
DataTable |
dataTable |
|
System.Boolean |
includeHeader |
|
Returns
Type |
Description |
System.Byte[] |
|
ToCsvBytes<TEntity>(IEnumerable<TEntity>)
Declaration
public static byte[] ToCsvBytes<TEntity>(this IEnumerable<TEntity> entities)
Parameters
Type |
Name |
Description |
IEnumerable<TEntity> |
entities |
|
Returns
Type |
Description |
System.Byte[] |
|
Type Parameters
ToCsvBytes<TEntity>(IEnumerable<TEntity>, Boolean)
Declaration
public static byte[] ToCsvBytes<TEntity>(this IEnumerable<TEntity> entities, bool includeHeader)
Parameters
Type |
Name |
Description |
IEnumerable<TEntity> |
entities |
|
System.Boolean |
includeHeader |
|
Returns
Type |
Description |
System.Byte[] |
|
Type Parameters
ToCsvFile(DataTable, String)
Declaration
public static bool ToCsvFile(this DataTable dt, string filePath)
Parameters
Type |
Name |
Description |
DataTable |
dt |
|
System.String |
filePath |
|
Returns
Type |
Description |
System.Boolean |
|
ToCsvFile(DataTable, String, Boolean)
Declaration
public static bool ToCsvFile(this DataTable dataTable, string filePath, bool includeHeader)
Parameters
Type |
Name |
Description |
DataTable |
dataTable |
|
System.String |
filePath |
|
System.Boolean |
includeHeader |
|
Returns
Type |
Description |
System.Boolean |
|
ToCsvFile<TEntity>(IEnumerable<TEntity>, String)
Declaration
public static bool ToCsvFile<TEntity>(this IEnumerable<TEntity> entities, string filePath)
Parameters
Type |
Name |
Description |
IEnumerable<TEntity> |
entities |
|
System.String |
filePath |
|
Returns
Type |
Description |
System.Boolean |
|
Type Parameters
ToCsvFile<TEntity>(IEnumerable<TEntity>, String, Boolean)
Declaration
public static bool ToCsvFile<TEntity>(this IEnumerable<TEntity> entities, string filePath, bool includeHeader)
Parameters
Type |
Name |
Description |
IEnumerable<TEntity> |
entities |
|
System.String |
filePath |
|
System.Boolean |
includeHeader |
|
Returns
Type |
Description |
System.Boolean |
|
Type Parameters
ToDataTable(Stream)
convert csv stream data to dataTable
Declaration
public static DataTable ToDataTable(Stream stream)
Parameters
Type |
Name |
Description |
Stream |
stream |
stream
|
Returns
Type |
Description |
DataTable |
|
ToDataTable(Byte[])
convert csv file data to dataTable
Declaration
public static DataTable ToDataTable(byte[] csvBytes)
Parameters
Type |
Name |
Description |
System.Byte[] |
csvBytes |
csv bytes
|
Returns
Type |
Description |
DataTable |
|
ToDataTable(String)
convert csv file data to dataTable
Declaration
public static DataTable ToDataTable(string filePath)
Parameters
Type |
Name |
Description |
System.String |
filePath |
csv file path
|
Returns
Type |
Description |
DataTable |
|
ToEntityList<TEntity>(Stream)
convert csv file data to entity list
Declaration
public static List<TEntity> ToEntityList<TEntity>(Stream csvStream)
Parameters
Type |
Name |
Description |
Stream |
csvStream |
csv Stream
|
Returns
Type |
Description |
List<TEntity> |
|
Type Parameters
ToEntityList<TEntity>(Byte[])
convert csv file data to entity list
Declaration
public static List<TEntity> ToEntityList<TEntity>(byte[] csvBytes)
Parameters
Type |
Name |
Description |
System.Byte[] |
csvBytes |
csv bytes
|
Returns
Type |
Description |
List<TEntity> |
|
Type Parameters
ToEntityList<TEntity>(String)
convert csv file data to entity list
Declaration
public static List<TEntity> ToEntityList<TEntity>(string filePath)
Parameters
Type |
Name |
Description |
System.String |
filePath |
csv file path
|
Returns
Type |
Description |
List<TEntity> |
|
Type Parameters