Excel > POI > MySQL - Please Help

[edparker]

I've hit a roadblock with using the integrated Apache POI (CFMX 7). My goal is
to be able to upload an XLS file into the system via cffile and then process
it with POI. I have everything working and can kick out a copied Excel file,
but can't figure out how to enter this data into my data table. I know a quick
fix would be to convert the XLS file to CSV and do that, but I'd really prefer
to stick with POI and utilitze some of its power.

Any help would be greatly appreciated.

Thanks,
Ed

[edparker]

This is as far as I got.

<cfcomponent output="false">
<cffunction name="importExcel" output="true">
<cfset fileIn =
createObject("java","java.io.FileInputStream").ini t("C:\poi_test.xls")/>
<cfset fs =
createObject("java","org.apache.poi.poifs.filesyst em.POIFSFileSystem").init(file
In)/>
<cfset wb =
createObject("java","org.apache.poi.hssf.usermodel .HSSFWorkbook").init(fs)/>
<cfset sheet = wb.getSheetAt(0)/>
<cfset row = sheet.createRow(0)/>
<cfset cell = row.getCell(3)/>
</cffunction>
</cfcomponent>