Import CSV file in .NET, Java and other programming languages

// Create an instance of the class that imports CSV files
ExcelDocument workbook = new ExcelDocument();

// Import CSV file
workbook.easy_LoadCSVFile("C:\\Samples\\Tutorial30.csv");

' Create an instance of the class that imports CSV files
Dim workbook As New ExcelDocument

' Import CSV file
workbook.easy_LoadCSVFile("C:\Samples\Tutorial30.csv")

C++

// Create an instance of the class that imports CSV files
EasyXLS::IExcelDocumentPtr workbook;
hr = CoCreateInstance(__uuidof(EasyXLS::ExcelDocument),
		      NULL,
		      CLSCTX_ALL,
		      __uuidof(EasyXLS::IExcelDocument),
		      (void**) &workbook);

// Import CSV file
workbook->easy_LoadCSVFile("C:\\Samples\\Tutorial30.csv");

Click here to see Continuous Code Listing


C++.NET

// Create an instance of the class that imports CSV files
ExcelDocument ^workbook = gcnew ExcelDocument();

// Import CSV file
workbook->easy_LoadCSVFile("C:\\Samples\\Tutorial30.csv");

Click here to see Continuous Code Listing

// Create an instance of the class that imports CSV files
ExcelDocument workbook = new ExcelDocument();

// Import CSV file
workbook.easy_LoadCSVFile("C:\\Samples\\Tutorial30.csv");

.NET:

// Create an instance of the class that imports CSV files
$workbook = new COM("EasyXLS.ExcelDocument");

// Import CSV file
$workbook->easy_LoadCSVFile("C:\\Samples\\Tutorial30.csv");

Click here to see Continuous Code Listing


Java:

// Create an instance of the class that imports CSV files
$workbook = new java("EasyXLS.ExcelDocument");

// Import CSV file
$workbook->easy_LoadCSVFile("C:\\Samples\\Tutorial30.csv");

Click here to see Continuous Code Listing

' Create an instance of the class that imports CSV files
Set workbook = Server.CreateObject("EasyXLS.ExcelDocument")

' Import CSV file
workbook.easy_LoadCSVFile("C:\Samples\Tutorial30.csv")

' Create an instance of the class that imports CSV files
Set workbook = CreateObject("EasyXLS.ExcelDocument")

' Import CSV file
workbook.easy_LoadCSVFile("C:\Samples\Tutorial30.csv")

' Create an instance of the class that imports CSV files
Set workbook = CreateObject("EasyXLS.ExcelDocument")

' Import CSV file
workbook.easy_LoadCSVFile("C:\Samples\Tutorial30.csv")

<!-- Create an instance of the class that imports CSV files -->
<cfobject type="java" class="EasyXLS.ExcelDocument" name="workbook" action="CREATE">

<!-- Import CSV file -->
<cfset success = workbook.easy_LoadCSVFile("C:\Samples\Tutorial30.csv")>  

.NET:

# Create an instance of the class used to import/export Excel files
workbook = ExcelDocument()

# Import CSV file
workbook.easy_LoadCSVFile("C:\\Samples\\Tutorial30.csv")

Click here to see Continuous Code Listing


Java:

# Create an instance of the class used to import/export Excel files
workbook = gateway.jvm.ExcelDocument()

# Import CSV file
workbook.easy_LoadCSVFile("C:\\Samples\\Tutorial30.csv")


Click here to see Continuous Code Listing

// Create an instance of the class that imports CSV files
ExcelDocument workbook = new ExcelDocument();

// Import CSV file with specific encoding
System.IO.StreamReader streamReader = 
    new System.IO.StreamReader("C:\\Samples\\File.csv", System.Text.Encoding.Unicode);
workbook.easy_LoadCSVFile(streamReader);

' Create an instance of the class that imports CSV files
Dim workbook As New ExcelDocument

' Import CSV file with specific encoding
Dim streamReader As System.IO.StreamReader = 
    New System.IO.StreamReader("C:\\Samples\\File.csv", System.Text.Encoding.Unicode)
workbook.easy_LoadCSVFile(streamReader)

C++
// Create an instance of the class that imports CSV files
EasyXLS::IExcelDocumentPtr workbook;
hr = CoCreateInstance(__uuidof(EasyXLS::ExcelDocument),
		      NULL,
		      CLSCTX_ALL,
		      __uuidof(EasyXLS::IExcelDocument),
		      (void**) &workbook);

