If the file was successfully uploaded, I use isSpreadsheetFile() to determine if the file was a valid spreadsheet. This covers XLS, XLSX, and even OpenOffice documents. If it is a valid spreadsheet, I read it in using the cfspreadsheet tag. Notice the last two arguments. The query argument tells ColdFusion to parse the spreadsheet data into a query.
![Coldfusion Export Excel File Coldfusion Export Excel File](/uploads/1/2/5/5/125576766/668407868.png)
ColdFISH is developed by Jason Delmore. Source code and license information available at
And what if you needed a total cell containing a formula to SUM the total column? Here's a complete example.