CsvOpenReadAnalyzed Method

public static CsvReader OpenReadAnalyzed(
	string filePath,
	Encoding? defaultEncoding = null,
	Header header = Header.ProbablyPresent,
	bool disableCaching = false,
	int analyzedLines = 5
)

Public Shared Function OpenReadAnalyzed ( 
	filePath As String,
	Optional defaultEncoding As Encoding = Nothing,
	Optional header As Header = Header.ProbablyPresent,
	Optional disableCaching As Boolean = false,
	Optional analyzedLines As Integer = 5
) As CsvReader

public:
static CsvReader^ OpenReadAnalyzed(
	String^ filePath, 
	Encoding^ defaultEncoding = nullptr, 
	Header header = Header::ProbablyPresent, 
	bool disableCaching = false, 
	int analyzedLines = 5
)

static member OpenReadAnalyzed : 
        filePath : string * 
        ?defaultEncoding : Encoding * 
        ?header : Header * 
        ?disableCaching : bool * 
        ?analyzedLines : int 
(* Defaults:
        let _defaultEncoding = defaultArg defaultEncoding null
        let _header = defaultArg header Header.ProbablyPresent
        let _disableCaching = defaultArg disableCaching false
        let _analyzedLines = defaultArg analyzedLines 5
*)
-> CsvReader 

Parameters

filePath  String

File path of the CSV file.

defaultEncoding  Encoding  (Optional)

The text Encoding to be used if the CSV file has no byte order mark (BOM), or null to use UTF8 in this case. Use GetExcelArguments to get the appropriate argument for this parameter when importing CSV data from Excel.

header  Header  (Optional)

A supposition that is made about the presence of a header row.

disableCaching  Boolean  (Optional)

true to set the DisableCaching flag, otherwise false.

analyzedLines  Int32  (Optional)

Maximum number of lines to analyze in the CSV file. The minimum value is AnalyzedLinesMinCount. If the file has fewer lines than analyzedLines, it will be analyzed completely. (You can specify Int32.MaxValue to analyze the entire file in any case.)

Return Value

The method performs a statistical analysis on the CSV file to find the appropriate parameters for reading the file. The result of the analysis is therefore always only an estimate, the accuracy of which increases with the number of lines analyzed. The analysis is time-consuming because the CSV file has to be accessed for reading.

The field delimiters COMMA (',', %x2C), SEMICOLON (';', %x3B), HASH ('#', %x23), TAB ('\t', %x09), and SPACE (' ', %x20) are recognized automatically.

This method also tries to determine the Encoding of the CSV file from the byte order mark (BOM). If no byte order mark can be found, defaultEncoding is used.

Reference