Import Excel file to List in .NET, Java and other programming languages

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

// Import Excel file to List
EasyXLS.Util.List rows = 
        workbook.easy_ReadXLSXActiveSheet_AsList("C:\\Samples\\Tutorial09.xlsx", true);

// Confirm Excel file import
if (workbook.easy_getError() == "")
{
    // 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));
        }
    }
}	
else
    Console.Write("Error importing Excel file C:\\Samples\\Tutorial09.xlsx " + 
            workbook.easy_getError());

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

' Import Excel file to List
Dim rows = workbook.easy_ReadXLSXActiveSheet_AsList("C:\Samples\Tutorial09.xlsx", true)

' Confirm Excel file import
If (workbook.easy_getError().Equals("")) Then
    ' 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
Else
    Console.Write(vbCrLf & _
        "Error importing Excel file C:\Samples\Tutorial09.xlsx " & _
        workbook.easy_getError())
End If

C++

// Create an instance of the class that imports Excel files
EasyXLS::IExcelDocumentPtr workbook;
hr = CoCreateInstance(__uuidof(EasyXLS::ExcelDocument),
                      NULL,
                      CLSCTX_ALL,
                      __uuidof(EasyXLS::IExcelDocument),
                      (void**) &workbook);
		
// Import Excel file to List
EasyXLS::IListPtr rows = 
        workbook->easy_ReadXLSXActiveSheet_AsList_7("C:\\Samples\\Tutorial09.xlsx", 
                                                    true);

// Confirm Excel file import
_bstr_t sError = workbook->easy_getError();
if (strcmp(sError, "") == 0)
{
    // 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)));
        }
    }
    printf("\nPress Enter to exit ...");
}
else
    {
        printf("\nError importing Excel file C:\\Samples\\Tutorial09.xlsx %s\n", 
                (LPCSTR)sError); 
    }


C++.NET

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

// Import Excel file to List
EasyXLS::Util::List ^rows = 
    workbook->easy_ReadXLSXActiveSheet_AsList("C:\\Samples\\Tutorial09.xlsx", true);

// Confirm Excel file import
String ^sError = workbook->easy_getError();
if (sError->Equals(""))
{
    // 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);
        }
    }
}
else
    Console::WriteLine(String::Concat(
        "\nError importing Excel file C:\\Samples\\Tutorial09.xlsx \n", sError));

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

// Import Excel file to List
EasyXLS.Util.List rows = 
        workbook.easy_ReadXLSXActiveSheet_AsList("C:\\Samples\\Tutorial09.xlsx", true);

// Confirm Excel file import
if (workbook.easy_getError().equals(""))
{
    // Display the 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));
        }
    }
}	
else
    System.out.println("Error importing Excel file C:\\Samples\\Tutorial09.xlsx " + 
                                workbook.easy_getError());

COM+:

// Create an instance of the class that imports Excel files
$workbook = new COM("EasyXLS.ExcelDocument");
	
// Import Excel file to List
$rows = $workbook->easy_ReadXLSXActiveSheet_AsList_7("C:\\Samples\\Tutorial09.xlsx", 
                                                     true);

// Confirm Excel file import
if ($workbook->easy_getError() == "")
{
    // 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>";
        }
    }
}
else
    echo "Error importing Excel file C:\Samples\Tutorial09.xlsx " . 
                        $workbook->easy_getError();

Click here to see Continuous Code Listing


Java:

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

// Import Excel file to List
$rows = $workbook->easy_ReadXLSXActiveSheet_AsList("C:\\Samples\\Tutorial09.xlsx", true);

// Confirm Excel file import
if ($workbook->easy_getError() == "")
{
    // 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>";
        }
    }
}	
else
    echo "Error importing Excel file C:\Samples\Tutorial09.xlsx " . 
                         $workbook->easy_getError();

Click here to see Continuous Code Listing

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

' Import Excel file to List
set rows = workbook.easy_ReadXLSXActiveSheet_AsList_7("C:\Samples\Tutorial09.xlsx", true)

' Confirm Excel file import
if workbook.easy_getError() = "" then
    ' 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
else
    response.Write("Error importing Excel file C:\Samples\Tutorial09.xlsx " & _
                                                      workbook.easy_getError())
end if

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

' Import Excel file to List
Set rows = workbook.easy_ReadXLSXActiveSheet_AsList_7("C:\Samples\Tutorial09.xlsx", True)

' Confirm Excel file import
If workbook.easy_getError() = "" Then
    ' 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
Else
    Me.Text1 = Me.Text1 & _
               vbCrLf & "Error importing Excel file C:\Samples\Tutorial09.xlsx " & _
               vbCrLf & workbook.easy_getError()
End If

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

' Import Excel file to List
Set rows = workbook.easy_ReadXLSXActiveSheet_AsList_7("C:\Samples\Tutorial09.xlsx", True)

' Confirm Excel file import
if workbook.easy_getError() = "" then
    ' 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
else
    WScript.StdOut.Write(vbcrlf & _
        "Error importing Excel file C:\Samples\Tutorial09.xlsx " & _
        workbook.easy_getError())
end if

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

<!-- Import Excel file to List -->
<cfset rows = workbook.easy_ReadXLSXActiveSheet_AsList("C:\Samples\Tutorial09.xlsx", 
                                                       JavaCast("boolean", true))>

<!-- Confirm Excel file import -->
<cfset sError = workbook.easy_getError()>
<CFIF (sError  IS "")>
    <cfoutput>
        <!-- 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>
    </cfoutput>
<CFELSE>
    <cfoutput>
        Error importing Excel file:  #sError#
    </cfoutput>
</CFIF>

.NET:

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

# Import Excel file to List
rows = workbook.easy_ReadXLSXActiveSheet_AsList("C:\\Samples\\Tutorial09.xlsx", True)

# Confirm Excel file import
sError = workbook.easy_getError()

if sError == "":
    # 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)) + "'")
else:
    print("\nError importing Excel file C:\\Samples\\Tutorial09.xlsx" + sError + "\n\n")

# Dispose memory
gc.collect()


Java:

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

# Import Excel file to List
rows = workbook.easy_ReadXLSXActiveSheet_AsList("C:\\Samples\\Tutorial09.xlsx", True)

# Confirm Excel file import
sError = workbook.easy_getError()

if sError == "":
    # 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)) + "'")
else:
    print("\nError importing Excel file C:\\Samples\\Tutorial09.xlsx" + sError + "\n\n")

# Dispose memory
gc.collect()