CFScript – Converting an Excel Sheet to a Query

I just posted about an issue I had when importing an Excel file to the database here.

In that project I used a function written by Silverink Consulting. The article is called CFSpreadsheet in cfscript. The hard way and I recommend you check it out.

You just add the function, call it with:

resultQuery = ExcelToQuery(params.thefile);

and it just works!

Just wanted to document it here since I found it very useful.

Leave a comment