// Import CSV file with specific encoding
workbook->easy_LoadCSVFile_4("C:\\Samples\\File.csv", "Unicode");


C++.NET

// Create an instance of the class that imports CSV files
ExcelDocument ^workbook = gcnew ExcelDocument();

// Import CSV file with specific encoding
System::IO::StreamReader ^streamReader = gcnew System::IO::StreamReader
    ("C:\\Samples\\File.csv", System::Text::Encoding::Unicode);
workbook->easy_LoadCSVFile(streamReader);

// Create an instance of the class that imports CSV files
ExcelDocument workbook = new ExcelDocument();

// Import CSV file with specific encoding
java.io.InputStream inputStream = new java.io.FileInputStream("C:\\Samples\\File.csv");
java.io.InputStreamReader inputStreamReader = new java.io.InputStreamReader(
        inputStream, java.nio.charset.Charset.forName("Unicode"));
      workbook.easy_LoadCSVFile(inputStreamReader);

.NET:

// Create an instance of the class that imports CSV files
$workbook = new COM("EasyXLS.ExcelDocument");

// Import CSV file with specific encoding
$workbook->easy_LoadCSVFile_4("C:\\Samples\\File.csv", "Unicode");


Java:

// Create an instance of the class that imports CSV files
$workbook = new java("EasyXLS.ExcelDocument");

// Import CSV file with specific encoding
$workbook->easy_LoadCSVFile("C:\\Samples\\File.csv", "Unicode");

' Create an instance of the class that imports CSV files
Set workbook = Server.CreateObject("EasyXLS.ExcelDocument")

' Import CSV file with specific encoding
workbook.easy_LoadCSVFile_4 "C:\Samples\File.csv", "Unicode"

' Create an instance of the class that imports CSV files
Set workbook = CreateObject("EasyXLS.ExcelDocument")

' Import CSV file with specific encoding
workbook.easy_LoadCSVFile_4 "C:\\Samples\\File.csv", "Unicode"

' Create an instance of the class that imports CSV files
Set workbook = CreateObject("EasyXLS.ExcelDocument")

' Import CSV file with specific encoding
workbook.easy_LoadCSVFile_4 "C:\Samples\File.csv", "Unicode"

<!-- Create an instance of the class that imports CSV files -->
<cfobject type="java" class="EasyXLS.ExcelDocument" name="workbook" action="CREATE">

<!-- Import CSV file with specific encoding -->
<cfset success = workbook.easy_LoadCSVFile("C:\Samples\File.csv", "Unicode")>  

.NET:

# Create an instance of the class that imports CSV files
workbook = ExcelDocument()

# Import CSV file with specific encoding
streamReader = System.IO.StreamReader("C:\\Samples\\File.csv", 
                                      System.Text.Encoding.Unicode);
workbook.easy_LoadCSVFile(streamReader);


Java:

# Create an instance of the class that imports CSV files
workbook = gateway.jvm.ExcelDocument()

# Import CSV file with specific encoding
workbook.easy_LoadCSVFile("C:\\Samples\\File.csv", "Unicode")

// Create an instance of the class that reads CSV files
ExcelDocument workbook = new ExcelDocument();

// Read CSV file to DataTable
DataSet ds = workbook.easy_ReadCSVFile_AsDataSet("C:\\Samples\\CSV to DataTable.csv");
DataTable dataTable = ds.Tables[0];
   
// Display imported DataTable values
for (int row=0; row < dataTable.Rows.Count; row++)
    for (int column=0; column < dataTable.Columns.Count; column++)
           Console.WriteLine("At row " + (row + 1) + ", column " + (column + 1) + 
                      " the value is '" + dataTable.Rows[row].ItemArray[column] + "'");

' Create an instance of the class that reads CSV files
Dim workbook As New ExcelDocument

' Read CSV file to DataTable
Dim ds As DataSet = workbook.easy_ReadCSVFile_AsDataSet(
                             "C:\Samples\CSV to DataTable.csv")
Dim dataTable As DataTable = ds.Tables(0)

' Display imported DataTable values
For row As Integer = 0 To dataTable.Rows.Count - 1
    For column As Integer = 0 To dataTable.Columns.Count - 1
        Console.WriteLine("At row " & (row + 1) & ", column " & (column + 1) &
               " the value is '" & dataTable.Rows(row).ItemArray(column) & "'")
    Next
