DEV Community

loading...

Convert CSV File to Coldfusion Query Object using ColdFusion & opencsv (Java)

gamesover profile image James Moberg ・1 min read

I encountered some problems with ColdFusion 8/9/10 reading a CSV file that was created using Excel. The only solution that worked involved using opencsv, a Java parsing library. Here's the CFML code that I used to convert the results (a 2 dimensional array) to a ColdFusion query. (NOTE: OpenCSV is also the best solution if your Excel file has multi-line data in columns.)

NOTE: This is a Tumblr repost from 2013.

Discussion

pic
Editor guide