Menu

Usage

John

Add CSV2Array as a reference in your project.

Dim csv as new CSV2Array.CSV2array

To load an array:

myarray(,) = csv.Usearray(path as string, delimiter as string, FieldSeperatedWithQUotes as boolean)

Path: The full path where the CSV file exists.

Delimiter: A character used to separate the fields in the CSV file (usually a comma).

FieldSeparatedWithQuotes: True or false. True if field may be enclosed with quotes (Recommended).

Other Functions:

ReturnRowNo(ByVal var(,) As String, ByVal col As Integer, ByVal value As String)

GetValue(ByVal var(,) As String, ByVal col As Integer, ByVal field As Integer, ByVal value As String)

WriteCSV(ByVal var(,) As String, ByVal path As String, ByVal delimiter As String, ByVal existprompt As Boolean)