Next

// Create an instance of the class that reads CSV files
ExcelDocument workbook = new ExcelDocument();

// Read CSV file to DataSet
DataSet dataSet = 
        workbook.easy_ReadCSVFile_AsDataSet("C:\\Samples\\CSV to DataSet.csv");

// Display imported DataSet values
DataTable dt = dataSet.Tables[0];
for (int row=0; row < dt.Rows.Count; row++)
    for (int column=0; column < dt.Columns.Count; column++)
             Console.WriteLine("At row " + (row + 1) + ", column " + (column + 1) + 
                  " the value is '" + dt.Rows[row].ItemArray[column] + "'");

' Create an instance of the class that reads CSV files
Dim workbook As New ExcelDocument

' Read CSV file to DataSet
Dim dataSet As DataSet = workbook.easy_ReadCSVFile_AsDataSet(
                         "C:\Samples\CSV to DataSet.csv")

' Display imported DataSet values
Dim dt As DataTable = dataSet.Tables(0)
For row As Integer = 0 To dt.Rows.Count - 1
    For column As Integer = 0 To dt.Columns.Count - 1
        Console.WriteLine("At row " & (row + 1) & ", column " & (column + 1) &
               " the value is '" & dt.Rows(row).ItemArray(column) & "'")
    Next
Next

// Create an instance of the class that reads CSV files
ExcelDocument workbook = new ExcelDocument();

// Read CSV file to ResultSet
ResultSet resultSet = workbook.easy_ReadCSVFile_AsResultSet(
                               "C:\\Samples\\CSV to ResultSet.csv");
   
// Display imported ResultSet values
int columnCount = resultSet.getMetaData().getColumnCount();
int row = 0;
while (resultSet.next()){
    for (int column=1; column < columnCount+1; column++)
        System.out.println("At row " + (row + 1) + ", column " + (column) + 
                " the value is '" + resultSet.getString(column) + "'");
    row++;
}

<!-- Create an instance of the class that reads CSV files -->
<cfobject type="java" class="EasyXLS.ExcelDocument" name="workbook" action="CREATE">

<!-- Read CSV file to ResultSet -->
<cfset resultSet = workbook.easy_ReadCSVFile_AsResultSet(
                            "C:\Samples\CSV to ResultSet.csv")>

<!-- Confirm reading -->
<cfset sError = workbook.easy_getError()>
<CFIF (sError  IS "")>
    <cfoutput>
        <!-- Display imported ResultSet values -->
        <cfset row = 0>
        <cfloop condition="#resultSet.next()#">
            <cfset columnCount = resultSet.getMetaData().getColumnCount()>
            <cfloop from="1" to="#columnCount-1#" index="column">
                <cfoutput>
                    At row #evaluate(row + 1)#, column #evaluate(column + 1)# 
                        the value is '#resultSet.getString(JavaCast("int",column))#'<br>
                </cfoutput>
            </cfloop>
            <cfset row = row + 1>
        </cfloop>
    </cfoutput>
<CFELSE>
    <cfoutput>
        Error encountered:  #sError#
    </cfoutput>
</CFIF>

# Create an instance of the class that reads CSV files
workbook = gateway.jvm.ExcelDocument()

# Read CSV file to ResultSet
resultSet = workbook.easy_ReadCSVFile_AsResultSet("C:\\Samples\\CSV to ResultSet.csv")

# Display imported ResultSet values
columnCount = resultSet.getMetaData().getColumnCount()

row = 0
while resultSet.next():
    for column in range(columnCount):
        print("At row " + str(row + 1) + ", column " + str(column+1) +
              " the value is '" + resultSet.getString(column+1) + "'")
    row=row+1

// Create an instance of the class that reads CSV files
ExcelDocument workbook = new ExcelDocument();

// Read CSV file to List
EasyXLS.Util.List rows = 
        workbook.easy_ReadCSVFile_AsList("C:\\Samples\\CSV to List.csv");

// Display imported List values
EasyXLS.Util.List row;
for (int rowIndex=0; rowIndex < rows.size(); rowIndex++)
{
    row = (EasyXLS.Util.List)rows.elementAt(rowIndex);
    for (int cellIndex=0; cellIndex < row.size(); cellIndex++)
    {
        Console.WriteLine("At row " + (rowIndex + 1) + 
            ", column " + (cellIndex + 1) 
            + " the value is '" + row.elementAt(cellIndex));
    }
}

