EasyXLS

How to import data from Excel to ResultSet in ColdFusion

<!--
===================================================================
Tutorial 34

This tutorial shows how to import Excel to ResultSet in ColdFusion.
is imported from the active sheet of the Excel file (the Excel file 
generated in Tutorial 09).
===================================================================
-->

Tutorial 34<br>
----------<br>

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

<!-- Import Excel to ResultSet -->
Reading file C:\Samples\Tutorial09.xls<br><br>
<cfset rs = workbook.easy_ReadXLSActiveSheet_AsResultSet("C:\Samples\Tutorial09.xls")>

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

<!-- Dispose memory -->
<cfset workbook.Dispose()>

EasyXLS Excel libraries:

Java
Excel Library for ColdFusion
full Java version to import, export or convert Excel files
Excel Reader for ColdFusion
Java version to read and import Excel files
Download EasyXLS™ Excel Library for ColdFusion

File formats:

MS Excel 97 - 2003
MS Excel 2007 - 2010
MS Excel 2013
MS Excel 2016
MS Excel 2019
XLSX XLSM XLSB XLS
XML HTML CSV TXT