Example of using JavaCSV CSVReader class to read CSV files

A discussion on cf-talk today led to suggest the use of CsvReader to someone, and since I'd never used it before, I thought I'd write some sample code (I've only used CsvWriter)

This code assumes you've put the csvreader library in the coldfusion classpath but you could use JavaLoader too.

More about the JavaCSV library: http://www.csvreader.com/java_csv.php

<cfset filename = "#replace(ExpandPath("."),"\","/","ALL")#/test.csv">
<cfset fileInput = createObject("java","com.csvreader.CsvReader")>
<cfset fileInput.init(filename)>

<cfset cnt = 0>
<cfloop condition="#fileInput.readRecord()#">
	<cfset cols = fileInput.getColumnCount()>
	<cfif not isDefined("result")>
		<cfset columnlist = "rowNum">
		<cfloop from="1" to="#cols#" step="1" index="col">
			<cfset columnlist = listAppend(columnList,"col#col#")>
		</cfloop>
		<cfset result = queryNew(columnlist)>
	</cfif>
	<cfset QueryAddRow(result)>
	<cfset querySetCell(result,"rowNum",col)>
	<cfloop from="1" to="#cols#" step="1" index="col">
		<cfset val = fileInput.get(javacast("int",col-1))>
		<cfset querySetCell(result,"col#col#",val)>
	</cfloop>
	<cfif cnt gt 100><cfbreak></cfif>
</cfloop>
<cfset fileInput.close()>
<cfdump var="#result#">