CSV Reports
CsvReader Class Members
Properties  Methods 


KellermanSoftware.CsvReports Namespace : CsvReader Class

The following tables list the members exposed by CsvReader.

Public Constructors
 NameDescription
Public ConstructorCsvReader ConstructorOverloaded.   
Top
Public Properties
 NameDescription
Public PropertyConvertBlankToNull If true, blanks (string.empty) will be converted to null. The default is false.  
Public PropertyDefaultEncoding Override the default encoding. The default is Encoding.Default  
Public PropertyEscapeCharacter Value used to escape the quote character. Defaults to \  
Public PropertyHasHeader If true, the source has a header. Defaults to true  
Public PropertyQuoteCharacter The quote character. Defaults to double quote  
Public PropertyRemoveColumnNameSpaces Any spaces in header column names are removed. The default is true.  
Public PropertySeperator The seperator for the columns. Default is a comma. It can be changed to a pipe, tab, etc.  
Public PropertyTrimSpaces Any spaces will be trimmed. The default is true.  
Top
Public Methods
 NameDescription
Public MethodCsvFileToDataReader Create a forward only reader for a CSV file  
Public MethodCsvFileToDataTable Read a CSV file into a DataTable. There must be a header row and the column names must be alpha numeric.  
Public MethodCsvFileToDictionary Read a CSV File and return a dictionary with the keys as the header names. By default header column name spaces are removed. See RemoveColumnNameSpaces.  
Public MethodCsvFileToObjectList<T> Read a CSV file into a list of objects. Public properties are mapped by name, they are case sensitive. It will automatically map all primitive types such as int, long, string and complex types of GUID, Enum, DateTime. Properties that do not exist are ignored.  
Public MethodCsvFileToStringList Read a CSV File and return a list of rows and columns  
Public MethodCsvStreamToDataReader Create a forward only reader for a CSV stream  
Public MethodCsvStreamToDataTable Read a CSV stream into a DataTable  
Public MethodCsvStreamToDictionary Read a CSV Stream and return a dictionary with the keys as the header names. By default header column name spaces are removed. See RemoveColumnNameSpaces.  
Public MethodCsvStreamToObjectList<T> Read a CSV stream into a list of objects. Public properties are mapped by name, they are case sensitive. By default header column name spaces are removed. See RemoveColumnNameSpaces. It will automatically map all primitive types such as int, long, string and complex types of GUID, Enum, DateTime Properties that do not exist are ignored.  
Public MethodCsvStreamToStringList Read a CSV Stream and return a list of rows and columns  
Public MethodCsvStringToDataTable Read a CSV string into a DataTable. There must be a header row and the column names must be alpha numeric.  
Public MethodCsvStringToDictionary Read a CSV String and return a dictionary with the keys as the header names. By default header column name spaces are removed. See RemoveColumnNameSpaces.  
Public MethodCsvStringToObjectList<T> Read a CSV string into a list of objects. Public properties are mapped by name, they are case sensitive. It will automatically map all primitive types such as int, long, string and complex types of GUID, Enum, DateTime. Properties that do not exist are ignored.  
Public MethodCsvStringToStringList Read a CSV String and return a list of rows and columns  
Public MethodPreProcessFile This will replace CR with CRLF if the line does not already end with CRLF  
Top
See Also

Reference

CsvReader Class
KellermanSoftware.CsvReports Namespace

 

 

©2021. Kellerman Software. All Rights Reserved.

Product Website