Import Excel file to ResultSet in Java

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

// Import Excel file to ResultSet
FileInputStream file = new FileInputStream("C:\\Samples\\Tutorial09.xlsx");
ResultSet resultSet = workbook.easy_ReadXLSXActiveSheet_AsResultSet(file);
   
// 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 imports Excel files -->
<cfobject type="java" class="EasyXLS.ExcelDocument" name="workbook" action="CREATE">

<!-- Import Excel file to List -->
<cfset rs = workbook.easy_ReadXLSXActiveSheet_AsResultSet("C:\Samples\Tutorial09.xlsx")>

<!-- Confirm reading -->
<cfset sError = workbook.easy_getError()>
<CFIF (sError  IS "")>
    <cfoutput>
        <!-- Display imported List values -->
        <cfset row = 0>
        <cfloop condition="#rs.next()#">
            <cfset columnCount = rs.getMetaData().getColumnCount()>
            <cfloop from="1" to="#columnCount-1#" index="column">
                <cfoutput>
                    At row #evaluate(row + 1)#, column #evaluate(column + 1)# 
                        the value is '#rs.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 imports Excel files
workbook = gateway.jvm.ExcelDocument()

# Import Excel file to ResultSet
file = gateway.jvm.FileInputStream("C:\\Samples\\Tutorial09.xlsx")
rs = workbook.easy_ReadXLSXActiveSheet_AsResultSet(file)

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

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

Click here to see Continuous Code Listing