CsvConverterFill(DataTable, String, CsvMapping, Char, Encoding, Boolean, CsvOpts) Method

public static void Fill(
	DataTable dataTable,
	string filePath,
	CsvMapping mapping,
	char delimiter = ',',
	Encoding? textEncoding = null,
	bool isHeaderPresent = true,
	CsvOpts options = CsvOpts.Default
)

Public Shared Sub Fill ( 
	dataTable As DataTable,
	filePath As String,
	mapping As CsvMapping,
	Optional delimiter As Char = ","C,
	Optional textEncoding As Encoding = Nothing,
	Optional isHeaderPresent As Boolean = true,
	Optional options As CsvOpts = CsvOpts.Default
)

public:
static void Fill(
	DataTable^ dataTable, 
	String^ filePath, 
	CsvMapping^ mapping, 
	wchar_t delimiter = L',', 
	Encoding^ textEncoding = nullptr, 
	bool isHeaderPresent = true, 
	CsvOpts options = CsvOpts::Default
)

static member Fill : 
        dataTable : DataTable * 
        filePath : string * 
        mapping : CsvMapping * 
        ?delimiter : char * 
        ?textEncoding : Encoding * 
        ?isHeaderPresent : bool * 
        ?options : CsvOpts 
(* Defaults:
        let _delimiter = defaultArg delimiter ','
        let _textEncoding = defaultArg textEncoding null
        let _isHeaderPresent = defaultArg isHeaderPresent true
        let _options = defaultArg options CsvOpts.Default
*)
-> unit 

Parameters

dataTable  DataTable

The DataTable to which DataRows are added.

filePath  String

File path of the CSV file.

mapping  CsvMapping

The CsvMapping to be used.

delimiter  Char  (Optional)

The field separator character.

textEncoding  Encoding  (Optional)

The text encoding to be used to read the CSV file or null for UTF8.

isHeaderPresent  Boolean  (Optional)

true, to interpret the first line as a header, otherwise false.

options  CsvOpts  (Optional)

Options for reading the CSV file.

Each PropertyName of mapping MUST have a corresponding DataColumn in dataTable - corresponding in the Caption property (case-insensitive) and the accepted data type.

Effort must be taken that the PropertyNames in mapping are unique, even when treated case-insensitive.

The DynamicProperty instances in mapping don't need to match all columns of the DataTable or all columns of the CSV file (neither in number nor in order).

When importing CSV data from Excel, the appropriate arguments can be determined with GetExcelArguments.

Reference