' Create an instance of the class that reads CSV files
Dim workbook As New ExcelDocument

' Read CSV file to List
Dim rows = workbook.easy_ReadCSVFile_AsList("C:\Samples\CSV to List.csv")

' Display imported List values
Dim row
For rowIndex As Integer = 0 To rows.size() - 1
    row = rows.elementAt(rowIndex)
    For cellIndex As Integer = 0 To row.size() - 1
        Console.WriteLine(vbCrLf & "At row " & (rowIndex + 1) & ", column " _
            & (cellIndex + 1) & " the value is '" & row.elementAt(cellIndex))
    Next
Next

C++
// Create an instance of the class that reads CSV files
EasyXLS::IExcelDocumentPtr workbook;
hr = CoCreateInstance(__uuidof(EasyXLS::ExcelDocument),
		      NULL,
		      CLSCTX_ALL,
		      __uuidof(EasyXLS::IExcelDocument),
		      (void**) &workbook);
		
// Read CSV file to List
EasyXLS::IListPtr rows = 
        workbook->easy_ReadCSVFile_AsList("C:\\Samples\\CSV to List.csv");

// Display imported List values
for (int rowIndex=0; rowIndex<rows->size(); rowIndex++)
{
    EasyXLS::IListPtr row = (EasyXLS::IListPtr) rows->elementAt(rowIndex);
    for (int cellIndex=0; cellIndex<row->size(); cellIndex++)
    {
        printf("At row %d, column %d the value is '%s'\n", 
            (rowIndex+ 1), (cellIndex+ 1), 
            (LPCSTR)((_bstr_t)row->elementAt(cellIndex)));
    }
}


C++.NET

// Create an instance of the class that reads CSV files
ExcelDocument ^workbook = gcnew ExcelDocument();

// Read CSV file to List
EasyXLS::Util::List ^rows = 
    workbook->easy_ReadCSVFile_AsList("C:\\Samples\\CSV to List.csv");

// Display imported List values
EasyXLS::Util::List ^row;
StringBuilder ^str;
for (int rowIndex=0; rowIndex < rows->size(); rowIndex++)
{
    row = safe_cast<EasyXLS::Util::List^>(rows->elementAt(rowIndex));
    for (int cellIndex=0; cellIndex < row->size(); cellIndex++)
    {
        str = gcnew StringBuilder();
        str->Append(String::Concat("At row ", (rowIndex + 1).ToString(), 
                                    ", column ", (cellIndex + 1).ToString()));
        str->Append(String::Concat(" the value is '",
            row->elementAt(cellIndex)->ToString()));
        Console::WriteLine(str);
    }
}

// Create an instance of the class that reads CSV files
ExcelDocument workbook = new ExcelDocument();

// Read CSV file to List
EasyXLS.Util.List rows = 
        workbook.easy_ReadCSVFile_AsList("C:\\Samples\\CSV to List.csv");

// Display imported List values
EasyXLS.Util.List row;
for (int rowIndex=0; rowIndex < rows.size(); rowIndex++)
{
    row = (EasyXLS.Util.List)rows.elementAt(rowIndex);
    for (int cellIndex=0; cellIndex < row.size(); cellIndex++)
    {
        System.out.println("At row " + (rowIndex + 1) + 
                           ", column " + (cellIndex + 1) + 
                           " the value is '" + row.elementAt(cellIndex));
    }
}

.NET:

// Create an instance of the class that reads CSV files
$workbook = new COM("EasyXLS.ExcelDocument");
	
// Read CSV file to List
$rows = $workbook->easy_ReadCSVFile_AsList("C:\\Samples\\CSV to List.csv");

// Display imported List values
for ($rowIndex=0; $rowIndex<$rows->size(); $rowIndex++)
{
    $row = $rows->elementAt($rowIndex);
    for ($cellIndex=0; $cellIndex<$row->size(); $cellIndex++)
    {
        echo "At row ".($rowIndex + 1).", column ".($cellIndex + 1).
                     " the value is '".$row->elementAt($cellIndex)."'<br>";
    }
}


Java:

// Create an instance of the class that reads CSV files
$workbook = new java("EasyXLS.ExcelDocument");

// Read CSV file to List
$rows = $workbook->easy_ReadCSVFile_AsList("C:\\Samples\\CSV to List.csv");

// Display imported List values
for ($rowIndex=0; $rowIndex<(int)(string)$rows->size(); $rowIndex++)
{
    $row = $rows->elementAt($rowIndex);
    for ($cellIndex=0; $cellIndex<(int)(string)$row->size(); $cellIndex++)
    {
        echo "At row ".($rowIndex + 1).", column ".($cellIndex + 1).
             " the value is '".$row->elementAt($cellIndex)."'<br>";
    }
}

' Create an instance of the class that reads CSV files
set workbook = Server.CreateObject("EasyXLS.ExcelDocument")

' Read CSV file to List
set rows = workbook.easy_ReadCSVFile_AsList("C:\Samples\CSV to List.csv")

' Display imported List values
for rowIndex = 0 to rows.size() - 1
    set row = rows.elementAt(rowIndex)
    for cellIndex = 0 to row.size - 1
        response.write("At row " & (rowIndex + 1) & _
                       ", column " & (cellIndex + 1) & _
                       " the value is '" & row.elementAt(cellIndex) & "'<br>")
    next
next

' Create an instance of the class that reads CSV files
Set workbook = CreateObject("EasyXLS.ExcelDocument")

' Read CSV file to List
Set rows = workbook.easy_ReadCSVFile_AsList("C:\Samples\CSV to List.csv"")

' Display imported List values
For rowIndex = 0 To rows.Size() - 1
    Set row = rows.elementAt(rowIndex)
    For cellIndex = 0 To row.Size - 1
        Me.Text1 = Me.Text1 & _
                    "At row " & (rowIndex + 1) & ", column " & (cellIndex + 1) & _
                    " the value is '" & row.elementAt(cellIndex) & "'" & vbCrLf
    Next
Next

' Create an instance of the class that reads CSV files
set workbook = CreateObject("EasyXLS.ExcelDocument")

' Read CSV file to List
Set rows = workbook.easy_ReadCSVFile_AsList("C:\Samples\CSV to List.csv")

' Display imported List values
For rowIndex = 0 To rows.Size() - 1
    Set row = rows.elementAt(rowIndex)
    For cellIndex = 0 To row.Size - 1
        WScript.StdOut.WriteLine("At row " & (rowIndex + 1) & _
                                 ", column " & (cellIndex + 1) & _
                                 " the value is '" & row.elementAt(cellIndex) & "'")
    Next
Next

<!-- Create an instance of the class that reads CSV files -->
<cfobject type="java" class="EasyXLS.ExcelDocument" name="workbook" action="CREATE">

<!-- Read CSV file to List -->
<cfset rows = workbook.easy_ReadCSVFile_AsList("C:\Samples\CSV to List.csv")>

<!-- Display imported List values -->
<cfobject type="java" class="EasyXLS.Util.List" name="row" action="CREATE">
<cfloop from="0" to="#rows.size()-1#" index="rowIndex">
    <cfset row = rows.elementAt(rowIndex)>
    <cfloop from="0" to="#row.size()-1#" index="cellIndex">
        <cfoutput>
            At row #evaluate(rowIndex + 1)#, column #evaluate(cellIndex + 1)# 
            the value is '#row.elementAt(cellIndex)#'<br>
        </cfoutput>
    </cfloop>
</cfloop>

.NET:

# Create an instance of the class that reads CSV files
workbook = ExcelDocument()

# Read CSV file to List
rows = workbook.easy_ReadCSVFile_AsList("C:\\Samples\\CSV to List.csv")

# Display imported List values
for rowIndex in range(rows.size()):
    row = rows.elementAt(rowIndex)
    for cellIndex in range(row.size()):
        print("At row " + str(rowIndex + 1) + ", column " + str(cellIndex + 1) + 
              " the value is '" + str(row.elementAt(cellIndex)) + "'"


Java:

# Create an instance of the class that reads CSV files
workbook = gateway.jvm.ExcelDocument() 

# Read CSV file to List
rows = workbook.easy_ReadCSVFile_AsList("C:\\Samples\\CSV to List.csv")

# Display imported List values
for rowIndex in range(rows.size()):
    row = rows.elementAt(rowIndex)
    for cellIndex in range(row.size()):
        print("At row " + str(rowIndex + 1) + ", column " + str(cellIndex + 1) + 
              " the value is '" + str(row.elementAt(cellIndex)) + "'")